I wrote a relational model for the ER form, but I failed to normalize it. I separated
Question:
I wrote a relational model for the ER form, but I failed to normalize it. I separated customer contact from customer but I think there should be more. According to the EER chart given, is this relational model on its'3rd normalization form? If not, what else should I do? Thank you!
Below is my relational model and ER model
Supermarket (supID, name, address)
Grocery (prodID, aval quant, name, price)
Shopper (supID, shopperID, name, shopping rate.)
FOREIGN KEY supID refers to supID in supermarket; NULL NOT ALLOWED
Driver (driverID, name ,driving rate)
Customer(customerID, name, address, payment method)
Customer contact(customerID, phonenum, email)
Order (orderID, order time, delivered time, quant needed)
Case (caseID, duration, calltime, solve or not)
Customer service (workerID, name, service rate)
Foundations of Financial Management
ISBN: 978-1259024979
10th Canadian edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta