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 scenario in each problem. Use the model constructs (e.g., the material on the E-R model and the enhanced E-R model)

Do not use the modeling conventions in Visio notation. Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models.

  1. Stillwater Antiques buys and sells antiques. Attributes of Antique Item include ItemID, Description, Price, and Condition. Clients buy and sell Antique Items. Some Clients only sell Antique Items, some Clients only buy Antique Items, and some Clients buy and sell Antique Items. There are no other types of Clients. Attributes of Buying Clients include ClientID, ClientName (composed of FirstName, MiddleInitial, and LastName), and CreditLine. Attributes of SellingClients include ClientID, ClientName (composed of FirstName, MiddleInitial, and LastName), and ClientRating. Buying Clients can buy many Antique Items over time and must have bought at least one Antique Item. An Antique Item can be bought by at most one Buying Client and may not have been bought. Selling Clients can sell many Antique Items over time and must have sold at least one Antique Item. An Antique Item is sold by exactly one Selling Client.

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!