normalization

arosehn
LaundryCareERD.pdf

Credit Card company

PK FK1

CreditCard_ID Customer_ID

Type_Of_Payment

Customer

Customer_ID CPR

First Name Last Name

Address Email

Contact No. Employee

PK Employee_ID Employee Name

Position Salary Email

Delivery

PK FK1 FK2 FK3

Delivery_ID Employee_ID Services_ID Customer_ID Delivery_Date

Status

Services

PK FK1 FK2 FK3

Service_ID Customer_ID Employee_ID No_Of_items

Type_Of_Service Price

Books

Provides

Chooses

delivers

Manages

Handles