1. Consider the following relation:

CAR_SALE(Car#, Date_sold, Salesman#, Commission%, Discount_amt)

Assume that a car may be sold by multiple salesmen, and hence {Car#, Saleman#} is the primary key. Additional dependencies are

Date_sold -> Discount_amt
Salesman# -> Commission%

a) Based on the given primary key, is this relation in 1NF, 2NF, or 3NF? Why?

b) Normalize the design so that the resulting relational schemas are in 3NF. Only list the final relational schemas, no process necessary.

2. Below is one report from some pet clinic: see image.

Un-normalized form (UNF): (PET_ID, PET_NAME, PET_TYPE, PET-AGE, OWNER, (VISIT_DATE, PROC_NO, PROC_DESC)* )

a) Based on the data, is the UNF in 1NF, 2NF, or 3NF?

b) Normalize the design so that the resulting relational schemas are in 3NF. Only list the final relational schemas, no process necessary.

Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.