Suppose you are required to model an “E-Furniture Store” system for an organization to get complete understanding of the domain.

Suppose you are required to model an “E-Furniture Store” system for an organization to get a complete understanding of the domain. This E-Furniture system provides the distribution of furniture all over the country. 

The system’s requirements in the textual format are given below in paragraphs.

The system will display the available item types such as sofa_set, chairs, bed_set, etc along with their respective item images, names, prices, number of items available in stock, and related descriptions.

Anyone can view available items however only clients (registered individual users or distributors) can interact with the website. Clients will be able to purchase items available on the website, they can also place a customized order for items with their own choice of materials, fabrics, description, wood type, number of items, etc. Clients can also specify required completion data for customized orders. Clients will also be able to view the invoice.

Managers can view order details and can process the orders. He/She can also generate invoices. The manager also wants to keep a record of available stock.

Managers can allocate customized orders to carpenters and can view allocated order details. Carpenters will be able to view allocated customized order detail, and they can also update the status of the order.

You are required to perform the following tasks according to the above scenario.

l  Identify all valid Entities.                                       

l  Draw the Entity Relationship Diagram (ERD).

l  Draw relationship cardinalities in alphabetical notation.

Solution:

Entities:

1.        Item

2.        Item type

3.        Clients

4.        Order

5.        Customized-order

6.        Stock

7.        Manager

8.        Carpenter

9.        Invoice

Entity Relationship Diagram (ERD)