3 Part question Bob\'s Bookworld is a wholesale supplier of textbooks to college
ID: 3696679 • Letter: 3
Question
3 Part question
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. Describe the type of relationship that exists between the CUSTOMER and ORDER entities.
Part 2. Describe the type of relationship that exists between the ORDER and TEXTBOOK entities.
Part 3. Is a composite entity needed? If so, name the composite entity and describe its relationship with the entities that it bridges.
Explanation / Answer
Part 1 Describe the type of relationship that exists between the CUSTOMER and ORDER entities.
Answer : An One-Many relationship exists between the CUSTOMER and ORDER entities.
Part 2. Describe the type of relationship that exists between the ORDER and TEXTBOOK entities.
Answer : An One-Many relationship exists between the ORDER and TEXTBOOK entities.
Part 3. Is a composite entity needed? If so, name the composite entity and describe its relationship with the entities that it bridges.
Answer:
Yes,a composite entity is needed.The composite entity CUSTOMER,ORDER & TEXTBOOK.
CUSTOMER---PLACES-----ORDER(One : Many)
ORDER----------INCLUDES-----TEXTBOOKS(One : Many)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.