[Solved]40 Points Construct E R Diagram Contact Management System Salespeople Widget Shop Data Sto Q37092920

E-R Diagrams.

(40 points) Construct an E-R diagram for a Contact Management system for salespeople in our Widget Shop. The data stored in this system includes information about the widgets and customer leads. The information stored about widgets is the same as in our order fulfillment system. The information stored about customers includes their ID, name, phone numbers, address, notes, and widgets in which they are interested. Each customer will have multiple notes taken about them-but only one note per date. Each note should include the date that it was recorded, and a text description with a maximum length of 2000 characters. In addition, the database should record which widgets the customer is interested in, if any. You should not add extra attributes (beyond those specified above). Be sure to indicate mapping cardinalities. Also, designate a reasonable primary key for each strong entity set. Document any assumptions you make in choosing primary keys. 1. (30 points) Reduce the E-R diagram you constructed in part 1 to a collection of table schemas (i.e. the name of each table and its attributes/columns). Do not include any redundant tables. 2. Show transcribed image text (40 points) Construct an E-R diagram for a Contact Management system for salespeople in our Widget Shop. The data stored in this system includes information about the widgets and customer leads. The information stored about widgets is the same as in our order fulfillment system. The information stored about customers includes their ID, name, phone numbers, address, notes, and widgets in which they are interested. Each customer will have multiple notes taken about them-but only one note per date. Each note should include the date that it was recorded, and a text description with a maximum length of 2000 characters. In addition, the database should record which widgets the customer is interested in, if any. You should not add extra attributes (beyond those specified above). Be sure to indicate mapping cardinalities. Also, designate a reasonable primary key for each strong entity set. Document any assumptions you make in choosing primary keys. 1. (30 points) Reduce the E-R diagram you constructed in part 1 to a collection of table schemas (i.e. the name of each table and its attributes/columns). Do not include any redundant tables. 2.

Expert Answer

---

Answer to (40 points) Construct an E-R diagram for a Contact Management system for salespeople in our Widget Shop. The data stored… . . .