Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Once you have all your first guesses recorded, move on to the Entities and Relationships worksheet. The entity relationship diagram (ERD) depicted on this worksheet
Once you have all your first guesses recorded, move on to the \"Entities and Relationships\" worksheet. The entity relationship diagram (ERD) depicted on this worksheet contains 7 entities. Two entities (THEATER 8: TRANSACTION) are fully complete. The other entities are missing critic: information. You must complete the ERD by: a. b. c. Provide the name of each entity if not currently indicated (top blue cell of each block) Create the primary key (PK) for each entity (e.g. TheaterKey) Insert at least two attributes into each entity. This must include attributes shown on the receipt (e.g. Theater Name), but can aiso include other attributes not necessariiy shown (e.g. Theater Address) i. DO write down the generic entity or attribute ii. Do NOT write down the example data shown on the receipt iii. Example: DO list \"TheaterName" as an attribute of the "Theater" entity. Do NOT write down \"Village Cinemas\" as part of your answer on the 3rd worksheet. Identify the foreign key(s) (FK) for each entity (some entities will not include an FK) Finally, in each green box, provide the appropriate cardinality for each relationship. Inse \"1\" to signify the one side of the relationship or "M" to signify the many side of the relationship
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started