Question: Please explain and create data model (ERDs) for the data problem below...an identifier is a table name and attributes are fields/columns within that table. Consider
Please explain and create data model (ERDs) for the data problem below...an identifier is a table name and attributes are fields/columns within that table.



Consider the data model in Figure 5-43. How should this model be altered if the users want to keep track of how many of each part are used? Suppose, for example, that the wheel assembly requires four washers and the handle assembly requires just one, and the database must store these quantities. (Hint: Adding Quantity to this N:M relationship is analogous to adding Price to the N:M rela- tionship in Figure 5-22.) PART FIGURE 5-43 Data Model for the Bill of Materials in Figure 5-42 as an IN:M Recursive Relationship PartName Other Data ... PART COMPANY FIGURE 5-22 Association Pattern Data Model for the Report in Figure 5-21 PartNumber Company Name PartName Sales Price ReOrder Quantity QuantityOnHand City Country Volume QUOTATION PartNumber Company Name Price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
