This assignment is about Normalization 1NF, 2NF, 3NF I feel as though I am missing something with this and am confused.

Have done a good amount of this, but feel like I am doing it wrong. Want to continue to try at this, but would like to have an answer key to look off of. Thank you.

1. Pharmacy(patient_id, patient_name, address, (Rx_num, trademark_name, generic_name, (filldate, num_refills_left), num_refills))

Functional Dependencies:

patient_id patient_name, address

patient_id, Rx_num trademark_name, generic_name

Rx_num num_refills

Rx_num, filldate num_refills_left

1. Is this relation in 1NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

Pharmacy(patient_id, patient_name, address, Rx_num, trademark_name, generic_name, filldate, num_refills_left, num_refills)

This is in 1NF because their primary keys and there are no repeating groups.

(b) Is this relation in 2NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(c) Is this relation in 3NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

2. Company(EmpID, EmpName, EmpAddr, (ProjID, ProjName, MgrID, MgrName, HoursWorked))

Functional Dependencies:

EmpID EmpName, EmpAddr, ProjID

ProjID ProjName, MgrID, MgrName

EmpID, ProjID HoursWorked

MgrID MgrName

(a) Is this relation in 1NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(b) Is this relation in 2NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(c) Is this relation in 3NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

3. Property(id, county, lotNum, lotArea, price, taxRate, (datePaid, amount))

Functional Dependencies:

id county, lotNum, lotArea, price, taxRate

lotArea price

county taxRate

datePaid amount

(a) Is this relation in 1NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(b) Is this relation in 2NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(c) Is this relation in 3NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

4. StockExchange(Company, Symbol, HQ, Date, ClosePrice)

Functional Dependencies:

Symbol, Date Company, HQ, ClosePrice

Symbol Company, HQ

Symbol HQ

(a) Is this relation in 1NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(b) Is this relation in 2NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.

(c) Is this relation in 3NF? If not, write an explanation of why it isnt, then make the changes necessary to fix it.