Question: Draw a conceptual data model to model the scenario in each problem. Use the model constructs (e.g., the material on the E-R model and the

Draw a conceptual data model to model the

Draw a conceptual data model to model the scenario in each problem. Use the model constructs (e.g., the material on the E-R model and the enhanced E-R model) Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models. Question : Chegg Books sells books. Attributes of Book are ISBN, BookTitle, BookPrice BookCost, and BookProfit. BookProfit is calculated as the difference between BookPrice and BookCost. Attributes of BookCustomer are BCustomerID, BCustomerName (composed of BFirstName, BMiddleInitial, and BLastName), BCustomerAddress (composed of BStreetAddress, BCity, BState, and BZipCode), and CustomerEmailAddresses. Some of the BookCustomers have more than one CustomerEmailAddress. BookCustomers must have placed at least one BookOrder and many BookCustomers place more than one BookOrder over time. Each BookOrder is placed by a single BookCustomer. Attributes of BookOrder are BOrderNum, BOrderReceivedDate, BOrderShippedDate, and DaysToShip. DaysToShip is calculated as the number of days between the BOrderShippedDate and the BOrderReceived Date. A BookOrder must include at least one Book and may include any number of Books greater than or equal to one. A Book may be included in more than one BookOrder, but sadly some Books have never been ordered and are sitting on the shelves at chegg Books gathering dust. Occasionally a BookOrder includes more than one copy of the same Book, so the BookOrderQuantity attribute is used to keep track of the number of copies of each Book included in a BookOrder

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!