Programming Question

College of Computing and InformaticsAssignment 2
Deadline: Sunday 30/10/2022 @ 23:59
[Total Mark for this Assignment is 8]
Student Details:
Name:
CRN:
ID:
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):
Question One
4 Marks
Design an ER diagram for the following Dental Clinic database. Your diagram
should have all the needed details. You may make any reasonable assumptions
Create Entity-
but you have to state them clearly.
Relationship
model, Relational
The clinic has several dentists. Each dentist has a unique Number, name,
model, and write
nationality, multiple room-number, salary, birth-date and home-address (Box,
SQL queries.
City, Zip).
Each client (patient) has a unique Code, name, home-phone, work-phone,
Design a
address, and birth-date. Each client is assigned to one dentist. All future visits
database starting
will be to the same dentist. A client can be insured or self-paying. An insured
from the
client should have an insurance company-name, and company-Phone, while a
conceptual design
self-paying client must have a bank-name and a bank account.
to the
implementation of
database
Each visit of a client is described by a date, type, action, fee, and date-of-nextappointment.
schemas.
1. Design an Entity Relationship (ER) Model to represent the above
requirements. (2 Marks)
2. Convert the ER Diagram that presented in part-1 to Rational Schema. (2
Marks)
Question Two
Pg. 02
Learning
Outcome(s):
Question Two
Explain and distinct between disjoint and overlapping constraints. (0.5 Mark)
Illustrate your answer with suitable examples for each constraint.
Explain the
concepts and
architectures
involved in
database
development.
1 Mark
(0.5 Mark)
Question Three
Pg. 03
Learning
Outcome(s):
CLO3
Question Three
1.5 Mark
Define Cardinality Ratios for binary relationship? What are possible Cardinality
Ratios for Binary Relationship? Suppose in SEU, there are some departments
consist of many employees.
( 1 Mark)
What is the cardinality ratio for DEPARTMENT:EMPLOYEE?
(0.5 Marks)
Create EntityRelationship
model, Relational
model, and write
SQL queries.
Question Four
Pg. 04
Learning
Outcome(s):
Question Four
1.5 Marks
In SEU, identify Cardinality ratios between the following entities:
CLO3
Create EntityRelationship
model, Relational
model, and write
SQL queries.
Entity 1
Cardinality Ratio
Entity 2
CLASSROOM
STUDENT
INSTRUCTOR
ROOM
STUDENT
INSTRUCTOR
______________
______________
______________
______________
______________
______________
PODIUM
CLASS
TECHNICAL STAFF
BRANCH
TEACHER
DEAN