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
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
- 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.
- Describe how you would go about validating the data model in part C.
![Phone
555-236-7789
555-236-0091
555-236-0392
555-236-4493
555-236-3334
555-236-7789
555-236-0392
555-236-7789
555-236-1095
InvoiceNumber
1000
1010
1020
1030
1040
1050
1060
Date
5/5/2012
5/7/2012
5/11/2012
5/15/2012
5/15/2012
Pre TaxAmount
155.00
Name
Elizabeth Stanley
Fred Price
Linda Becky
Email
Elizabeth. Stanley@somewhere.com
Fred. Price@somewhere.com
Linda Becky@somewhere.com
Pamela Birch@somewhere.com
Richard.Romez@somewhere.com
Elizabeth Stanley@somewhere.com
Linda Becky@somewhere.com
Elizabeth. Stanley@somewhere.com
Samantha Jackson@somewhere.com
203.00
75.00
67.00
330.00
25.00
45.00
445.00
Pamela Birch
Richardo Romez
Elizabeth Stanley
Linda Becky
Elizabeth Stanley
Samantha Jackson
5/16/2012
5/16/2012
5/18/2012
1070
1080
5/19/2012
72.00
Figure D-1: Sample Data for James River Jewelry](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F788dab94-01ba-414a-9745-8d14d9dc9223%2Ff6f2abba-a0a5-4503-9654-81c83d801e76%2Frhvi2c_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
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
- 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.
- Describe how you would go about validating the data model in part C.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)