DBMS Assign 2

NormalizationAssignment.docx

Normalization Exercise

BIS 638 – Database Management for Business Systems

The following table shows a partial list of appointments for a pet grooming salon:

Field Descriptions:

ApptID – ID number of the appointment

ApptDate – date of the appointment

ApptTime – time of the appointment

CustID – ID number of the customer

CustPhone – phone number of the customer

PetName – name of the pet being groomed

TechID – ID number of the technician performing the grooming service

ServiceID – ID number of the grooming service being performed (an appointment can include multiple services)

ServiceName – name of grooming service being performed

1. Use arrows to show the functional dependencies in the table.

2. Convert the table to 3NF.