Question: Looking to draw a simplified logical ER diagram and relation schema ( with attributes, PKs and FKs ) in chen format based a few attributes
Looking to draw a simplified logical ER diagram and relation schema with attributes, PKs and FKs in chen format based a few attributes provided and include appropriate ones need to be included in relation schema. Any complex relationships shall be converted into composite entities. Also, include cardinalities.
Case: Data will be collected for a cooking meet up that has multiple cook shows grouped into different tracks for the participants. Each type of cuisine has its own track with title and a description with each track having a minimum of and maximum of meetings.
SHow Spectators can register for unlimited individual shows under different tracks. Each sign up will need details like ID meeting number code, possible discounts. Each participant details are stored in the datasheet even before registration has started.
Any track will be run by atleast one masterchef upto per track. Masterchefs can choose the shows and participating chefs in their track. Each masterchefs details are assigned to the track including their resume and they are eligible to be a participant of any meeting. All the participants details including name and email are taken optionally besides the employment company details. The meet up organizer would like to capture the employer details from participants.
Each show should have atleast one dish cooked by only one chef and the dish details such as name, cooking time, etc. are noted in the datasheet. Any chef can cook in multiple meetings based on their choice. Any demsonstrating chef of the meeting can also be a spectator of othe show without paying registration fee. Any other information of the participating chefs is collected under 'extras'.
The studio where the meet up is happening has mutliple kitchens with tags describing the name, kitchen ID and more details that can hold only one show in one kitchen at a time. Studio charges only for those rooms that are operated during the meet up
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
