Instructions:

Use ER Assistant or MS Visio$$to solve problem $25$ from Chapter $3($page $111)$ using Crow$$s 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$.)$

$$

Copy the diagram and paste it into a Microsoft Word document that includes your name as a header.