Chat with us, powered by LiveChat IT405 E-portals development - Essayabode

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): Question One 2 Marks Build web applications Create the following relational tables by using SQL commands. using PHP and MySQL Add screenshots of the three created tables. Marking Criteria 1.5 mark for SQL commands 0.5 mark for the screenshot Restricted – ‫مقيد‬ Question Two Learning Outcome(s): Question Two 2 Marks Use the technique you have learned in the class to debug the following code Describe methods and tools in designing a creative and dynamic website. 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 – ‫مقيد‬ 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 – ‫مقيد