Alternative ER Diagram.
Customer data table creation action with ENUM types created.
Customer Table, Warehouse blocks Table, Products Table.
Drop Temp Table.
ER Diagram used to describe relationship database model of a warehouse and its transactions.
Initial Excel Sheet.
Insert the values of distinct values of cost of product, product importance and weight in gms from customer data table into products table.
Insert the values of gender from customer data into customers table.
Query for Total number of calls for late deliveries.
Query to Create table in pgAdmin to match the data.
Query to know Average customer rating for when early and late delivery.
Query to know How many times each mode of shipment was used.
Query to know Percentage of shipments that where on time.
Query to know The average discount offered for Ship delivery for each level of importance.
Select and view Customers Table.
Table created in Excel.
Temp table created.