During COVID-19 pandemic, it is not safe for the people to go out frequently for their daily needs. Similarly, people cannot live without their daily needs. ‘Online Sheba’ can minimize the suffering of people. ‘Online Sheba’ provides food delivery, emergency medicine delivery, laundry and grocery delivery. Besides, ‘Online Sheba’ provides courier services also. In this case, you have to build database management system for ‘Online Sheba’ to handle all the services it provides and to store all information related to ‘Online Sheba’ securely, like employee, customer, safety vehicle, shops, seller, receiver information. ‘Online Sheba’ provides few home services, food delivery, emergency medicine delivery, laundry, grocery delivery & courier service. Therefore, it must have few employees to initiate all the work. As COVID-19, safety issue is a very important factor; every employee must have a safety report. However, similar safety report is acceptable for multiple employees. For each delivery, there must have one employee to initialize the service but an employee can perform multiple deliveries at different time or day. A service can provide multiple deliveries but each delivery must be contained in a service. A shop can conduct multiple deliveries but each delivery must be placed from one shop. A product can be delivered multiple times but each delivery must contain one type of product. Each user can perform multiple deliveries but each delivery must be conducted by one user. A customer can purchase multiple deliveries but each delivery must be purchased by one customer. A vehicle can be assigned for multiple deliveries at different time or day but each delivery must have one vehicle to initiate order. Entities and Attributes (Key): --------------------------- Employee- (Employee_ID,Name,Emp_Address,Phone,Position,Salary) SAFETY- (Covid_Report,Mask,Gloves,Hand_Sanitizer) CUSTOMER- (Customer_ID,Name,Cust_Address,phone) SHOPS- (Shop_ID,Name,Opening_Time,Closing_Time) VEHICLE- (Vehicle_ID,Vehicle_TYPE,Maintain_Cost) SERVICE- (Service_ID,Serv_Name, Service_Charge,Rating) DELIVERY- (Delivery_ID, Delivery_Time,Delivery_Date) Entities and Relationships: Every employee must have one safety report and each safety report must contain to at least one employee but similar safety report can be acceptable for multiple employees. Safety table depends on employee id to be uniquely identified. EMPLOYEE-SAFETY(Many to one) An employee can have multiple delivery but each delivery must be conducted by one employee. EMPLOYEE-DELIVERY(One to Many) A delivery must be conducted from one service but under a service, multiple deliveries can take place. SERVICE-DELIVERY(One to Many) A delivery must be conducted from one shop but under a shop, multiple deliveries can take place. SERVICE-DELIVERY(One to Many) Same product can be delivered multiple time but each delivery must contain one type of product. PRODUCT-DELIVERY(One to Many) Each user can perform multiple deliveries but each delivery must be conducted by one user. USER-DELIVERY(One to Many) A customer can purchase multiple deliveries but each delivery must be purchased by one customer. CUSTOMER-DELIVERY(One to Many) A vehicle can be assigned for multiple deliveries at different time or day but each delivery must have one vehicle to initiate order. VEHICLE-DELIVERY(One to Many)
Draw ER Diagram & Schema Diagram
================================
ER Diagram Description...
During COVID-19 pandemic, it is not safe for the people to go out frequently for their daily needs. Similarly, people cannot live without their daily needs. ‘Online Sheba’ can minimize the suffering of people. ‘Online Sheba’ provides food delivery, emergency medicine delivery, laundry and grocery delivery. Besides, ‘Online Sheba’ provides courier services also. In this case, you have to build
‘Online Sheba’ provides few home services, food delivery, emergency medicine delivery, laundry, grocery delivery & courier service. Therefore, it must have few employees to initiate all the work. As COVID-19, safety issue is a very important factor; every employee must have a safety report. However, similar safety report is acceptable for multiple employees. For each delivery, there must have one employee to initialize the service but an employee can perform multiple deliveries at different time or day. A service can provide multiple deliveries but each delivery must be contained in a service. A shop can conduct multiple deliveries but each delivery must be placed from one shop. A product can be delivered multiple times but each delivery must contain one type of product. Each user can perform multiple deliveries but each delivery must be conducted by one user. A customer can purchase multiple deliveries but each delivery must be purchased by one customer. A vehicle can be assigned for multiple deliveries at different time or day but each delivery must have one vehicle to initiate order.
Entities and Attributes (Key):
---------------------------
Employee- (Employee_ID,Name,Emp_Address,Phone,Position,Salary)
SAFETY- (Covid_Report,Mask,Gloves,Hand_Sanitizer)
CUSTOMER- (Customer_ID,Name,Cust_Address,phone)
SHOPS- (Shop_ID,Name,Opening_Time,Closing_Time)
VEHICLE- (Vehicle_ID,Vehicle_TYPE,Maintain_Cost)
SERVICE- (Service_ID,Serv_Name, Service_Charge,Rating)
DELIVERY- (Delivery_ID, Delivery_Time,Delivery_Date)
Entities and Relationships:
Every employee must have one safety report and each safety report must contain to at least one employee but similar safety report can be acceptable for multiple employees. Safety table depends on employee id to be uniquely identified.
EMPLOYEE-SAFETY(Many to one)
An employee can have multiple delivery but each delivery must be conducted by one employee.
EMPLOYEE-DELIVERY(One to Many)
A delivery must be conducted from one service but under a service, multiple deliveries can take place.
SERVICE-DELIVERY(One to Many)
A delivery must be conducted from one shop but under a shop, multiple deliveries can take place.
SERVICE-DELIVERY(One to Many)
Same product can be delivered multiple time but each delivery must contain one type of product.
PRODUCT-DELIVERY(One to Many)
Each user can perform multiple deliveries but each delivery must be conducted by one user.
USER-DELIVERY(One to Many)
A customer can purchase multiple deliveries but each delivery must be purchased by one customer.
CUSTOMER-DELIVERY(One to Many)
A vehicle can be assigned for multiple deliveries at different time or day but each delivery must have one vehicle to initiate order.
VEHICLE-DELIVERY(One to Many)
Step by step
Solved in 3 steps with 2 images