A hair salon will like to set up their database. They will like to keep track...

 

Transcribed Image Text:

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

Entities 1 Customers 2 Stylists 3 Appointments 4 Services Attributes For Customers Customer ID PK Fi... View the full answer