Business Data Management [BDM] #1: Conceptual Data Modeling ER Diagram

Based on the business rules presented below (a. through d.), complete the following tasks:

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

2. ii) 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. iii) Thinkofatleastoneextraattributeforeachentityandaddittothelistofattributesthatyou identified for each entity in i) above. Explain briefly the meaning and potential business use of each extra attribute.

4. iv) Create an ER diagram based on your answer in i), ii) and iii) above using draw.io diagraming tools. 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.

[Business Rules]

1. An employee is identified by an employ number, and he/she has first name, last name, birth date, gender, and date of hire.

2. An employee may take managerial positions at multiple departments during his/her employment, and each position is recorded with its start date and end date. Also, an employee may be assigned to multiple departments as a non-managerial employee during his/her employment, and each assignment is recorded with its start date and end date.

3. A department is identified by a department number, and each department has a name. Each department has many managerial employees and many non-managerial employees throughout its operation.

4. A division is identified by a division number, and each division has a name. Each division has many departments, and a department should belong to one specific division.

   Note 2: [Submission guidelines] First, prepare your answers to the tasks from i), ii), and iii) above in a word file, then add your ER diagram 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.