IT 405-E Portals Development Computer Programming Task- Saudi Electronic University .
College of Computing and Informatics E-Portals Development IT-405 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. Question One Pg. 01 Learning Outcome(s): Create web databases using MySQL. Question One 1.5 Marks By using MySQL, create a “Blood_Bank” database, the database has three tables: Donors, Blood, and Clinics. – The Donor relation has the following attributes: DID, Name, Email, Gender. – The Clinic relation has the following attributes: CID, Name, Location. – The Blood relation has the following attributes: BID, Type, DID, CID. Note: You should Include the SQL queries and the screenshots. Question Two Pg. 02 Learning Outcome(s): Question Two 1 Mark Insert data to all relations that you have created in the first question. Create web databases using MySQL. Note: You should insert at least 2 tuples in each table. Add the SQL queries and the screenshots. Question Three Pg. 03 Learning Outcome(s): Describe methods and tools in designing a creative and dynamic website. Question Three 1.5 Marks 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; Question Four Pg. 05 Learning Outcome(s): Build web applications using PHP and MySQL. Question Four 1 Mark You need to use PHP to connect the database you have created in the first question. You will need to enter the username and password for database. The default username is root and the password is empty string (leave it blank). Note: Include the code and the screenshots. Learning PHP, MySOL, & JavaScript WITH JQUERY, CSS & HTML5 Learning PHP, MySOL, & JavaScript WITH JQUERY, CSS & HTML5
