such as: customer ID first name last name telephone number credit card data The third table should contain the bookings data, such as: booking ID car ID customer ID pick-up date drop-off date total cost Please note that you can create more tables as well as add more data fields, if necessary. Your program should contain multiple Windows forms as follows: The first form will enable the user to search for a car rental. If a car rental is selected, the second form may provide more into about the car that has been selected, including the car description and pi

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
Question

Design a "Car Rental" Visual C# application, which allows the user to search for and book a car rental. It is required to create a database file that contains at least three related tables, the first of which contains the cars data with the data fields, such as: car ID car type car model quantity on stock cost per day Make up at least five records in the first table and save your database file in the default folder of your project. The second table should contain the customer information, such as: customer ID first name last name telephone number credit card data The third table should contain the bookings data, such as: booking ID car ID customer ID pick-up date drop-off date total cost Please note that you can create more tables as well as add more data fields, if necessary. Your program should contain multiple Windows forms as follows: The first form will enable the user to search for a car rental. If a car rental is selected, the second form may provide more into about the car that has been selected, including the car description and picture(s). This form will also enable the user to book the selected car or return to the previous form and search for another car. If the user confirms the booking, the third form will be shown to get the customer data and process the customer's order. This form or another form will also display a receipt, which contains the customer info and car/booking info, as well as the total cost including all taxes. Please note that when a customer's booking is processed the database file has to be updated, i.e., new records

Please give codes for the forms and how to set up the connections. 

Expert Solution
steps

Step by step

Solved in 6 steps

Blurred answer
Knowledge Booster
Data Binding
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
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