KFU E-Portal System Worksheet

Classification: Mobily INTERNAL USECollege of Computing and Informatics
Assignment #2
Deadline: Tuesday 30/05/2023 @ 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.
INTERNAL USE
Pg.Classification:
01
Mobily INTERNAL USE
Question One
Learning
Outcome(s):
Question One
Create web
databases using
MySQL.
Suppose you want to build a web application for a new perfume shop;
Therefore, you need to represent all information regarding the products and
save it; To accomplish that, write a PHP code that:
3 Marks
1. Creates a database which is called PerfumeShop.
2. Within the previous database, creates a Product table to save products
information: (Id, ProductName, Price).
Marking Criteria:
– Creating Database code. (1 mark)
– Creating a table code. (1 mark)
– Screenshots (1 mark)
INTERNAL USE
Pg.Classification:
02
Mobily INTERNAL USE
Learning
Outcome(s):
Build web
Question Two
Question Two
By using the previous PerfumeShop database, write a PHP code that inserts
three products to the table Product.
applications using
PHP and MySQL.
1 Marks
Marking Criteria
– PHP code. (0.5 mark)
– Screenshots. (0.5 mark)
INTERNAL USE
Pg.Classification:
03
Mobily INTERNAL USE
Learning
Outcome(s):
Build web
Question Three
Question Three
1 Marks
By using the previous PerfumeShop database, write a PHP code that deletes
one product from the database.
applications using
PHP and MySQL.
Marking Criteria
–
PHP code. (0.5 mark)
Screenshots. (0.5 mark)
INTERNAL USE
Pg.Classification:
04
Mobily INTERNAL USE
Learning
Outcome(s):
Build web
applications using
PHP and MySQL.
Question Four
Question Four
3 Marks
Write a PHP code that creates a contact form for the customers to let them
contact the Perfume shop by email. When a user clicks on the Send! button,
an email will be sent to Perfume Shop email.
Note:
– You should take 2 screenshots.
–
Use your own email as the Perfume Shop email.
Fill the form as a customer (Screenshot number 1) and show the
received message in your email (Screenshot number 2).
Marking Criteria
– HTML form. (1 mark)
– PHP code. (1 mark)
– Screenshots. (1 mark)
INTERNAL USE