Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please do the task a-e. Database requirements are included in the following request for quote: We ask for your offer for a rental car reservation

Please do the task a-e. image text in transcribed
image text in transcribed
image text in transcribed
Database requirements are included in the following request for quote: We ask for your offer for a rental car reservation system. Vara-auto Oy is a car rental company which offers reliable but affordable rental cars for consumers. We use Excel sheets shared in company OneDrive to keep track of rentals and invoicing as our current system. This has become increasingly difficult to manage now that we have expanded our operation to multiple cities in Finland. Sometimes we may overbook our fleet or not properly register all additional services. We need every rental and service to be clearly assigned to the right customer. We also need to make sure the customer gets their rental from the right city. We have locations in major Finnish cities including Helsinki, Turku, Tampere, Kuopio etc. We need a system in which our customers can perform following activities: browse the cars in the desired city and reserve the car they want if there is availability. Reservation requires personal information. There are additional services such as GPS navigator, child seat or tow hitch. Our cars have fixed daily rates and additional services have fixed one-time prices for the time of the rental. Our personnel need several functions. They check which cars are available, which clients have reserved or already rented: which car for what time. We write an invoice to the customer based on the booking made. The invoice must show the customer's information and a reservation number, time of booking, which car was included in the reservation, what additional services were included in the reservation and how much the car and additional services cost. We also need to track if the customer has paid their invoice and, if necessary, we can send the invoice again. Task: Create a relational database that stores customers, cars, car reservations and rentals, and additional services. Results to be generated: - ER model with MySQL WorkBench - A working database with tables in MariaDB or MySQL - Each table contains at least three rows of meaningful data - Invoice view (VIEW), which can be used to create an invoice for the customer Deliverable: Return the following items as one pdf file which contains the following items in this order clearly titled: a) A screenshot of the ER model Workbench (10p) b) SQL creation statement for the database (includes creation of the base, tables, views and any other objects) as text, not screenshot or photo. (5p) c) Data insertion queries provided in correct order as text, not screenshot or photo, at least three rows of meaningful data must be added to each table (5p) d) Invoice view creation statement as text, not screenshot or photo (5p) e) A search query as text, not screenshot or photo and its returned result as screenshot for the invoice view. The result must include the details of one customer's invoice as defined in customer requirements. (5p) Return the following items as one pdf file which contains the following items in this order clearly titled: a) A screenshot of the ER model Workbench (10p) b) SQL creation statement for the database (includes creation of the base, tables, views and any other objects) as text, not screenshot or photo. (5p) c) Data insertion queries provided in correct order as text, not sereenshot or photo, at least three rows of meaningful data must be added to each table (5p) d) Invoice view creation statement as text, not screenshot or photo ( 5p ) e) A search query as text, not screenshot or photo and its returned result as screenshot for the invoice view. The result must include the details of one customer's invoice as defined in customer requirements. (5p)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Oracle9i Database Administration

Authors: Sam R. Alapati

1st Edition

1590590228, 978-1590590225

Students also viewed these Databases questions

Question

What is systems integration?

Answered: 1 week ago