IT 405 Saudi Electronic University E Portals Development Computer Programming Task

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