Description
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
(S) jaysaghu:
Include
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
(S) jaysaghu:
Include
3. 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
Explanation & Answer
Attached.
1. Question one
Entities:
•
Student
•
Tutor
Attributes: Student:
•
PK: student ID
•
Name
•
Grade level
•
Subject needed
•
Contact information
•
Payment information
Tutor:
•
PK: tutor ID
•
Name
•
Subject matter expertise
•
Availability
•
Rate
Constraints:
•
A student can have only one tutor at a time
•
A tutor can have multiple students
•
A subject can have multiple tutors
•
A meeting can only have one student and one tutor
•
A student can have multiple meetings, but each meeting must have a different tutor
•
A payment is associated with a single meeting
Relationships:
•
Student and Tutor have a many-to-many relationship
•
Subject and Tutor have a many-to-many relationship
•
Meeting is a junction table between Student and Tutor, with a many-to-many relationship
•
Payment is a dependent entity of Meeting
Cardinality:
•
Student to Meeting: one-to-many
•
Tutor to Meeting: one-...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Arizona State University Delta State University colorado technical university online colorado technical university online colorado technical university online University of Maryland - University College Northern Virginia Community College Saudi electronic university ashford university ashford university The University of Texas at Arlington The University of Texas at Arlington