Question: 02. Database modelling (5 marks) In this part, you are asked to design a database to support a Beauty Salon Booking System. The major business

02. Database modelling (5 marks) In this part, you are asked to design a database to support a Beauty Salon Booking System. The major business requirements are summarised below in the Mini Case: ABeauty Salon Booking System You are asked to develop a detailed Entity-Relationship model for this mini case. Your ER model should consist of a detailed ER diagram integrated with itemised discussions on the features of the entities and relationships and all the assumptions you made where applicable. The ER diagram and the accompanying document should identify keys, constraints, entity types, relationship types, specialisationfgeneralisation if any, etc. You must use the same notation scheme for the ER diagram as the textbook (use UNIL notations as shown in the last page of the textbook, and don't use Crew Foot notations), and the ER diagram should be strictly in the way the textbook uses for. We note that our past experiences show drawing an ER diagram on Mcrosott
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
