Question

database design class

for database and design class

discription for the first pic

discription

Using the descriptions in the ER diagram exercises you selected in the course content area, develop an ER diagram for your assigned exercise. The order of construction should be: Entities Identifiers Attributes (when listed in the exercise) Relationships Please use Crow's Foot Notation for your diagrams. Upon completion, post both the description of your exercise and an image of a completed ER diagram to share with the class. Using the descriptions in the ER diagram exercises you selected in the course content area, develop an ER diagram for your assigned exercise. The order of construction should be: Entities Identifiers Attributes (when listed in the exercise) Relationships Please use Crow's Foot Notation for your diagrams. Upon completion, post both the description of your exercise and an image of a completed ER diagram to share with the class. Exercise 3 FastFlight Airlines is a small air carrier operating in three north-eastern states. FastFlight is in the process of computerizing its passenger reservation system. The following data items have been identified: reservation code, flight number, flight date, origin, destination, departure time, arrival time, passenger name, seat number, reservation agent number and reservation agent name. For example, flight number 303, which is scheduled every Tuesday and Thursday, leaves Augusta, Maine, at 9:23am and arrives in Nashua, New Hampshire at 10:17am. You can assume that the Fast Freight reservation system will detect automatically whether empty seats are available. Draw the Entity Relationship Diagram for this system. Exercise 3 FastFlight Airlines is a small air carrier operating in three north-eastern states. FastFlight is in the process of computerizing its passenger reservation system. The following data items have been identified: reservation code, flight number, flight date, origin, destination, departure time, arrival time, passenger name, seat number, reservation agent number and reservation agent name. For example, flight number 303, which is scheduled every Tuesday and Thursday, leaves Augusta, Maine, at 9:23am and arrives in Nashua, New Hampshire at 10:17am. You can assume that the Fast Freight reservation system will detect automatically whether empty seats are available. Draw the Entity Relationship Diagram for this system.

Answer 1

Entities: Flight Details, Reservation, Agent details

Attributes: flightNumber,flightDate,Origin,destination,departureTime,arrivalTime,reservationCode,passengarName,seatNumber,reservationAgentNumber,reservationAgentName

Relationships: reserves ticket, sells ticket

Fligut Petails Higyhotnbunbee MigdtDede Reseovition HYOXevation Code Precengas Nene seat Nomber Piglct Nemuber resshrou Ageat Muber e2erNes Destination Deparcture Tue Aorval Thue selle tickot Azesst Details YeAorwatrou Agesit Nuubes TererNastouget Name Fligat Neam