Briefly describe how you would generate alternate design strategies for your proposed system. Additionally, include some specific
Fantastic news! We've Found the answer you've been seeking!
Question:
Briefly describe how you would generate alternate design strategies for your proposed system. Additionally, include some specific examples. see in the text: Section 7.7 Selecting the Best Alternative Design Strategy and Section 7.8 Generating Alternative Design Strategies.
7.7 example and 7.8
Transcribed Image Text:
Now, suppose that we also need to know which price quote is in effect for each part shipment received. This additional data requirement necessitates that the relationship between VENDOR and PART be transformed into an associative entity. This new relationship is represented in Figure 7-8B. FIGURE 7-7 Example of an associative entity. EMPLOYEE Employee_ID Employee_Name (...) Birth_Date A CERTIFICATE Certificate Number Date Completed B COURSE Course_ID + Course_Title {Topic) In this case, PRICE QUOTE is not a ternary relationship. Rather, PRICE QUOTE is a binary many-to-many relationship (associative entity) between VENDOR and PART. In addition, each PART RECEIPT, based on Amount, has an applicable, negotiated Price. Each PART RECEIPT is for a given PART from a specific VENDOR, and the Amount of the receipt dictates the purchase price in effect by matching with the Quantity attribute. Because the PRICE QUOTE pertains to a given PART and given VENDOR, PART RECEIPT does not need direct relationships with these entities. FIGURE 7-8 (A) Many-to-many relationship with attributes. (B) Associative entity with separate relationship. A B VENDOR VENDOR ++ Quantity Price PART PRICE QUOTE Quantity Price PART RECEIPT Order_Number Date Amount PART Now, suppose that we also need to know which price quote is in effect for each part shipment received. This additional data requirement necessitates that the relationship between VENDOR and PART be transformed into an associative entity. This new relationship is represented in Figure 7-8B. FIGURE 7-7 Example of an associative entity. EMPLOYEE Employee_ID Employee_Name (...) Birth_Date A CERTIFICATE Certificate Number Date Completed B COURSE Course_ID + Course_Title {Topic) In this case, PRICE QUOTE is not a ternary relationship. Rather, PRICE QUOTE is a binary many-to-many relationship (associative entity) between VENDOR and PART. In addition, each PART RECEIPT, based on Amount, has an applicable, negotiated Price. Each PART RECEIPT is for a given PART from a specific VENDOR, and the Amount of the receipt dictates the purchase price in effect by matching with the Quantity attribute. Because the PRICE QUOTE pertains to a given PART and given VENDOR, PART RECEIPT does not need direct relationships with these entities. FIGURE 7-8 (A) Many-to-many relationship with attributes. (B) Associative entity with separate relationship. A B VENDOR VENDOR ++ Quantity Price PART PRICE QUOTE Quantity Price PART RECEIPT Order_Number Date Amount PART
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
The greater the uncertainty about an asset s future benefits: the lower the discount rate investors will apply when discounting those benefits to the present the higher the discount rate investors...
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
llustrate different ways of connecting these components together to span a range of performance requirements. [10 marks] For each of the performance categories that you identify state today's typical...
-
Nancy takes out a 29-year loan of $650,000 today. The bank charges interest at 3.6% p.a. compounded monthly. Nancy makes equal month-end payments starting in one month's time. Calculate how much...
-
Mendez Metal Specialties, Inc., has a seasonal pattern to its business. It borrows under a line of credit from Central Bank at 1 percent over prime. Its total asset requirements now (at year end) and...
-
For its on-chip cache, the Intel 80486 uses a replacement algorithm referred to as pseudo least recently used. Associated with each of the 128 sets of four lines (labeled L0, L1, L2, L3) are three...
-
The unsystematic risk of a security is also called its a. b. c. d. perceived risk unique or asset-specific risk market risk fundamental risk
-
Lightning Industries specializes in making Flash, a high-moisture, low-alkaline wax used to protect and preserve skis. The company began producing a new, improved brand of Flash on January 1....
-
You need to keep sales, purchase invoices and other related GST/HST records for how many years from the end of the year to which they relate?
-
What is Fringe Benefits Tax year? A. None of the answers are correct B. From 1 Jan this year to 31 Dec this year C. From 1 Apr this year to 31 Mar next year D. From 1 July this year to 30 June next...
-
The adjusted trial balance shows a. Amounts that may be out of balance b. Revenues and expenses only c. Amounts ready for the financial statements d. Assets, liabilities, and owner's equity only
-
Assume you prepay Body Studio for a package of six physical training sessions. Which type of account should you have in your records? a. Prepaid expense b. Accrued expense c. Accrued revenue d....
-
Unearned revenue is always a (an) a. Asset b. Revenue c. Liability d. Owner's equity because you collected the cash in advance
-
For a test about the population mean, the power of a test depends on a specified value that satisfies the alternate hypothesis. In Exercises 68, determine whether the statement is true or false. If...
-
The power is the probability of making a Type I error. In Exercises 68, determine whether the statement is true or false. If the statement is false, rewrite it as a true statement.
-
Assuming Firm J has inventory of $68,640 and the cost of goods sold is $224,860, what is Firm J's DSI
-
An environmentalist wants to determine if the median amount of potassium (mg/L) in rainwater in Lincoln County, Nebraska, is different from that in the rainwater in Clarendon County, South Carolina....
-
What will be the value of AHS' TIE during 2007? a. 2.75 b. 2.85 c. 2.95 d. 3.05 AHS INC. 2007 Income Statement (S in millions) Net sales S 9625 Cost of goods sold 5225 Depreciation 1890 Earnings...
-
What will be the appropriate value of AHS' inventory turnover ratio in 2007? a. 4.56 b. 4.78 c. 5.32 d. 5.90 AHS INC. 2007 Income Statement (S in millions) Net sales S 9625 Cost of goods sold 5225...
-
If a firm had a D/A ratio of 0.4, which of the following values would be equal to its D/E ratio? a. 4/10 b. 2/3 c. 0.4/1.4 d. 10/4
Study smarter with the SolutionInn App