Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

MySQL Question

Description

College of Computing and Informatics
Assignment 2
Deadline: Sunday 05/05/2024 @ 23:59
[Total Mark for this Assignment is 8]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:
• You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
• It is your responsibility to check and make sure that you have uploaded both the correct files.
• Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between
words, hide characters, use different character sets, convert text into image or languages other than English
or any kind of manipulation).
• Email submission will not be accepted.
• You are advised to make your work clear and well-presented. This includes filling your information on the cover
page.
• You must use this template, failing which will result in zero mark.
• You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
• Late submission will result in ZERO mark.
• The work should be your own, copying from students or other resources will result in ZERO mark.
• Use Times New Roman font for all your answers.
Restricted – ‫مقيد‬
Question One
Learning Outcome(s):
Build web applications
using PHP and MySQL
Restricted – ‫مقيد‬
Question One
2 Marks
Create the following relational tables by using SQL commands.
Add screenshots of the three created tables.
Marking Criteria
1.5 mark for SQL commands
0.5 mark for the screenshot
Question Two
Learning
Outcome(s):
Describe methods
and tools in
designing a creative
and dynamic
website.
Question Two
Use the technique you have learned in the class to debug the following code
and correct the error. Explain your steps in details.
PHP Excercise
.error{
font-weight: bold;
color: #C00;}
Assignment 1
Enter your first and last name
Font-wieght =22;
Restricted – ‫مقيد‬
2 Marks
Question Three
Learning Outcome(s):
Question Three
Build web applications
You have a table called users in MySQL database called IT405. The table
using PHP and MySQL
has the following data:
4 Marks
Id
Name
Address
1
Ali
Jeddah
2
Salah
Riyadh
Write a PHP code that output the following display:
3 @@@ Dammam
1 @@@ Jeddah
2 @@@ Riyadh
Note that the username is root, the password is empty string. You can
insert data in the table before the display.
Restricted – ‫مقيد‬

Purchase answer to see full
attachment

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

mng201,dosary

Description I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements. Errors are not

mng323.dosary

Description I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements. Errors are not

mng322.dosary

Description I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements. Errors are not

mng324,dosary

Description I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements. Errors are not

mng325.dosary

Description I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements. Errors are not

mng401,dosary

Description I want a correct and complete solution for all paragraphs. I must adhere to the instructions. I don’t want plagiarism. I don’t want similarities. I don’t want a solution using artificial intelligence. I want a correct solution. Put the solution inside the file. Include all requirements. Errors are not

214 ASS 5

Description see Saudi Electronic University College of Health Sciences Health Informatics Department Heuristic Evaluation Guide This guide utilizes Jakob Nielsen’s Heuristic Evaluation principles as its framework, providing practical examples to illustrate each principle and enhance understanding. Saudi Electronic University College of Health Sciences Health Informatics Department What is Heuristic Evaluation?

discussion ECN500

Description Labor Migration’s Economic Impact Using the Heckscher-Ohlin-Samuelson model, discuss how a surge in low-skilled migrant workers could influence wage gaps in high-income countries. Do real-world migration patterns align with these predictions? Piyapromdee (2020) suggests internal migration helps offset wage losses for native workers. Discuss how this finding challenges classical

i want ppt solve

Description topic ;Digital Breast Tomosynthesis (DBT): advances in breast cancer detectior The most important thing is that the poster is exactly as the doctor requested and not in AI format, and that the references are correct and open. Send me the magazine you got it from so I can read

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Logistics Management (MGT 322) Due Date: 01/11/2025 @ 23:59 Course Name: Logistics Management Course Code: MGT322 Student’s Name: Semester: 1st CRN: Student’s ID

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Introduction to International Business (MGT 321) Due Date: 01/11/2025 @ 23:59 Course Name: Introduction to International Business Course Code: MGT-321 Student’s Name: Semester:

181 ass 4

Description ase College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Sociology of Health, Illness and Healthcare Course number: PHC181 CRN XXX Analysis of Health Disparities Assignment title or task: Part 1: Choose a social category (e.g., socioeconomic status, race/ethnicity, gender) and explain how it affects

374 ASS 11

Description see ASSIGNMENT COVER SHEET Course name ORAL HEALTH PROMOTION Course number PHC 374 CRN XXXXX Evidence-based practice (EBP) integrates the best current research with clinical expertise and community needs to improve oral health outcomes. Evidence-Based Practices in Oral Health In this short paper, you will explore one evidence based

313 ass 10

Description see ASSIGNMENT COVER SHEET Course name: Road Traffic Injuries and Diseases Course number: PHC313 CRN: 11021 Write a short essay to discuss risk factors associated with road crashes and injury severity in the Kingdom of Saudi Arabia Assignment title or task: (You can write a question) ➢ What is