NORMALIZATTON
DEPENDENCY DIAGRAM
Customer_ Cust_ Cust_Phone Cus_Car_ Car_ Car_SendIn_ Car_SendOut_ Car_
ID Name Cust_Add No RegisteredNo Model Date Date Damage
PD PD
SPID SP_Model SP_Price SP_Sold_Price SP_Quantity SP_Details
PD
TD
Supplier_ Supplier_Tel_No Supplier_Details Clerk_Name Clerk_Tel_No Clerk_
SupplierID Name ClerkID Details
PD PD
MechanicID Mechanic_ Mechanic_Tel_No Mechanic_ Payment_
Name Details ReceiptNo Total Date
PD PD
1NF ( CustomerID, Cus_ Car_RegisteredNo, SPID, SupplierID, ClerkID, MechanicID, Receipt_No, Cust_Name, Cust_Add, Cust_Phone_No,
Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage, SP_Model, SP_Price, SP_Sold_Price, SP_Quantity, SP_Details,
Supplier_Name, Supplier_Tel_No, Supplier_Details, Clerk_Name, Clerk_Tel_No, Clerk_Details, Mechanic_Name, Mechanic_Tel_No,
Mechanic_Details, Total, Payment_Date )
PARTIAL DEPENDENCIES
(CustomerID Cust_Name, Cust_Add, Cust_Phone_No)
(Car_RegisteredNo Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage)
(SPID SP_Model, SP_Price, SP_Sold_Price, SP_Quantity, SP_Details)
(SupplierID Supplier_Name, Supplier_Tel_No, Supplier_Details)
(ClerkID Clerk_Name, Clerk_Tel_No, Clerk_Details)
(MechanicID Mechanic_Name, Mechanic_Tel_No, Mechanic_Details)
(Receipt_No Payment_Date)
TRANSITIVE DEPENDENCY
(SP_Model SP_Price)
2NF
Table : CUSTOMER
Customer_ID Cust_Name Cust_Add Cust_ Phone_No
CUSTOMER (CustomerID, Cust_Name, Cust_Add, Cust_Phone_No)
Table : CAR
Cus_Car_RegisteredNo Car_Model Car_SendIn_Date Car_SendOut_Date Car_Damage
CAR (Cus_Car_RegisteredNo, Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage)
Table : SPARE PARTS
SPID SP_Model SP_Price SP_Sold_Price SP_Quantity SP_Details
TD
SPAREPARTS (SPID, SP_Model, SP_Price, SP_Sold_Price, SP_Quantity, SP_Details)
Table : SUPPLIER
SupplierID Supplier_Name Supplier_Tel_No Supplier_Details
SUPPLIER (SupplierID, Supplier_Name, Supplier_Tel_No, Supplier_Details)
Table : CLERK
ClerkID Clerk_Name Clerk_Tel_No Clerk_Details
CLERK (ClerkID, Clerk_Name, Clerk_Tel_No, Clerk_Details)
Table : MECHANIC
MechanicID Mechanic_Name Mechanic_Tel_No Mechanic_Details
MECHANIC (MechanicID, Mechanic_Name, Mechanic_Tel_No, Mechanic_Details)
Table : CUSTOMER PAYMENT
ReceiptNo Payment_Date
CUSTOMER PAYMENT (Receipt_No, Payment_Date)
Table : TOTAL PAYMENT
Cus_Car_RegisteredNo SPID Total
TOTAL PAYMENT (Cus_Car_RegisteredNo, SPID, Total)
3NF
Table : CUSTOMER
Customer_ID Cust_Name Cust_Add Cust_PN
CUSTOMER (CustomerID, Cust_Name, Cust_Add, Cust_Phone_No)
Table : CAR
Cus_Car_RegisteredNo Car_Model Car_SendIn_Date Car_SendOut_Date Car_Damage
CAR (Cus_Car_RegisteredNo, Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage)
Table : SPARE PARTS
SPID SP_Sold_Price SP_Quantity SP_Details
SPAREPARTS (SPID, SP_Sold_Price, SP_Quantity, SP_Details)
Table : SUPPLIER
SupplierID Supplier_Name Supplier_Tel_No Supplier_Details
SUPPLIER (SupplierID, Supplier_Name, Supplier_Tel_No, Supplier_Details)
Table : CLERK
ClerkID Clerk_Name Clerk_Tel_No Clerk_Details
CLERK (ClerkID, Clerk_Name, Clerk_Tel_No, Clerk_Details)
Table : MECHANIC
MechanicID Mechanic_Name Mechanic_Tel_No Mechanic_Details
MECHANIC (MechanicID, Mechanic_Name, Mechanic_Tel_No, Mechanic_Details)
Table : CUSTOMER PAYMENT
ReceiptNo Payment_Date
CUSTOMER PAYMENT (Receipt_No, Payment_Date)
Table : TOTAL PAYMENT
Cus_Car_RegisteredNo SPID Total
TOTAL PAYMENT (Cus_Car_RegisteredNo, SPID, Total)
Table : SPARE PARTS PRICE
SP_Model SP_Price
SPARE PARTS PRICE (SP_Model, SP_Price)