Databases Question

User Generated

wnlfntuh

Computer Science

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:
3 Questions
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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-...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags