Additional Notes: USING C# You cannot add two flights with the same flight number When you select “View Flights”, a list containing the Flight number, origin and destination for each flight must be shown. When you select “View a particular flight”, a list of all flights should be displayed and the user must be allowed to enter a particular flight number. All the information on that selected flight must be displayed. All the customers who are booked on that flight must SPECIAL NOTE: A customer can only be deleted if there are no bookings for that customer. A flight can only be deleted if there are no customers booked on the flight.   You must extend the core design and add the functionality to add customers and booking features to the system. The information that must be recorded on a customer is as follows: A customer ID must be assigned to each customer by the system. (NOT entered by the user) The customer’s first name The customer’s last name. The customer’s phone (a string type is fine for this) The number of bookings the customer has made Your main menu should have the new options: Make booking View bookings   ADD CUSTOMER When the “Add Customer” option is selected, all information necessary to make the customer object must be asked for. A customer can only be added if there is no other customer with the same first name, last name and phone number (all three cannot be the same). An appropriate message as to whether the customer addition was successful or not should be displayed. VIEW CUSTOMERS When “View Customers” is selected, the first name, last name and phone number must be displayed for each customer.     The information that must be recorded on a booking is as follows: The date of the booking ( a string) A booking number must be assigned by the system. (NOT entered by the user) The flight object the booking is being made for. The customer object the booking is being made for Note : you can use the following code to get the date and time from your system as a string… string date = DateTime.Now.ToString(@"MM\/dd\/yyyy h\:mm tt"); Your main menu should have the new options: Make booking View bookings   MAKE BOOKINGS When the “Add booking” option is selected, a list of all customers and all flights should be displayed first. The user must then be asked for the Customer id and flight id to make the booking for. A booking can only be made if there is free space on the plane, the customer id exists and the flight id exists. All associated objects should be updated. An appropriate message as to whether the booking was successful or not should be displayed. VIEW BOOKINGS When “View bookings” is selected, the date, booking number, customer name and flight number must be displayed for each booking.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question
100%

Additional Notes:

USING C#

  • You cannot add two flights with the same flight number
  • When you select “View Flights”, a list containing the Flight number, origin and destination for each flight must be shown.
  • When you select “View a particular flight”, a list of all flights should be displayed and the user must be allowed to enter a particular flight number. All the information on that selected flight must be displayed. All the customers who are booked on that flight must

SPECIAL NOTE:

A customer can only be deleted if there are no bookings for that customer.

A flight can only be deleted if there are no customers booked on the flight.

 

You must extend the core design and add the functionality to add customers and booking features to the system.

The information that must be recorded on a customer is as follows:

  • A customer ID must be assigned to each customer by the system. (NOT entered by the user)
  • The customer’s first name
  • The customer’s last name.
  • The customer’s phone (a string type is fine for this)
  • The number of bookings the customer has made

Your main menu should have the new options:

  • Make booking
  • View bookings

 

ADD CUSTOMER

When the “Add Customer” option is selected, all information necessary to make the customer object must be asked for.

A customer can only be added if there is no other customer with the same first name, last name and phone number (all three cannot be the same). An appropriate message as to whether the customer addition was successful or not should be displayed.

VIEW CUSTOMERS

When “View Customers” is selected, the first name, last name and phone number must be displayed for each customer.

 

 

The information that must be recorded on a booking is as follows:

  • The date of the booking ( a string)
  • A booking number must be assigned by the system. (NOT entered by the user)
  • The flight object the booking is being made for.
  • The customer object the booking is being made for

Note : you can use the following code to get the date and time from your system as a string…

string date = DateTime.Now.ToString(@"MM\/dd\/yyyy h\:mm tt");

Your main menu should have the new options:

  • Make booking
  • View bookings

 

MAKE BOOKINGS

When the “Add booking” option is selected, a list of all customers and all flights should be displayed first. The user must then be asked for the Customer id and flight id to make the booking for.

A booking can only be made if there is free space on the plane, the customer id exists and the flight id exists. All associated objects should be updated. An appropriate message as to whether the booking was successful or not should be displayed.

VIEW BOOKINGS

When “View bookings” is selected, the date, booking number, customer name and flight number must be displayed for each booking.

1: Add Flight
2: View Flights
XYZ AirLines Limited.
Customer Menu
Please select a choice from the menu below:
XYZ AirLines Limited.
Flight Menu
Please select a choice from the menu below:
3: View a particular Flight
4: Delete Flight
5: Back to main menu
1: Add Customer
2: View Customers
3: Delete Customer
4 Back to main menu
XYZ AirLines Limited.
Booking Menu
Please select a choice from the menu below:
1: Make Booking
2: View Bookings
3: Back to main menu
XYZ AirLines Limited.
Please select a choice from the menu below:
1: Customers
2: Flights
3: Bookings
4:Exit
Transcribed Image Text:1: Add Flight 2: View Flights XYZ AirLines Limited. Customer Menu Please select a choice from the menu below: XYZ AirLines Limited. Flight Menu Please select a choice from the menu below: 3: View a particular Flight 4: Delete Flight 5: Back to main menu 1: Add Customer 2: View Customers 3: Delete Customer 4 Back to main menu XYZ AirLines Limited. Booking Menu Please select a choice from the menu below: 1: Make Booking 2: View Bookings 3: Back to main menu XYZ AirLines Limited. Please select a choice from the menu below: 1: Customers 2: Flights 3: Bookings 4:Exit
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Control Structure
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education