IT 405-Programming Worksheet- Saudi Electronic University .

College of Computing and Informatics E-portal Development IT405 IT405-Project Deadline: Sunday 5/12/2021 @ 23:59 [Total Mark for this Assignment is 10] Students Details: Name: ### Name: ### Name: ### CRN: ### ID: ### ID: ### ID: ### 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. Pg. 01 Learning Outcome(s): 2.2 Create web databases using Project 10 Marks You have to create a small website based on an idea you will choose and adding dynamic content using PHP, and MYSQL server. The number of students in each group should be 2 or 3 students. You must make your own group and send the list of the students to your respective instructor. MySQL. 3.1 Build web applications using PHP and MySQL. Website Description State the descriptions of the intended website 1 SQL Create and populate a new database in MySQL (minimum 3 tables). 2 Select records from MySQL database using PHP 2 Insert records into MySQL database using PHP. 2.5 Update records into MySQL database using PHP 2.5 PHP+DB Total 10 Important Notes: • The number of PHP pages must be at least 6 • The Website must connect to a database (2 Select+ 2 Insert+ 2 Update queries) • Use the same theme across the website. Each student/group has to prepare 1. IT405_Project.docx: Pg. 02 a. The student must use the same file(IT405_Project.docx) to Learning Outcome(s): prepare his answer. b. For the SQL part, the student must copy and paste the SQL code 2.2 Create web used to create and populate the Database and add a screenshot databases using MySQL. of the different tables of the created database in MYSQL. c. For the part PHP +DB, the student must copy and paste the PHP 3.1 Build web code and add screenshots of the output with a brief explication of applications using each functionality of the web application. PHP and MySQL For the insertion and the update of the records, the student must also add screenshots of the modified tables before and after the execution of the PHP code. d. Prepare a PDF version of this file. 2. Project.zip: contains all the files of the whole project (HTML, PHP, and SQL). Student will upload: 1. IT405_Project.docx 2. IT405_Project.pdf 3. Project.zip Pg. 03 Learning Outcome(s): 2.2 Create web databases using MySQL. 3.1 Build web applications using PHP and MySQL 1 Mark Website Describtion Pg. 04 Learning Outcome(s): 2.2 Create web databases using MySQL. 3.1 Build web applications using PHP and MySQL 2 Marks SQL Pg. 05 Learning Outcome(s): 2.2 Create web databases using MySQL. 3.1 Build web applications using PHP and MySQL 2 Marks PHP+DB (SELECT) Pg. 06 Learning Outcome(s): 2.2 Create web databases using MySQL. 3.1 Build web applications using PHP and MySQL 2.5 Marks PHP+DB (INSERT) Pg. 07 Learning Outcome(s): 2.2 Create web databases using MySQL. 3.1 Build web applications using PHP and MySQL. 2.5 Marks PHP+DB (UPDATE)