Bob's Bookworld is a wholesale supplier of textbooks to college bookstores. The company would like to develop a database for tracking customer orders. Textbooks are identified by the ISBN (International Standard Book Number) printed on their back cover and are also characterized by title, subject, and price. College bookstores are each assigned a unique customer ID and are also characterized by their store name, shipping address, and phone number. When a college bookstore places an order, the order is assigned a unique order number. Orders can include multiple copies of a single textbook and/or different textbooks. For each textbook ordered, the quantity ordered should be recorded. The date the order was placed and the total amount of the order should also be stored.

part 1: Identify the primary key for each entity.

part 2: List the data attributes for each entity.

part 3: Identify any composite attributes and describe how each can be subdivided.

part 4: Identify any derived attributes.

part 5: Draw a Crow's Foot model ERD showing each entity, its attributes, and its relationships to the other entities. State any assumptions that you make.

part 6: Bob's Bookworld has decided that the database also needs to track the author(s) of each textbook. How does this change your database design? Explain.