Assignment 1
Deadline: Monday 29/9/2025 @ 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.
Restricted – مقيد
Question One
Pg. 01
Learning
Outcome (CLO1):
Explain the
concepts and
architectures
involved in the
database
development.
Question One
2 Marks
Saudi Electronic University is planning to build a new Student Information
Database System. The system must store data about students, instructors,
courses, and departments. As a database designer, you have been asked to
identify the different types of database users who will interact with this system.
Q1: Explain which types of database users (DBA, Database Designers, Casual
Users, Naïve Users, Sophisticated Users, Stand-alone Users) will be involved in
this project and describe their specific roles
.
Restricted – مقيد
Question Two
Pg. 02
Learning
Outcome (CLO1):
Explain the
concepts and
architectures
involved in the
database
development.
Restricted – مقيد
Question Two
2 Marks
A national airline company is designing a new Reservation Database System.
The system must handle booking transactions from multiple online users while
ensuring program-data independence.
Q: Explain how the Three-Schema Architecture (internal, conceptual, and
external schemas) will help the airline company achieve data independence and
support multiple user views.
Question Three
Pg. 03
Learning
Outcome(CLO3):
Create EntityRelationship
model, Relational
model, and write
SQL queries
Restricted – مقيد
Question Three
2 Marks
Consider the ER modeling of university enrollment with entities
STUDENT(SSN, Name) and COURSE(CourseID, Title) and a relationship
ENROLL with attribute Grade.
a) State the degree of ENROLL and indicate whether Grade is an entity
attribute or a relationship attribute.
b) Draw an ER diagram showing STUDENT, COURSE, and ENROLL.
Underline all keys and include all attributes.
Question Four
Pg. 04
Learning
Outcome (CLO3):
Create EntityRelationship
model, Relational
model, and write
SQL queries
Restricted – مقيد
Question Four
2 Marks
Consider the relation ENROLL(StudentID, CourseID, Grade) with the rule that
a student can enroll in many courses and each course has many students.
a) Identify one candidate key for ENROLL.
b) Give two example tuples that violate your candidate key in (a) and briefly
state why they violate it.
Purchase answer to see full
attachment
