Using Visio or another modeling tool of your choice, reproduce the diagram from your Modern Database Management
Fantastic news! We've Found the answer you've been seeking!
Question:
Using Visio or another modeling tool of your choice, reproduce the diagram from your Modern Database Management
Transcribed Image Text:
SALESPERSON PK Salesperson ID Salesperson LName Salesperson MI Salesperson FName Salesperson Telephone Salesperson Fax (b) Suggested Visio Solution (Multivalued Attributes) PRODUCT FINISH PK Product Finish PK Product ID Product Standard Price Provided In VENDOR PK Vendor ID SKILL PK Skill Vendor Name Vendor Street Vendor City Vendor State Vendor Zip Supplies Supply Unit Price DO TH HAS SKILL Serves -H-- H TERRITORY PK Territory ID Note: CUSTOMER entity may also have multivalued attributes for Address (e.g., ShipTo, Bill To) PRODUCT LINE PK Product Line ID Product Line Name = A PRODUCT -HPK Product ID USES Territory Name Product Description Goes Into Quantity RAW MATERIAL Includes PK Material ID Is Supervised By Material Name Standard Cost Unit Of Measure -O+ OPK Supervises # HH H EMPLOYEE Employee ID Employee LName Employee MI Employee FName H Employee Street Employee City Employee State Employee Zip DOES BUSINESS IN POH CUSTOMER PK Customer ID Customer Name Customer Street Customer City Customer State Customer Postal Code Submits ORDER PK Order ID PRODUCED IN Order Date Customer ID ORDER LINE Ordered Quantity Product ID WORK CENTER PK Work Center ID Work Center Location WORKS IN SALESPERSON PK Salesperson ID Salesperson LName Salesperson MI Salesperson FName Salesperson Telephone Salesperson Fax (b) Suggested Visio Solution (Multivalued Attributes) PRODUCT FINISH PK Product Finish PK Product ID Product Standard Price Provided In VENDOR PK Vendor ID SKILL PK Skill Vendor Name Vendor Street Vendor City Vendor State Vendor Zip Supplies Supply Unit Price DO TH HAS SKILL Serves -H-- H TERRITORY PK Territory ID Note: CUSTOMER entity may also have multivalued attributes for Address (e.g., ShipTo, Bill To) PRODUCT LINE PK Product Line ID Product Line Name = A PRODUCT -HPK Product ID USES Territory Name Product Description Goes Into Quantity RAW MATERIAL Includes PK Material ID Is Supervised By Material Name Standard Cost Unit Of Measure -O+ OPK Supervises # HH H EMPLOYEE Employee ID Employee LName Employee MI Employee FName H Employee Street Employee City Employee State Employee Zip DOES BUSINESS IN POH CUSTOMER PK Customer ID Customer Name Customer Street Customer City Customer State Customer Postal Code Submits ORDER PK Order ID PRODUCED IN Order Date Customer ID ORDER LINE Ordered Quantity Product ID WORK CENTER PK Work Center ID Work Center Location WORKS IN
Expert Answer:
Answer rating: 100% (QA)
Warehouse warehouse D warehousename warehouse location Manufacturer manufa... View the full answer
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Posted Date:
Students also viewed these programming questions
-
Do some amendment and enhance the given research paper: Table of Content Abstract..3 Action Research.4 Research Methodology and Design...5 Literature Review: NoSQL Database7 Proposal.7 Iteration 1..8...
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
In their 1999 book The Unified Software Development Process , the authors of Unified Modeling Language (UML) noted that any modern object-oriented approach to developing information systems must be...
-
Bike World, Inc., wholesales a line of custom road bikes. Bike World's inventory, as of November 30, 2016, consisted of 22 mountain bikes costing $1,650 each. Bike World's trial balance as of...
-
What are two of the key checks and balances in place to help manage the incremental risks associated with the hedge fund industry?
-
Find the angle (in radians) from the first line to the second (see problem 40). (a) y = 2x, y = 3x (b) y = x/2, y = - x (c) 2x - 6y = 12, 2x + y = 0
-
Why a temporary restraining order or preliminary injunction may be necessary?
-
For each term in the first column select the partial (or complete) definition or illustration. Each partial (or complete) definition or illustration may be used only once. Term a. A report providing...
-
Byrex has developed a new kind of bypass unit. The sales department forecasts demand of 5,000 units in the first year and a decrease in demand of 10 percent a year after that. After five years, the...
-
Explain the process by which a Steinway grand piano is constructed as a subsystem of a larger system. From what the text tells you, give some examples of how the production subsystem is affected by...
-
1. One of the ways rent control is inefficient is that it leads to: A) high opportunity costs associated with wasted time searching for apartments. B) the construction of more apartments. C)...
-
Viceroy Ltd has a December 31 year-end. Its ledger account for Common Shares (Class A voting) showed the following information (dollars amounts are in thousands): Opening Balance Jan1 = 400,000...
-
Budgeted costs of operating the copying facility for 300,000 to 500,000 copies Fixed costs per year Variable costs Budgeted long-run usage in copies per year: Marketing Department Operations...
-
On July 31, 2017 0 1 7 , Amsterdam Company engaged Minsk Tooling Company to construct a special-purpose piece of factory machinery. Construction was begun immediately and was completed on November 3...
-
(a) An investor purchased 300 units of a Mutual Fund at Rs. 12.25 per unit on 31 December, 2009. As on 31st December, 2010 he has received Rs. 1.25 as dividend and Rs. 1.00 as capital gains...
-
The following information relates to Marshall Manufacturing's current accounting period: Raw materials used Direct labor wages Sales salaries and commissions Depreciation on production equipment Rent...
-
Can you extended the connection to a thermocouple with copper wires? No, you must use thermocouple extension wire. Yes, but the connection points must be at the same temperature.
-
Accounting policies and practices that are most important to the portrayal of the companys financial condition and results, and require managements most difficult, subjective, or complex judgments...
-
Care must be exercised when writing triggers for a database. What are some of the problems that could be encountered?
-
Consider the SQL query in Figure 1-19. a. How is Sales to Date calculated? b. How would the query have to change if Helen Jarvis wanted to see the results for all of the product lines, not just the...
-
List all sales territories (TerritoryID) that have more than one salesperson.
-
Determine the reactions at the pin support \(A\) and roller \(B\). 500 lb/ft 30 ft 700 lb/ft 48 ft- 48 ft BA 20 ft B
-
For methanol synthesis reaction \[ \mathrm{CO}(\mathrm{g})+2 \mathrm{H}_{2}(\mathrm{~g}) ightleftharpoons \mathrm{CH}_{3} \mathrm{OH}(\mathrm{g}) \] Using a feed mixture of carbon monoxide and...
-
The L2 steel blade of the band saw wraps around the pulley having a radius of \(12 \mathrm{in}\). Determine the maximum normal stress in the blade. The blade has a width of 0.75 in. and a thickness...
Study smarter with the SolutionInn App