Public diagrams of danielt

• Fitness_Club

  Ex-1

• Fungi_Airlines

  1-ERD Question - Fungi Airlines Fungi Airlines owns a fleet of planes, and airplane crews, pilots and flight attendants. Each pilot has a license to fly one (single) airplane model (e.g. B747). Each crew member is identified by an ID Number, last and first name, date of birth and gender. The company owns many airplanes from each model, each airplane has a unique number that corresponds with the number of seats on the plane, the airplane model and the manufacturing year. There may be two airplanes of the same type with different numbers of seats. The company also wants to keep details of airports around the world to which it flies. These details include the airport code, name, city and country in which the airport is located. In addition, the company would like to have information about the different terminals at each airport (for emergency cases). The terminal details include the terminal number (serial number) and the number of emergency exits. All outgoing regular flights have a unique flight number. The flight number is a permanent/fixed number for each regular flight and is always associated with the specific flight data. The flight data include the airport of origin, the destination airport, the day of week and the hour of departure. The flights can actually leave on different dates (but only at the scheduled day of the week), each flight on a different hour (or on time as scheduled) subject to the delay constrains at the airports. Each flight might have a different number of passengers, and various staff members. On each flight, the officers are a captain (CA), a first officer (FO), and a second officer (SO). The position of an officer can change on every flight. Each officer can serve either role. 1. Define the entities of the case study. 2. Define the cardinality of the entity connections. 3. Check whether there are any weak entities and enforce integrity. 4. Define the entity attributes. 5. Define the primary and the foreign keys of the entities.