You must submit two separate copies (one Word file and one PDF file) using the A

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.
3 Marks
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
Question One
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:
2 Marks
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
Question Two
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:
Learning
Outcome (3):
Create Entity-Relationship
model, Relational model, and write SQL queries.
2 Marks
Question Three
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.
Answer:
1 Mark
Question Four
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
Architecture over the Single Tier Centralized DBMS Architecture.
Answer:
please be careful of the note in the begininig and dont forgate the reference