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.