Description
Hello, I hope you pay attention. I want correct and perfect work. I want all the questions to be solved correctly and completely without plagiarism. I emphasize this important point. Any percentage of plagiarism will lead to the cancellation of the work. I want a correct solution with references and maintaining the file format without any errors. If you are sure of yourself and that you will do the work correctly, accept the work and make sure of it and your capabilities.
Student information:
abdullah alghamdi
id : s190057210
crn:13026
Assignment 2
Deadline: Tuesday 26/11/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
Pg. 01
Learning
Outcome(s):
Create web
databases using
MySQL
Restricted – مقيد
Question One
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 screenshots
2 Marks
Question Two
Pg. 02
Learning
Outcome(s):
Describe methods
and tools in
designing a
creative and
Question Two
3 Marks
Use the technique you have learned in the class to debug the following code
and correct the errors. Explain your steps in details.
Marking Criteria
1.5 mark for explanation
1 mark for code
0.5 mark for screenshots
dynamic website.
PHP Excercise
.error{
font-weight: bold;
font-weight =22;
color: #C00;
}
Assignment 2
Enter your first and last name
Enter your id
Restricted – مقيد
Question Three
Pg. 04
Learning
Outcome(s):
Build web
Question Three
3 Marks
You have a table called users in MySQL database called IT405. The table has
the following data:
applications using
Id
Name
Address
1
Ahmed
Jeddah
2
Amal
Riyadh
PHP and MySQL
Write a PHP code that:
•
insert the data into the table (1.5 marks) and
•
outputs the data of the table according to the following display (1.5
marks):
1 @@@ Jeddah
2 @@@ Riyadh
Note that the username is root, the password is empty string.
Restricted – مقيد
Purchase answer to see full
attachment