Task 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows: Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price. Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall. Each supplier has a supplier name and address. A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product. A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf number is not unique across warehouses, but it is unique within each warehouse. For example, warehouse A has only one shelf numbered as 14 and warehouse B may also have one shelf numbered as 14. Products are sent to warehouses for storage. For the ease of product distribution, the shopping mall records the warehouses and shelf-numbers for storing each product, together with the quantity for the product. Each customer of the shopping mall is identified by a customer ID. Information about shopping mall employees includes a unique employee ID, and his/her name and position. Some customers are VIP customers who are identified by a membership number and have a name and contact number. While a VIP customer is serviced by one service specialist (who is an employee). A service specialist cares for several VIP customers. Customers can place multiple purchase orders. Each order is described by the date of the order and quantity of the clothes s/he orders. VIP customers can receive a discount rate on their purchase.
Task 1: ER diagram for give scenario
Consider building a
Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price.
Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall.
Each supplier has a supplier name and address.
A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product.
A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product
The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf number is not unique across warehouses, but it is unique within each warehouse. For example, warehouse A has only one shelf numbered as 14 and warehouse B may also have one shelf numbered as 14.
Products are sent to warehouses for storage. For the ease of product distribution, the shopping mall records the warehouses and shelf-numbers for storing each product, together with the quantity for the product.
Each customer of the shopping mall is identified by a customer ID.
Information about shopping mall employees includes a unique employee ID, and his/her name and position.
Some customers are VIP customers who are identified by a membership number and have a name and contact number. While a VIP customer is serviced by one service specialist (who is an employee). A service specialist cares for several VIP customers.
Customers can place multiple purchase orders. Each order is described by the date of the order and quantity of the clothes s/he orders. VIP customers can receive a discount rate on their purchase.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
