Using information from the Case Study in question one (1) above, complete the partial E-R diagram below by inserting the maximum and minimum cardinalities for the two relationships given. State all assumptions made. For each entity in the E-R diagram, provide four (4) attributes, one of which must be clearly marked as the primary key attribute. (4 marks) For the relationships in the E-R Diagram, show the database tables for the relational database design. (4 marks) State the rule for transforming a M:N relationship in an E-R diagram into a relational database design. (3 marks) CaribAir is an airline carrier providing passenger travel and cargo delivery to the USA. A shipping agent is expected to call and make a reservation with CaribAir providing information on cargo, namely, the destination, description, weight and contact information. A reservation is made for one or more items of cargo. A record is created in the reservation database and the shipping agent is informed of the reservation number generated and possible flight information. The shipping agent must then deliver the cargo to the Cargo Section at least one day before the departure of the flight stating the reservation number previously given. The reservation number is used to confirm the reservation. An agent at the Cargo Section, upon confirming the reservation will check the Airline Flight Information System to find an aircraft with ample space to take the cargo and to confirm the flight and departure time. The shipping agent will be informed of the departure time of the confirmed flight. A machine-readable barcode, with all the cargo details and the flight information, is printed and attached to each item of cargo. A record is created for each printed barcode and stored in a barcode database. All items of cargo are placed on the conveyor belt and taken to a holding area near the Ramp Section. The barcode records of each items of cargo accepted for air freight is sent electronically from the Cargo Section to the Federal Aviation Authority at least 60 minutes prior to departure of all flights. Clearance notification from the FAA comes directly to the Cargo Section. If the FAA objects to any item of cargo to be shipped, an objection notification is sent to the Cargo Section. The supervisor of the Cargo Section will remove the particular item of cargo, notify the shipping agent of the objection and update the barcode database to reflect the removal. Before any item of cargo is loaded onto the aircraft, the supervisor of the Ramp Section, using a bar code reader, will read the barcode on the item. The barcode will be verified against the barcode database for FAA approval. The supervisor will then provide additional freight information and a freight record for each item of cargo loaded is created in the freight database