Now, James River Jewelry wants to expand its database applications beyond the recording of purchases and purchase awards. (See the description of the award program in the James River Jewelry Project Questions for Chapter 1 that is online in Appendix D.) (Refer to blackboard/appendix/appendix D) The company still wants to maintain data on customers, purchases, and awards, but it wants to include other data as well. Specifically, James River Jewelry wants to record artists and styles and keep track of which customers are interested in which artists and styles.
Now, James River Jewelry wants to expand its
James River Jewelry sells most of its jewelry on consignment, so the company does not pay the artist for a piece of jewelry until it is sold. Typically, the company pays artists 60 percent of the sales price, but the terms are negotiated separately for each item. For some items, the artists earn a larger percentage and for others they earn less. Artists and James River Jewelry personnel agree on the initial sales price at the time the item is brought to the shop. When an item has been in the shop for some time, James River Jewelry may reduce the price; sometimes it renegotiates the sales percentage.
C.Extend and modify the E-R data model in part B to meet James River Jewelry’s new requirements. Use the IE Crow’s Foot E-R model for your E-R diagrams. Create appropriate identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality.
D. Describe how you would go about validating the data model in part C.
ER Diagram for the given Scenario
Step by step
Solved in 2 steps with 2 images
