Programming Question

Create correct physical and logical entity relationship diagrams (ERD) through draw.io

1. (50 points)
A tutoring company wants to set up their database. They are trying to keep track of the
following: student ID, name, grade level, the subject they need tutoring in and their contact and
payment information. They also want to keep track of the tutors’ information such as their ID,
name, subject matter expertise and times available and rate. They will like to keep track of which
student is assigned to which tutor and their meeting schedule as well.
(5 points)*Brainstorm the above and list the ENTITIES the tutoring company will need to keep
track of
(5 points)*Brainstorm the above and list the ATTRIBUTES the tutoring company will need to
keep track of per Entity, explain any CONSTRAINTS there might be on the attributes, identify
PK and FK attributes.
(5 points)*Brainstorm the above and list what form of relationships each ENTITIES will have
with one another
(5 points)*Brainstorm the above and list the CARDINALITY between the ENTITIES
(30 points)*Finally, create the Logical (15 points) and Physical (15 points) ERD for this scenario
______________________________________________________________________________
__
2. (50 points)
A new veterinary clinic will like to set up their database. The clinic will like to keep record of
their customers such as: pet name, pet type, pet age, pet weight, owner name, owner address,
owner contact. Also the clinic will like to keep track of the veterinarian name, specialty and
schedule. They will like to keep track of the customer appointment date, what the appointment is
for, and how much it will cost.
(5 points)*Brainstorm the above and list the ENTITIES the clinic will need to keep track of
(5 points)*Brainstorm the above and list the ATTRIBUTES the clinic will need to keep track of
per Entity, explain any CONSTRAINTS there might be on the attributes, identify PK and FK
attributes.
(5 points)*Brainstorm the above and list what form of relationships each ENTITIES will have
with one another
(5 points)*Brainstorm the above and list the CARDINALITY between the ENTITIES
(30 points)*Finally, create the Logical (15 points) and Physical (15 points) ERD for this scenario
______________________________________________________________________________
3. (50 points)
A hair salon will like to set up their database. They will like to keep track of their customers (you
can decide on what information to keep track of for the customers). They will like to keep track
of their stylists (you can decide what information to keep track of for the stylists). They will like
to keep track of the schedule between the customers and the stylists. (Payment information is not
needed).
(5 points)*Brainstorm the above and list the ENTITIES the salon will need to keep track of
(5 points)*Brainstorm the above and list the ATTRIBUTES the salon will need to keep track of
per Entity, explain any CONSTRAINTS there might be on the attributes, identify PK and FK
attributes.
(5 points)*Brainstorm the above and list what form of relationships each ENTITIES will have
with one another
(5 points)*Brainstorm the above and list the CARDINALITY between the ENTITIES
(30 points)*Finally, create the Logical (15 points) and Physical (15 points) ERD for this scenario
Upon completion of this exam, please follow these steps:
1. Save your word doc to the desktop using the following naming convention:
“ITD256_Midterm_yourname
2. Click the “Choose File” link at the bottom of this exam page in Canvas
3. Choose your word doc from the desktop
4. Click Submit Quiz