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
-
A company has three appliance stores that sell washers, dryers, and ranges. Matrices W and R give the wholesale and retail prices of these items, respectively. Matrices N and D give the quantities of...
-
The following financial statements were prepared for the management of Satay Ltd. The statements contain some information that will be disclosed in note form in the general purpose financial...
-
1. Describe the market segment toward which the ReadyMade magazine is primarily targeted. 2. What key attributes of ReadyMade magazine appeal to this market segment? 3. How is the target market of...
-
A company manufactures a single product. Budget and standard cost details for next year include: Selling price per unit RM100.00 Variable production cost per unit RM44.50 Fixed production costs...
-
Change Purse Inc. is a small business that is planned to be located in a small Nova Scotia town. The town was incorporated in 1889 and, like many communities in Nova Scotia, it prides itself on being...
-
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...
-
Write a recursive method called sumover that has one argument n, which is a nonnegative integer. The method returns a double value, which is the sum of the reciprocals of the first n positive...
-
Randomly create a set of 20 data points (N=20) such that for each point x=(x_1.x_2), the coordinates x_1.x_2 be integers. x_1.x_2 are to be limited to the [-30,+30] range and uncorrelated. Choose the...
-
What will $15,000 deposited today at 7.50 percent compounded annually for nineteen years be valued at?
-
You are a hedge fund manager and need to create a portfolio that will hopefully outperform the stock market. The expected return and risk of your potential choices are: Asset S&P 500 Real Estate Fund...
-
Lorah, a district manager for a commercial food distributor, is in charge of implementing the company's plan to reduce cost of goods sold by 12%. Lorah is reviewing quarterly expense reports to...
-
The bonds of Westover International have a face value of $1,000, mature in 16.5 years, and pay 7.25% interest semiannually. These bonds currently sell for $1,003.50. What is the pre-tax cost of debt?
-
a. Show that the curvature of a smooth curve r(t) = (t)i + g(t)j defined by twice-differentiable functions x = (t) and y = g(t) is given by the formula The dots in the formula denote differentiation...
-
The May 2014 revenue and cost information for Houston Outfitters, Inc. follow: Sales Revenue (at standard).............. $ 540,000 Cost of Goods Sold (at standard) ..........341,000 Direct Materials...
-
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.
-
Jamie Lee is attracted to the low monthly payment advertised for a vehicle lease. She may well be able to afford a more expensive car than she originally thought. Jamie Lee really needs to think this...
-
Explain virtual hosting and how to use either name-based or IP-based virtual hosting.?
-
Discuss the role of literary allusion in satire as a means of subverting conventions and critiquing societal norms.
Study smarter with the SolutionInn App