College of Computing and InformaticsName: ###
ID: ###
CRN: ###
Instructions:
1.
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.
2.
It is your responsibility to check and make sure that you have uploaded both the correct files.
3.
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).
4.
Email submission will not be accepted.
5.
You are advised to make your work clear and well-presented. This includes filling your information on the cover
page.
6.
You must use this template, failing which will result in zero mark.
7.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
8.
Late submission will result in ZERO mark.
9.
The work should be your own, copying from students or other resources will result in ZERO mark.
10.
Use Times New Roman font for all your answers.
Pg. 1
خطأ! استخدم عالمة التبويب “الصفحة الرئيسية” لتطبيقHeading 1
على النص الذي ترغب في أن يظهر هنا.
Learning Outcome
(3):
Question One
3 Marks
Create EntityRelationship model,
Relational model,
and write SQL
queries.
Consider a hypothetical online management system for the Saudi Electronic
University that uses a relational database to manage its operations. This system
needs to keep track of information about students (including student ID, name,
major, and email), courses (including course ID, name, instructor, and
department), and enrollments (including enrollment ID, student ID, course ID,
grade, and semester).
Describe how you would design the relational model for this system. What tables
would you create? What attributes would each table have? How would you use
primary and foreign keys to represent relationships between the tables?
Answer:
Pg. 2
Learning Outcome
(3):
Create EntityRelationship model,
Relational model,
and write SQL
queries.
خطأ! استخدم عالمة التبويب “الصفحة الرئيسية” لتطبيقHeading 1
على النص الذي ترغب في أن يظهر هنا.
Question Two
2 Marks
Consider a database system for SEU that stores information about students,
courses, faculty, and course enrollments. A student has a unique ID, name,
major, and email. Each course has a unique course ID, name, department, and
credits. Faculty members have unique faculty IDs, names, departments, and
specializations. An enrollment associates a student, a course, a faculty member
(as the instructor), and a semester. One student can enroll in multiple courses,
but each enrollment is for only one course. A faculty member can instruct many
courses, and each course can have multiple students enrolled over different
semesters.
Based on this description, create the ER diagram.
Answer:
Pg. 3
خطأ! استخدم عالمة التبويب “الصفحة الرئيسية” لتطبيقHeading 1
على النص الذي ترغب في أن يظهر هنا.
2 Marks
Question Three
Learning Outcome
(3):
Create EntityRelationship model,
Relational model,
Define the Entity Integrity Constraint and Referential Integrity Constraint then
explain their differences in a relational database. Explain why the DELETE
operation may violate only the referential integrity and not the entity constraint.
Provide examples to illustrate each constraint using the database system for
SEU from question 1.
and write SQL
queries.
Answer:
Heading 1خطأ! استخدم عالمة التبويب “الصفحة الرئيسية” لتطبيق
.على النص الذي ترغب في أن يظهر هنا
1 Mark
Question Four
Pg. 4
Pg. 5
خطأ! استخدم عالمة التبويب “الصفحة الرئيسية” لتطبيقHeading 1
على النص الذي ترغب في أن يظهر هنا.
Learning Outcome(s):
CLO1
Explain the concepts
and architectures
involved in the database
development.
Using your own words, explain two advantages of the Three Tier Client-Server
Pg. 6
خطأ! استخدم عالمة التبويب “الصفحة الرئيسية” لتطبيقHeading 1
على النص الذي ترغب في أن يظهر هنا.
Architecture over the Single Tier Centralized DBMS Architecture.
Answer:
