IT 405 Saudi Electronic University Programming Worksheet

College of Computing and InformaticsE-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)