Question
CREATE CAR RENTAL DATABASE You will need to add additional data since the sample is a partial snapshot of the total dataset but DO NOT
CREATE CAR RENTAL DATABASE
You will need to add additional data since the sample is a partial snapshot of the total dataset but DO NOT CHANGE any of the sample data (unless you find that there was an error). Again, the sample data is probably not normalized and the table names are generic. There might even be some errors on the existing data. Your data structure must be in third normal form and the table and attribute names must clear in respect to their meaning. I suggest you import and massage the data instead of retyping it. Using a combination of cut&paste, Excel, and Access will help in the task of importing the data. Car Rental Company System Your system should handle reservations and rentals at a car rental company. You need to have forms that allow you to enter, edit, and eliminate customers, vehicles, reservations, rentals, and types of vehicles. You should also have a way to list all vehicles of a given type available for a given range of dates. You should have a reservation certificate as well as a rental certificate and a final invoice. You should have a list of all rental reservations for a given day and (a separate one) of all rentals done in a given day.
| Vehicles | |||
| Ford | Taurus | 1M2N3J4 | Compact |
| Dodge | Caravan | 1N2M34K5 | Minivan |
| Toyota | Sienna | 2K3J49SD | Minivan |
| Toyota | Sienna | 3K45NS8 | Minivan |
| Nissan | Altima | 7G8FD9S0 | Economy |
| Ford | Taurus | 94J2L4N5 | Compact |
| Nissan | Altima | 9A8S7D6F | Economy |
| Toyota | Sienna | 9F8E45D | Minivan |
| Honda | Oddisey | AL29SK38 | Minivan |
| Ford | Taurus | AQS22334 | Compact |
| Honda | Oddisey | B5B5B6B | Minivan |
| Honda | Oddisey | B7B8B9B7 | Minivan |
| Nissan | Altima | D2D2345 | Economy |
| Toyota | Sienna | DHF839DJ | Minivan |
| Ford | Edge | G6F5D4S3 | Economy |
| Ford | Taurus | H23H45F | Compact |
| Toyota | Sienna | H3G4G45 | Minivan |
| Honda | Oddisey | H3J3K3L3 | Minivan |
| Ford | Edge | H7H8J8H9 | Economy |
| Ford | Edge | HERV232 | Economy |
| Ford | Taurus | HH44YY55 | Compact |
| Ford | Taurus | I1I1I2I2 | Compact |
| Ford | Taurus | II2233JJUU | Compact |
| Ford | Taurus | J1K2J3HH | Compact |
| Toyota | Sienna | J1U2J1U2 | Minivan |
| Toyota | Sienna | J2JK45L6 | Minivan |
| Ford | Edge | J3K4L53J | Economy |
| Ford | Taurus | JD48F94 | Compact |
| Honda | Oddisey | JDKF9345 | Minivan |
| Honda | Oddisey | JJEER445 | Minivan |
| Ford | Taurus | JK34DJ34 | Compact |
| Dodge | Caravan | JS2K3N44 | Minivan |
| Toyota | Sienna | K2K3K4K5 | Minivan |
| Ford | Taurus | KK1L2K23 | Compact |
| Ford | Taurus | KOP2345 | Compact |
| Nissan | Altima | L2K3J4H5 | Economy |
| Dodge | Caravan | L4P4J4K4 | Minivan |
| Ford | Taurus | LP34523 | Compact |
| Dodge | Caravan | MZ0QP23K | Minivan |
| Ford | Edge | N2N3990 | Economy |
| Dodge | Caravan | N4M5N6 | Minivan |
| Honda | Oddisey | NDJF2034 | Minivan |
| Nissan | Altima | NN2233M | Economy |
| Nissan | Altima | O1I2U34Y5 | Economy |
| Toyota | Sienna | O2O3O4 | Minivan |
| Dodge | Caravan | O3P3I3K3 | Minivan |
| Ford | Taurus | PP122O22 | Compact |
| Ford | Edge | Q9WU345 | Economy |
| Nissan | Altima | S8S9F4F3 | Economy |
| Ford | Edge | T5R543EW | Economy |
| Honda | Oddisey | U3I3T3R3 | Minivan |
| Dodge | Caravan | U4UU449 | Minivan |
| Toyota | Sienna | V7V8V9 | Minivan |
| Ford | Edge | W3W4E5 | Economy |
| Ford | Edge | W9IOUP | Economy |
| Nissan | Altima | Y65U4I3O | Economy |
| Ford | Edge | Y7U8Y8I9 | Economy |
| Dodge | Caravan | ZMD293JD4 | Minivan |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
SQL Server Query Performance Tuning
Authors: Sajal Dam, Grant Fritchey
4th Edition
1430267429, 9781430267423
