Arrowhead Gallery is a high-end art dealer. Each artwork is uniquely identified by an artwork identification number
Question:
Arrowhead Gallery is a high-end art dealer. Each artwork is uniquely identified by an artwork identification number and is also characterized by a title, artist, date, asking price, and open- ended comments. Arrowhead Gallery works with many people, called clients, who both sell and buy items from the store. Some clients only sell items to Arrowhead Gallery, some only buy items, and some others both sell and buy. A client is identified by a client identification number and is also described by a client name and client address. When Arrowhead Gallery sells an artwork to a client, it records the commission paid, the actual selling price, sales tax (tax of zero means it was tax-exempt), and date sold. When Arrowhead Gallery buys an item from a client, it records the date and transaction cost, any discount negotiated with the seller and the condition of the item at time of purchase. Note that the same artwork item may be bought and sold multiple times, and a sale or a purchase is always for a single piece of artwork.
1) Review the described business scenarios and write down the business rules to justify the cardinality and participation constraints.
2) Draw an entity-relationship diagram (ERD) (crow's foot method) using standard notations.
3) In your ERD, do not use relationship attributes!
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi