Question: Consider the project data model shown in Figure 1-15. 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-15.

PRODUCT LINE CUSTOMER Customer ID Product Line Name PL Prior Years Sales Goal Customer Name Customer Type Customer Zip C

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?

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

Step by Step Solution

3.44 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Questions about Project Data Model in Figure 115 a A Customer places many orders yet an Order is placed by one Customer Each Order is billed on a sing... 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

Document Format (1 attachment)

Word file Icon

613-CS-DB (1561).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!