Description

Harry 2005 Math Ritu $25
Ellen 2008 Physics Dan $35
Ansh 2005 English Larry $40
Gloria 2006 Math Ritu $25
Harry 2005 Computer Science Christie $30

Statement1: Gary was born in 2000.

Statement2: Gary is taught Math by Ritu.

Statement3: Cathie charges $30 per hour to teach Math.

Question 2: Given CUSTOMER (CustomerID, Name, Street, City, State, Zip, Phone)
CustomerID Name Street City State Zip Phone
C101 Smith Harry 123 RidgeLand Oakville ON L9M 2P4 416-555-1212
C102 Arthur Weasly 11 Nova Street Sherbrooke PQ J1C 0A1 819-555-1212

a. List all non-full functional dependencies in CUSTOMER, if any.
b. Prove that CUSTOMER is in 2NF.
c. Is CUSTOMER in 3NF? If not, decompose it into smaller relations such that the resulting relations are in 3NF.