1) Property# below is the Primary Key

Violation?

Part B:

This case study is based on Ajax Vacation Rentals (a fictitious inspection company) that rents vacation homes in the mountains for owners. The Rental Report will show the rental date information and the inspector who inspected the property after the completion of the rental. Examples of the Ajax Vacation Rental Report are presented below.

1. Convert the form above into a table of information. Note: You will be expected to be able to do this when looking at a form(s). To help you get started this has been done as seen below.

2. What is the Primary Key of the table above?

3. Is the table above in 1^st Normal Form? Yes No

If not, why?

If not, correct the table to be in 1^st Normal Form (You can show it in a sentence structure format)

A sentence structure of the fields in 1NF would be as follows:

4. Transform the table above into 2^nd Normal Form. Begin by indicating if it is in 2NF or not and then identify all the dependencies.

a. In 2^NF ?

b. Dependencies include;

c. Put the table in 2NF using Sentence Structure:

Sentence Structure:

5. Transform the table(s) in #4 above into 3^RD Normal Form. Begin by indicating if it is in 3NF or not and then identify all the dependencies.

a. In 3NF ?

b. Dependencies include;

c. Put the table in 2NF:

Sentence Structure:

6. Transform the table(s) in #5 above into BCNF Normal Form. Begin by indicating if it is in BCNF or not and then identify all the dependencies.

7. Is the relation shown in #6 above in 4NF? If not, why not?

PROPERTY OWNER Property# PG4 PG16 PG36 Address City Rent Owner# OwnerName 6 Lawrence StMemphis 5 Novar Dr 2 Manor Rd 750 CO40 Tina Murphy Memphis 895 C093 Tony Shaw Memphis 810 CO93 Tony Shaw