Microsoft Access 2010 Chapter 11 Lab 1 Designing a Database for Phils Limousine

Description

Microsoft Access 2010 Chapter 11 Lab 1 Designing a Database for Phils Limousine

Lab 1: Designing a Database for Phil’s Limousine
Instructions: Consider the following set of requirements for Phil’s Limousine Service:
• 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 assigned to more than one limousine. A limousine will have multiple drivers but only one driver at a time.
Based on these requirements, do the following:
1. Identify and list the entities and the attributes of those entities.
2. Identify and list the functional dependencies.
3. Create a set of 3NF relations using the shorthand notation given in the chapter. Be sure to identify all primary keys and foreign keys appropriately.
Submit your database design in the format specified by your instructor.