Normalization for Temi Logistics

gistfile1.txt

Normalization for Temi Logistics

1. Entities
Customers
Orders
OrderDetails
Packages and Collies
Dispatchers
Routes
Van
Motorcyle
Drivers



2. Identify attributes and define attribute data type
Customers:- customer_id first_name: String,  last_name: String,home_address, email, phone_number,
Orders: order_id: Int, weight: Int, receiver_full_name: String, receiver_address:String, receiver_phone_number,  customer_id: Int,
OrderDetails: orderdetail_id: Int, order_handling_condition: String, content_of_order: String, order_id: Int 
Packages and Collies: package_collies_id: Int., order_of_the_same_handling: String, package_type: String, orderdetail_id: Int
Dispatchers: dispatcher_id: Int, package_collies_id: Int, motorcyle_id: Int,
Routes: route_id: Int, destination(city): Int, dispatcher_id: Int,
Van: van_id:Int, van_maker: String, van_model:String, van_color: String, 
Motorcyle: motorcyle_id: Int, route_id:Int, dispatcher_id
drivers: drivers_id: Int, full_name: String, DOB: Date, driver_licence: String, gender String, Religion: String, package_collies_id: Int,

3. Identify relationships: 
Customers- Orders 1:M
Orders - OrderDetails 1:M
OrderDetails - Packages and Collies 1:M
Dispatchers - Routes 1:M
drivers: Van 1:1
Dispatchers: Motorcycle 1:1
Driver - Routes 1:M
Dispatchers -Packages and Collies 1:M






https://docs.google.com/document/d/11CKcfEu_zxyWgBY3T35JYZDCNu7KZrjFbbLuJhn-9OQ/edit?usp=sharing

Hi Temitop, please find some more time to clean up this DB design. Well done