/ER diagram not handwritten please.Use any tool and send the image //Also can the question be answered in subparts according to the question numbers please //Need two parts of the question answered please Terrific Airlines is a newly formed airline aimed at the burgeoning market of clandestine travellers (fugitives, spies, confidence tricksters, scoundrels, deadbeats, cheating spouses, politicians, etc.). Terrific Airlines needs a database to track flights, customers, fares, airplane performance, and personnel assignment. Since Terrific Airlines is promoted as a “…fast way out of town,” individual seats are not assigned, and flights of other carriers are not tracked. More specific notes about Terrific Airlines are listed below: Information about a route includes its unique number, its origin, its destination, and estimated departure and arrival times. To reduce costs, Terrific Airlines only has non-stop flights with a single origin and destination. Flights are scheduled for a route on one or more dates with an airplane and a crew assigned to each flight, and the remaining capacity (seats not taken) noted. In a crew assignment, the employee number and the role are noted. It is a government requirement that the number of hours that flight crew (i.e., pilots, co-pilots, engineers) are in flight must be recorded. There is no such requirement for Non-flight crew (e.g., attendants). Airplanes have a unique serial number, a model, a capacity, and a next-scheduled-maintenance date. The maintenance record of an airplane includes a unique maintenance number, a date, a description, the serial number of the plane, and the employee responsible for the repairs. Employees have a unique employee number, a name, a phone, and a job title. Customers have a unique customer number, a phone number, and a name (it may or may not be their own). A record is maintained of flight reservations including a unique reservation number, a flight number, a customer number, a date, a fare, and the payment method (usually cash but occasionally some else’s cheque or credit card). If the payment is by credit card, a credit card number and an expiration date are part of the reservation record. Create an entity-relationship diagram showing the data requirements of the system. ERD should be able to be implemented in a relational DBMS. Use the ERD notation and should include a legend to explain the notation.Include attributes in the ERD. The use of a drawing tool such as Visio will make this task easier.Copy and paste the ERD into a word-processed document. //not the handwritten ones please List and explain any assumptions made in creating the data model.

/ER diagram not handwritten please.Use any tool and send the image //Also can the question be answered in subparts according to the question numbers please //Need two parts of the question answered please Terrific Airlines is a newly formed airline aimed at the burgeoning market of clandestine travellers (fugitives, spies, confidence tricksters, scoundrels, deadbeats, cheating spouses, politicians, etc.). Terrific Airlines needs a database to track flights, customers, fares, airplane performance, and personnel assignment. Since Terrific Airlines is promoted as a “…fast way out of town,” individual seats are not assigned, and flights of other carriers are not tracked. More specific notes about Terrific Airlines are listed below: Information about a route includes its unique number, its origin, its destination, and estimated departure and arrival times. To reduce costs, Terrific Airlines only has non-stop flights with a single origin and destination. Flights are scheduled for a route on one or more dates with an airplane and a crew assigned to each flight, and the remaining capacity (seats not taken) noted. In a crew assignment, the employee number and the role are noted. It is a government requirement that the number of hours that flight crew (i.e., pilots, co-pilots, engineers) are in flight must be recorded. There is no such requirement for Non-flight crew (e.g., attendants). Airplanes have a unique serial number, a model, a capacity, and a next-scheduled-maintenance date. The maintenance record of an airplane includes a unique maintenance number, a date, a description, the serial number of the plane, and the employee responsible for the repairs. Employees have a unique employee number, a name, a phone, and a job title. Customers have a unique customer number, a phone number, and a name (it may or may not be their own). A record is maintained of flight reservations including a unique reservation number, a flight number, a customer number, a date, a fare, and the payment method (usually cash but occasionally some else’s cheque or credit card). If the payment is by credit card, a credit card number and an expiration date are part of the reservation record. Create an entity-relationship diagram showing the data requirements of the system. ERD should be able to be implemented in a relational DBMS. Use the ERD notation and should include a legend to explain the notation.Include attributes in the ERD. The use of a drawing tool such as Visio will make this task easier.Copy and paste the ERD into a word-processed document. //not the handwritten ones please List and explain any assumptions made in creating the data model.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

//ER diagram not handwritten please.Use any tool and send the image

//Also can the question be answered in subparts according to the question numbers please

//Need two parts of the question answered please

Terrific Airlines is a newly formed airline aimed at the burgeoning market of clandestine travellers (fugitives, spies, confidence tricksters, scoundrels, deadbeats, cheating spouses, politicians, etc.). Terrific Airlines needs a database to track flights, customers, fares, airplane performance, and personnel assignment. Since Terrific Airlines is promoted as a “…fast way out of town,” individual seats are not assigned, and flights of other carriers are not tracked. More specific notes about Terrific Airlines are listed below:

Information about a route includes its unique number, its origin, its destination, and estimated departure and arrival times. To reduce costs, Terrific Airlines only has non-stop flights with a single origin and destination.
Flights are scheduled for a route on one or more dates with an airplane and a crew assigned to each flight, and the remaining capacity (seats not taken) noted. In a crew assignment, the employee number and the role are noted. It is a government requirement that the number of hours that flight crew (i.e., pilots, co-pilots, engineers) are in flight must be recorded. There is no such requirement for Non-flight crew (e.g., attendants).
Airplanes have a unique serial number, a model, a capacity, and a next-scheduled-maintenance date.
The maintenance record of an airplane includes a unique maintenance number, a date, a description, the serial number of the plane, and the employee responsible for the repairs.
Employees have a unique employee number, a name, a phone, and a job title.
Customers have a unique customer number, a phone number, and a name (it may or may not be their own).
A record is maintained of flight reservations including a unique reservation number, a flight number, a customer number, a date, a fare, and the payment method (usually cash but occasionally some else’s cheque or credit card). If the payment is by credit card, a credit card number and an expiration date are part of the reservation record.

Create an entity-relationship diagram showing the data requirements of the system. ERD should be able to be implemented in a relational DBMS. Use the ERD notation and should include a legend to explain the notation.Include attributes in the ERD. The use of a drawing tool such as Visio will make this task easier.Copy and paste the ERD into a word-processed document. //not the handwritten ones please
List and explain any assumptions made in creating the data model.

Expert Solution