Fall 2021 ISM218 Homework XXXXXXXXXXpoints) Online Submission through Canvas Course Site Deadline: October 17, 2021 Sunday 11:59PM General Instructions 1. Rename this file with your full name before...

Attached


Fall 2021 ISM218 Homework 01 (100 points) Online Submission through Canvas Course Site Deadline: October 17, 2021 Sunday 11:59PM General Instructions 1. Rename this file with your full name before submission. 2. Paste your solution below each question. 3. Use ERDplus.com to create the Entity Relationship Diagram and Schema Diagram. 4. Make sure the details of your provided illustrations are clear. 5. Late submissions of 0-1 day will receive a 25% penalty, and 1+ days will receive no credit. 6. The page numbers are referring to the textbook. Question 1 (15 points) Chapter 02 MC8 Jones Dozers (page 60) – Writing business requirements from the provided Entity Relationship Diagram. Question 2 (15 points) Chapter 02 MC10 Midtown Memorial (page 60) – Writing business requirements from the provided Entity Relationship Diagram. Question 3 (15+5 points) a) Chapter 02 MC3 Funky Bizz (page 58) – Drawing Entity Relationship Diagram. b) Chapter 03 MC3 Funky Bizz (page 100) – Drawing Schema Diagram. Refer to the question 3(a) Question 4 (15+5 points) a) Chapter 02 MC4 Snooty Fashions (page 59) – Drawing Entity Relationship Diagram. b) Chapter 03 MC4 Snooty Fashion (page 100) – Drawing Schema Diagram. Refer to the question 4(a) Question 5 (15+5 points) a) Chapter 02 MC5 Signum Libri (page 59) – Drawing Entity Relationship Diagram. b) Chapter 03 MC5 Signum Libri (page 100) – Drawing Schema Diagram. Refer to the question 5(a) Question 6 (10 points) Chapter 03 MC7 ExoProtect (page 100) – Drawing Schema Diagram.