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)

 

name shopperID supID name supID shopping rate name address name (1,n) Supermarket provide grocery (1,m) ID work at shopper shop for contact/rate phonenum customer address email caseID duration orderID rate payment method solve or not rate/solve case name calltime price aval quant prod ID contain ordertime make workerID service rate customer service order delivtime quantity needed deliver name driverID driver driving rate change/cancel track