a Excise 11 James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased f

[answerhappygod]

A Excise 11 James River Jewelry Is A Small Jewelry Shop While James River Jewelry Does Sell Typical Jewelry Purchased F 1 (80.58 KiB) Viewed 81 times

a Excise 11 James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry purchased for jewelry vendors, including such items as rings, necklaces, earrings, and watches, it specializes in hard to find Asian jewelry. Although some Asian jewelry is manufactured jewelry purchased from vendors in the same manner as the standard jewelry is obtained, many of the Asian jewelry pieces are often unique single items purchased directly from the artisan who created the piece (the term "manufactured" would be an inappropriate description of these pieces). It has a small but loyal clientele, and it wants to further increase customer loyalty by creating a frequent buyer program. In this program, after every 10 purchases, a customer will receive a credit equal to 50 percent of the sum of his or her 10 most recent purchases. This credit must be applied to the next (or "11") purchase. Figure D-1 shows data that James River Jewelry collects for its frequent buyer program dom 2012 1992 40 Per com ch MA 9102013 Phone La Pret 091 cercom vocember Tood 1019 1600 1080 1040 11.2017 2012 19600 2010 7500 200 2000 wewcom between Terby cm 5 1 100 וואן 1000 1010 35 Figure D-1: Sample Data for James River Jewelry 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 corupany 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 Drawan Edata 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 version). Use the IE Crow's Foot R model for your E R diagrams. Justify the decisions you make regarding minimum and maximum cardinality, B. Extend and modify the ER 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. C Extend and modify the ER 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