Because Visio does not explicitly show associative entities, it is not clear in Figure 2-21 which entity
Question:
Because Visio does not explicitly show associative entities, it is not clear in Figure 2-21 which entity types are associative. List the associative entities in this figure. Why are there so many associative entities in Figure 2-21?
Transcribed Image Text:
SALESPERSON DOES BUSINESS IN PK Salesperson ID TERRITORY Serves PK Territory ID Salesperson Name Salesperson Telephone Salesperson Fax Territory Name CUSTOMER PRODUCT LINE PK Product Line ID PK Customer ID Customer Name Product Line Name Customer Address Customer Postal Code Submits ORDER Includes PK Order ID Order Date PRODUCT ORDER LINE PK Product ID Product Description Ordered Quantity Product Finish Product Standard Price VENDOR PRODUCED IN USES PK Vendor ID Vendor Name Goes Into Quantity Vendor Address RAW MATERIAL WORK CENTER SUPPLIES PK Material ID PK Work Center ID Material Name Material Standard Cost Work Center Location Supply Unit Price Unit Of Measure Is Supervised By EMPLOYEE WORKS IN Supervises O PK Employee ID HAS SKILL SKILL He Employee Address Employee Name PK Skill
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 55% (18 reviews)
DOES BUSINESS IN between TERRITORY and CUSTOMER Although this entity has no attributes and no indepe...View the full answer
Answered By
ANNAMAYYGARI SIVA KUMAR
Worked as Network Managed Expert in Chegg for the subject of Earth Science
To solve the questions online in the subject of Earth Science with a good technical approach
0.00
0 Reviews
10+ Question Solved
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science questions
-
Why are there so many different types of international organizations in the financial institutions sector?
-
Why are there so many laws relating to HRM practices? Which are the most important laws, in your opinion?
-
Why are there so many conceptual classifications of information systems? Why are they typically integrated in the information systems found in the real world?
-
A common stock pays an annual dividend that increases by 4% annually and sells for $35 per share. If the market rate of return on this stock is 8%. What is the amount of the ?last dividend paid $1.53...
-
Only 20% of students in a college ever go to their professor during office hours. Of those who go, 30% seek minor clarification and 70% seek major clarification. a. What is the probability that a...
-
Let X Unif(a, b). Find a general expression for the kth moment E[X k ].
-
What conditions must an entity meet before recognizing revenue for financial statement reporting purposes?
-
Capital Experts, Ltd., (CEL) specializes in taking underperforming companies to a higher level of performance. CELs capital structure at December 31, 2011, included 14,000 shares of $2.25 preferred...
-
Due to shortages in the United States milk supply, Congress passed a law governing the production and sale of milk. The law required "anyone who produced, distributed, or sold milk" to obtain a...
-
The Westerbeck Company manufactures several models of automatic washers and dryers. The projected requirements over the next year for their washers follow. Current inventory is 100 units. Current...
-
Examine the hierarchy for the university EER diagram (Figure 3-10). As a student, you are an instance of one of the subtypes: either UNDERGRAD STUDENT or GRADUATE STUDENT. List the names of all the...
-
How would Problems and Exercises 21 and 22 change if a type of fish could be supplied by multiple suppliers?
-
Refer to Assignment Problem 25. a. Illustrate the (transformed) data in a graph. Add means and error bars showing standard errors of means. b. The table at the bottom of the page shows partial...
-
Encore Ltd. declared an 80,000 cash dividend. It currently has 3,000 shares of 7%, 100 par value cumulative preference shares outstanding. It is one year in arrears on its preference shares. How much...
-
Which of the following statements about small share dividends is true? a. A debit to Retained Earnings should be made for the par value of the shares issued. b. A small share dividend decreases total...
-
Since a statement of changes in equity is required, it is not necessary to prepare a(n): a. retained earnings statement. b. statement of financial position. c. income statement. d. statement of cash...
-
Which of the following statements about a 3-for-1 share split is true? a. It will triple the market price of the share. b. It will triple the amount of total equity. c. It will have no effect on...
-
The return on ordinary shareholders equity is defined as: a. net income divided by total assets. b. cash dividends divided by average ordinary shareholders equity. c. income available to ordinary...
-
An article in Biotechnology Progress (December 2002, Vol. 18(6), pp. 11701175) presented a 2 73 fractional factorial to evaluate factors promoting astaxanthin production. The data are shown in the...
-
Federated Shipping, a competing overnight delivery service, informs the customer in Problem 65 that they would ship the 5-pound package for $29.95 and the 20-pound package for $59.20. (A) If...
-
Suppose that each row of an nn array A consists of 1s and 0s such that, in any row of A, all the 1s come before any 0s in that row. Assuming A is already in memory, describe a method running in...
-
Given a database D of n cost-performance pairs (c, p), describe an algorithm for finding the maxima pairs of C in O(nlogn) time.
-
Suppose we are given two sorted search tables S and T, each with n entries (with S and T being implemented with arrays). Describe an O(log 2 n)-time algorithm for finding the k th smallest key in the...
-
Complete the Price, Advertising, and Profitability chart. a . ?Notice that the series for $ 2 5 , 0 0 0 , 0 0 0 ?is already on the chart. b . ?Add the series for advertising budgets $ 5 0 , 0 0 0 , 0...
-
Solve for the missing information designated by "?" in the following table. (Use 365 days in a year. Round the inventory turnover ratio to one decimal place before computing days to sell. Round days...
-
Grove Media plans to acquire production equipment for $800,000 that will be depreciated for tax purposes as follows: year 1, $320,000; year 2, $180,000; and in each of years 3 through 5, $100,000 per...
Study smarter with the SolutionInn App