Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strengthening The Rule Of Law In Europe From A Common Concept To Mechanisms Of Implementation

Authors: Werner Schroeder

1st Edition

1509928871, 978-1509928873

More Books

Students also viewed these Law questions