1) Consider designing a database for an antique store. What entities would you include? What would their attributes be?
2) Create a full ER diagram for the antique store mentioned in question 1. The store handles household furnishings, jewelry, toys, and tools. The owner of the store owns most of what they have for sale, but they handle some items on consignment (i.e., they sell the item for the owner, thus earning a commission on the sale). Some customers require delivery, so the owner maintains relationships with several local movers. The owner wants to keep track of customers in order to do a better job of marketing. In particular, they know that some customers are particularly interested in certain types of antiques, and they'd like to be able to find, for example, all those customers interested in cameo jewelry.
For business auditing and tax purposes, it's very important that the database tracks expenditures and revenues. The owner wants to track what they spent for each item, and what they earned in selling it. These requirements also mean that they have to track store expenses like rent and heat, and their employee expenses (they employ two part-time people to help run the store).