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.
- 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
Get step-by-step solutions from verified subject matter experts
