Answer to Question #208382 in Programming & Computer Science for Navya kala

Question

Roclo Enterprise Database Design:

Rolco is a Retail Supermarket based on USA. They want to build three different databases for Warehouse, Sales & Cargo Departments to maintain their product-stocks, customers & product delivery details. Please find the functionalities of the departments below. Draw ER diagrams for all the departments by identifying the entities, attributes and relationship between entities.

Warehouse Department:

Maintain the products details

Maintain the supplier details

Maintain Stock Details with expiry date and barcode

Maintain Payment details

Sales Department:

Maintain the products details

Maintain the customer details

Maintain membership details for customers

Maintain Invoice details

Maintain payment Due details (Optional)

Cargo Department:

Maintain the products details

Maintain the customer details

Maintain Shipping Container details

Maintain delivery status details

Answer 1

Dear Navya kala, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order