Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity
Question:
Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative. List the associative entities in this figure. Why are there so many associative entities in Figure 2-22?
Transcribed Image Text:
SALESPERSON DOES BUSINESS IN TERRITORY PK Salesperson ID Serves + PK Territory ID Salesporson Name Salesperson Telephone Salesperson Fax Territory Name CUSTOMER PRODUCT LINE PK Customer ID PK Product Line ID Customer Name Customer Address Product Line Name Customer Postal Code Submits Includes ORDER PK Order ID Order Date PRODUCT ORDER LINE PK Product ID Product Description Product Finish Ordered Quantity Product Standard Price VENDOR USES PRODUCED IN PK Vendor ID Vendor Name Goes Into Quantity Vendor Address RAW MATERIAL WORK CENTER PK Material ID SUPPLIES 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 OPK Employee ID HAS SKILL SKILL Employee Name Employee Address PK Skill
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 63% (11 reviews)
Figure 222 associative entities DOES BUSINESS IN between TERRITORY and CUSTOMER Although this entity ...View the full answer
Answered By
RAFIKUL MALLICK
My self rafikul mallick ...i complete my B.Sc in chemistry from jhargram raj college in year 2015.....and i complete my m.sc in chemistry from vidyasagar university in year 2017...and i complete b.ed from rashbihari college of education in year 2019...now in present day i will teach many student in chemistry ...
0.00
0 Reviews
10+ Question Solved
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted:
Students also viewed these Computer Sciences 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?
-
What will be the sum of third proportional to 18 and 54 and fourth proportional to 12, 18 and LCM of 12 and 18? 1. 162 2. 216 3. 612 4. 256 526 5.
-
Briefly describe the composition and general thrust of each of the following indexes. a.NYSE composite index b.Amex composite index c.Nasdaq Stock Market indexes d.Value Line composite index
-
On January 1, 2017, Walker, Inc., signs a 5-year lease for two floors of a 20-floor building. The building has an expected remaining life of 20 years. The space is available immediately, and Walker...
-
Using the Gapminder software (https://www.gapminder .org/tools), set the vertical axis to Age at 1st marriage (women) and the horizontal axis to Babies per woman. This scatterplot shows the mean age...
-
Sommer Graphics Company was organized on January 1, 2014, by Krystal Sommer. At the end of the first 6 months of operations, the trial balance contained the accounts shown below. Analysis reveals the...
-
At the end of June, the job cost sheets at Ace Roofers show the following costs accumulated on three jobs. At June 3 0 Job 5 Job 6 Job 7 Direct materials $ 1 8 , 0 0 0 $ 3 4 , 5 0 0 $ 2 8 , 5 0 0...
-
The chapter argues that collaboration is the main behavioral change that needs to accompany going green. Do you agree? Explain.
-
Are associative entities also weak entities? Why or why not? If yes, is there anything special about their "weakness"?
-
Figure shows a grade report that is mailed to students at the end of each semester. Prepare an ERD reflecting the data contained in the grade report. Assume that each course is taught by one...
-
In a study to estimate the proportion of residents in a certain city and its suburbs who favor the construction of a nuclear power plant, it is found that 63 of 100 urban residents favor the...
-
Galamsey LTD has successfully acquired a license to mine in a 10,000-acre concession at the village of Franciskrom. Under the terms of the license, Galamsay is expected to restore the excavated land...
-
Convertible preferred stock is usually convertible to ________ at the ________ option. common stock; investor's a convertible bond; company's cash; company's a bond; investor's
-
Which concept states that only quantitative information can be recorded in books of accounts? Question 4 options: Separate Entity Concept Money Measurement Concept Accrual Concept Going Concern...
-
financial accounting and tax accounting are totally independent, so firms can simultaneously report high income to their shareholders while reporting low income to the IRS
-
Dr. Everton owns a dermatology practice. Approximately, twenty patients come through the facility a day. If every patient pays cash, what would the medical services be recorded as in double-entry...
-
Show analytically that if marginal cost is less than average cost, then the derivative of average cost with respect to quantity satisfies a(q) < 0.
-
One Way Cellular accountants have assembled the following data for the year ended September 30, 2014: Prepare the operating activities section using the indirect method for One Way Cellulars...
-
Visit some Web sites for open source databases, such as www.postgresql.org and www.mysql.com. What do you see as major differences in administration between open source databases, such as MySQL, and...
-
How can fuzzy logic, pattern matching, and expert systems be used to improve data quality?
-
Explain how an organizations business rules can be checked as part of a data audit.
-
Perpetual inventory using LIFO Beginning inventory, purchases, and sales for Item 88-HX are as follows: July 1 Inventory 106 units @ $28 July 8 Sale 85 units July 15 Purchase 118 units @ $32 July 27...
-
Materials Costing for a Furniture Company Pull Up a Chair Company manufactures furniture. The company uses a job order cost system. Balances on August 1 from the materials ledger are as follows:...
-
You are a defense attorney, and your first big case is a multiple murder. You have come to the realization that your client really did break into a couple's home and torture and kill them in the...
Study smarter with the SolutionInn App