Question: Consider the project data model shown in Figure 1-16. a. Create a textual description of the diagrammatic representation shown in the figure. Ensure that the

Consider the project data model shown in Figure 1-16.

a. Create a textual description of the diagrammatic representation shown in the figure. Ensure that the description captures the rules/constraints conveyed by the model.

b. In arriving at the requirements document, what aspect of the diagram did you find was the most difficult to describe? Which parts of the requirements do you still consider to be a little ambiguous? In your opinion, what is the underlying reason for this ambiguity?

Figure 1-16

CUSTOMER Customer ID Customer Name Customer Type Customer Zip Code Customer Years

CUSTOMER Customer ID Customer Name Customer Type Customer Zip Code Customer Years Places ORDER Order Number Order Placement Date Order Fulfillment Date Order Number of Shipments Is billed on Invoice Number Order Number Invoice Date INVOICE Contains Is paid on ORDER LINE Order Number Product ID Order Quantity PAYMENT Invoice Number Payment Date Payment Amount PRODUCT LINE Product Line Name PL Prior Years Sales Goal PL Current Years Sales Goal Includes PRODUCT Product Description Product Finish Product Standard Price Product Cost PR Prior Years Sales Goal PR Current Year Sales Goal Has Product ID

Step by Step Solution

3.41 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer to a The project data model shown in Figure 116 represents the data entities and relationships involved in managing project information The mod... View full answer

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 Modern Database Management 13th Edition Questions!