Conceptual Data Modeling Creating an ERD

Imagine that you are working at a manufacturing company and create an ERD for your company. Your company has requested your assistance in designing a database based on the following business rules:

[Business Rules]

a. Your company produces multiple products, and the product information to be stored includes product name, product ID and quantity on hand.

b. Products are made up of many components, and the following component information is stored: component ID, component name and description.

c. Suppliers provide components, and the supplier information to be stored includes supplier ID, supplier name and contact person.

d. The date and the quantity of component supplied for each delivery should be stored. e. A supplier can exist without providing components.

f. A component does not have to be associated with a supplier.

g. A component does not have to be associated with a product, and not all component are used in products.

h. A product cannot exist without components.

i. The quantity of each component used for each product should be stored.

[Deliverable]

Based on the business rules presented above, complete the following tasks:

1) Identify entities and their attributes. Also, assign an identifier(s) to each entity.

2) Identify relationships and the degree and cardinality of each relationship. Also, if there are attributes pertaining to a relationship, include the attributes for each relationship. Also, read Note 1 below carefully.

3) Think of at least one extra attribute for each entity and add it to the list of attributes that you identified for each entity in 1) above. Explain briefly the meaning and potential business use of each attribute of your choice.

4) Create an ERD based on your answer in 1), 2) and 3) above using draw.io diagraming tool. Then, prepare and submit your answers according to the guidelines stated in Note 2 below.

Note 1: [Extra explanations/assumptions on your own] While working on the tasks, you may find some parts of business rules, especially related to cardinalities of relationships, incomplete or unclear. In that case, feel free to come up with extra explanations or assumptions on your own and state them explicitly in your answer. Especially when a cardinality may go either way (i.e., optional or mandatory), you should explain why you choose one over the other. Lastly, you should note that your extra explanations and/or assumptions must be consistent with the business rules provided below and some common sense.

Note 2: [Submission guidelines] First, prepare your answers to the tasks from i), ii), and iii) above in a word file, then add your ERD created using draw.io in your word file. Make sure to include your name and student ID in your word file, preferably at the top of the first page. Then, save or print your word file to a pdf file, and submit the pdf file through the Blackboard course website. You are NOT supposed to submit via email, and email submission will be simply disregarded. Also, note that you are supposed to submit ONE single file only, which is the pdf file. Neither a combination of several files nor a zip file of several files will be considered a proper submission.