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. 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. A. Draw an E-R data model for the James River Jewelry database schema shown in the James River Jewelry Project Questions for Chapter 3 in this Appendix (refer to pp 235-236 textbook 7th version). Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality. B. Extend and modify the E-R data model to show James River Jewelry’s award program. 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.
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.
A. Draw an E-R data model for the James River Jewelry database schema shown in the James River Jewelry Project Questions for Chapter 3 in this Appendix (refer to pp 235-236 textbook 7th version). Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.
B. Extend and modify the E-R data model to show James River Jewelry’s award program. 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.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
