Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. use er assistant or ms visio to solve problem 25 f

Use ER Assistant or MS Visio to solve problem 25 from Chapter 3 (page 111)...

70.2K

Verified Solution

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!
Become a Member

Other questions asked by students