Question: CREATE CAR RENTAL DATABASE Fill in missing data, create tables in third-normal form.There might even be some errors on the existing data. Your data structure

CREATE CAR RENTAL DATABASE

Fill in missing data, create tables in third-normal form.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. Create Relationships ensure to label "one to many", do not use "many to many" after tables are in third normal form.

DATA

Customers
1003 John Smith 1324 Main Street Lisle IL 60345 (834)234-3456
1004 Mary Brown 324 5th Ave Mokena IL 60448 (824)254-2312
1005 Louise Stevens 8364 34 st Frankfort IL 60449 (824)254-9374
1006 Sam Silver 8235 Second Ave Eastmond IL 60456 (824)834-9485
1007 Robert Diamond 935 Clinton Ave Boston MA 10500 (215)235-4556
1008 Dalila Newman 2934 E Sanford St Philadelphia PA 16530 (610)456-1243
1009 Christian Forbes 3904 36 st Frankfort IL 60449 (824)254-8834
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
Reservations
1450031 1001 1N2M34K5 10/10/2017 10/14/2017
1450032 1005 2K3J49SD 10/11/2017 10/14/2017
1450033 1002 3K45NS8 10/12/2017 10/14/2017
1450034 1004 PP122O22 10/12/2017 10/15/2017
1450035 1006 MZ0QP23K 10/12/2017 10/16/2017
1450036 1008 Y7U8Y8I9 10/12/2017 10/15/2017
1450037 1009 J1K2J3HH 10/13/2017 10/18/2017
Rentals
2160011 1001 J1K2J3HH 10/10/2017 10/13/2017 $ 135.00
2160012 1450034 1004 PP122O22 10/12/2017 10/15/2017 $ 105.00
2160013 1450035 1006 MZ0QP23K 10/12/2017 10/16/2017 $ 150.00
2160014 1005 JDKF9345 10/12/2017 10/17/2017 $ 185.00
2160015 1450036 1008 Y7U8Y8I9 10/12/2017 10/17/2017 $ 170.00
2160016 1450037 1009 J1K2J3HH 10/13/2017 10/18/2017 $ 175.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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...

Q:

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Q:

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Q:

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Q:

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Q:

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Q:

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Q:

What are the methodology and findings of used in this article? 1204 Y. JIA, L. VAN LENT, AND Y. ZENG within a sample of men." Pound, Penton-Voak, and Surridge [2009] also report that circulating...

Q:

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

Q:

I have provided all of the information that was given to me. there is no excel sheet provided, as the question requires me to create an excel model. please help me and let me know where I can help or...

Q:

Smallville Bus System provides public transportation to the residents of Smallville. The maintenance department manages 1,000 buses and faces annual demand for 2,166 tires. The order cost is $50 per...

Q:

Determine the time constant for each of the circuits in Fig. 7.96. (a) (b) Rz R3 L. Ly L2

Q:

Hector Rodriguez is buying a home with a $ 1 6 0 , 0 0 0 mortgage using a 6 . 5 percent, 1 5 - year loan. If the payment per $ 1 , 0 0 0 debt under these terms is $ 8 . 7 1 1 1 , how much is the...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

If the tax rate is 40 percent, compute the beforetax real interest rate and the after-tax real interest rate in each of the following cases. a. The nominal interest rate is 10 percent and the...

Q:

Assume that the reserve requirement is 20%. Also assume that banks do not hold excess reserves and there is no cash held by the public. The Federal Reserve decides that it wants to expand the money...

Q:

It is often suggested that the Federal Reserve try to achieve zero inflation. If we assume that velocity is constant, does this zero-inflation goal require that the rate of money growth equal zero?...