A tutoring company wants to set up their database. They are trying to keep track of...

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

Certainly Lets break down the requirements and create an EntityRelationship Diagram ERD for the tuto... View the full answer