1 attachmentsSlide 1 of 1attachment_1attachment_1
Unformatted Attachment Preview
College of Computing and Informatics
Deadline: Thursday 03/03/2022 @ 23:59
[Total Mark for this Assignment is 8]
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
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
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.
Create a database schema for a dental clinic. The dental clinic has five
relations, Patients, Doctors, staff, Appointments, Payments. You are free to
choose the attributes for each relation, and you are required to show the
Giving the following schema for a supermarket database, specify the domain
constrains for each attribute.
CUSTOMERS (CustomerID , First_Name, Last_Name)
EMPLOYEES (EmployeeID, Name, Email, PhoneNo)
INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
Compare between the Two Tier Client-Server DBMS Architecture and Three
Tier Client-Server DBMS Architecture.
model, and write
Giving the following schema create an ER diagram for this Supermarket
database, and show the primary keys, multivalued attributes, composite
attributes, and relationship types.
Supermarket has CUSTOMERS (CustomerID , First_Name, Last_Name)
Supermarket has EMPLOYEES (EmployeeID, Name, Email, PhoneNo,
Each Employee purchase PRODUCTS (ProductID, Product_Type)
Employee creates INVOICES( InvoiceID, Amount_Paid, Invoice_Date)
Purchase answer to see full
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.