Use ER Assistant or MS Visio to solve problem 25 from Chapter 3 (page 111)...
70.2K
Verified Solution
Link Copied!
Question
Accounting
Use ER Assistant or MS Visio to solve problem 25 from Chapter 3 (page 111) using Crows Foot notation. The six tables for this problem are on pages 109-110. Although the problem assigned (3-25) is in Chapter 3, the expectation is that you will apply the material learned in Chapter 4 in your ERD. This means that the six entity boxes in your ERD must contain a complete list of attributes, designated PK and FKs, designated required vs. optional attributes, and an indication of the strength of each relationship (weak vs. strong).
Problem 25: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many CHARTER trips but that each CHARTER trip is flown by one AIRCRAFT, that a MODEL references many AIRCRAFT but that each AIRCRAFT references a single MODEL, and so on.)
Entities and Attributes (keys and non-keys): CUSTOMER, CHARTER, AIRCRAFT, MODEL, PILOT, & EMPLOYEE
Relationships: CUSTOMER (1--- requests--- M) CHARTER, CHARTER (M --- flies --- 1) AIRCRAFT, AIRCRAFT (M --- references --- 1) MODEL, EMPLOYEE (1 --- is a --- 1) PILOT, PILOT (1 --- copilots --- M) CHARTER, PILOT (1 --- pilots --- M) CHARTER,
Copy the diagram and paste it into a Microsoft Word document that includes your name as a header.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
