Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
I need you solve this question (Based on the Un-Normalized database table below, create a data model for a Rental Car

I need you solve this question (Based on the Un-Normalized database table below, create a data model for a Rental Car

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 97C: The following tables provide a very small portion of the data that will be kept in the database....
See similar textbooks
icon
Related questions
Question

I need you solve this question (Based on the Un-Normalized database table below, create a data model for a Rental Car
agency by normalizing them with 2nd and 3rd normal forms.) i need you to complete just like the second image in hand written

2. Based on the Un-Normalized database table below, create a data model for a Rental Car agency by normalizing them with 2nd and 3rd normal forms. Car Car Base Cust ID Type Rent ID 501 Sedan $40 10001 John 501 Sedan 501 Sedan 502 SUV 502 SUV 501 Sedan $40 Name $40 10001 John 10001 John $60 10001 John $60 10001 John $40 10002 Jill 501 Sedan $40 10002 Jill Cust DOB Age Address 300 Main 1/8/80 34 St 1/8/80 1/8/80 300 Main 1/8/80 34 St 4/15/74 34 St 4/15/74 300 Main 1/8/80 34 St 300 Main 300 Main 34 St 123 Wall 40 St 123 Wall 40 st Date of Service Service Booking Name Charge 4/22/14 GPS 4/22/14 EzPass 4/22/14 Full tank 3/15/13 GPS 3/15/13 Bluetooth Moon 4/20/14 Roof Leather 4/20/14 Seats $15.00 $10.00 $40.00 $15.00 $30.00 $15.00 $20.00
Transcribed Image Text:2. Based on the Un-Normalized database table below, create a data model for a Rental Car agency by normalizing them with 2nd and 3rd normal forms. Car Car Base Cust ID Type Rent ID 501 Sedan $40 10001 John 501 Sedan 501 Sedan 502 SUV 502 SUV 501 Sedan $40 Name $40 10001 John 10001 John $60 10001 John $60 10001 John $40 10002 Jill 501 Sedan $40 10002 Jill Cust DOB Age Address 300 Main 1/8/80 34 St 1/8/80 1/8/80 300 Main 1/8/80 34 St 4/15/74 34 St 4/15/74 300 Main 1/8/80 34 St 300 Main 300 Main 34 St 123 Wall 40 St 123 Wall 40 st Date of Service Service Booking Name Charge 4/22/14 GPS 4/22/14 EzPass 4/22/14 Full tank 3/15/13 GPS 3/15/13 Bluetooth Moon 4/20/14 Roof Leather 4/20/14 Seats $15.00 $10.00 $40.00 $15.00 $30.00 $15.00 $20.00
2. 1. PK: Projcode + Emp No 2. Project (projcode (PK), Project Name, Project Mgr. Project Bulger) ее Employee (EMPNO(PIC), Employer Name, Dept No. Doptware, Hourly Rate) & Emp Project (Projcode (FK), EMAND (FK)) 3. Dept (Dept No (PE) Dept Name) Employee ( EmpNa (PK) , Employee Name, Dept No, Hourlyhale) PM (PMID (PK), PMName) Prijest (Day code (PK), Raj Name, PMID, Arjedt Budget) Empproject (Proj code (FK), EmpNo (FK))
Transcribed Image Text:2. 1. PK: Projcode + Emp No 2. Project (projcode (PK), Project Name, Project Mgr. Project Bulger) ее Employee (EMPNO(PIC), Employer Name, Dept No. Doptware, Hourly Rate) & Emp Project (Projcode (FK), EMAND (FK)) 3. Dept (Dept No (PE) Dept Name) Employee ( EmpNa (PK) , Employee Name, Dept No, Hourlyhale) PM (PMID (PK), PMName) Prijest (Day code (PK), Raj Name, PMID, Arjedt Budget) Empproject (Proj code (FK), EmpNo (FK))
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Concurrency control
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 Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
SEE MORE TEXTBOOKS