IT 403 SEU Database Schema for A Dental Clinic & Appointments Question


1 attachmentsSlide 1 of 1attachment_1attachment_1

Unformatted Attachment Preview

College of Computing and Informatics
Assignment 1
Deadline: Thursday 03/03/2022 @ 23:59
[Total Mark for this Assignment is 8]
Student Details:
Name: ###
ID: ###
CRN: ###

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
Explain database
systems, and
Question One
2 Marks
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
Primary keys.
Question Two
Pg. 02
Design a
database starting
from the
conceptual design
to the
implementation of
2 Marks
Question Two
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)
Question Three
Pg. 03
Explain database
systems, and
1 Mark
Question Three
Compare between the Two Tier Client-Server DBMS Architecture and Three
Tier Client-Server DBMS Architecture.
Question Four
Pg. 04
Create EntityRelationship
model, Relational
model, and write
SQL queries
3 Marks
Question Four
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,
Address, Salary)
Each Employee purchase PRODUCTS (ProductID, Product_Type)
Employee creates INVOICES( InvoiceID, Amount_Paid, Invoice_Date)

Purchase answer to see full


Database Schema

dental clinic

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Looking for this assignment?

do my essay homework

Reviews, comments, and love from our customers and community

Article Writing

Great service so far. Keep doing what you do, I am really impressed by the work done.



PowerPoint Presentation

I am speechless…WoW! Thank you so much! Definitely, the writer is talented person. She provided me with an essay a day early before the due date!

Stacy V.

Part-time student

Dissertation & Thesis

This was a very well-written paper. Great work fast. I was in pretty desperate need for help to finish this paper before the due date, which was in nine hours.

M.H.H. Tony


Annotated Bibliography

I love working with this company. You always go above and beyond and exceed my expectations every time. Kate did a WONDERFUL job. I would highly recommend her.

Francisca N.


Book Report / Review

I received my order wayyyyyyy sooner than I expected. Couldn’t ask for more. Very good at communicating & fast at replying. And change & corrections she put in the effort to go back and change it!

Mary J.


Essay (Any Type)

On time, perfect paper. All concerns & matters I had Tom was able to answer them! I will definitely provide him with more orders!

Prof. Kate (Ph.D)


Case Study

Awesome! Great papers, and early! Thank you so much once again! Definitely recommend to trust James with your assignments! He won’t disappoint!

Kaylin Green


Proofreading & Editing

Thank you Dr. Rebecca for editing my essays! She completed my task literally in 3 hours. For sure will work with her again, she is great and follows all instructions

Rebecca L.


Critical Thinking / Review

Extremely thorough summary, understanding and examples found for social science readings, with edits made as needed and on time. It’s like having a tutoring service available (:

Arnold W.



Perfect!I only paid about $80, which i think was a good price considering what my paper entailed. My paper was done early and it was well written!

Joshua W.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>