tables in in third normal form In the Lab BN ed in modify, and/or use a database

Question

tables in in third normal form In the Lab BN ed in modify, and/or use a database following the guidelines, concepts and skills Design, Lab 1: this chapter. Labs are listed n order of increasing difficulty. Designing a Database for Phil's infructions: Consider the following set of requirements Phil's Limousine Service: for For each driver, the company keeps track of the driver's name (first name and last name), driver's address (street, city, state, postal code), driver's license number, home telephone number, and cell telephone number. For each limousine, the company keeps track of a unique limousine ID number, limousine license number, limousine color, and number of passengers the limousine can hold. A driver can be than one limousine. A limousine will have multiple drivers but assigned to more only one driver at a time.

Explanation / Answer

1.

Entities

Attributes

DriverLicenseNumber,FirstName,LastName,Street,City,State,PostalCode,HomePhone,CellPhone, LimoID,LimoLicenseNumber,Color,Passengers

2. Functional Dependencies

DriverLicenseNumber -> FirstName

DriverLicenseNumber ->LastName

DriverLicenseNumber -> Street

DriverLicenseNumber ->City

DriverLicenseNumber ->State

DriverLicenseNumber ->PostalCode

DriverLicenseNumber ->HomePhone

DriverLicenseNumber ->CellPhone

LimoID -> LimoLicenseNumber

LimoID ->Color

LimoID ->Passengers

3. 3NF relations

DRIVER(DriverLicenseNumber,FirstName,LastName,Street,City,State,PostalCode,HomePhone,CellPhone,LimoID)

LIMOUSINE(LimoID,LimoLicenseNumber,Color,Passengers)

underlined are primary keys and italicised is foreign key

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.