Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using Visio or another modeling tool of your choice, reproduce the diagram from your Modern Database Management SALESPERSON PK Salesperson ID Salesperson LName Salesperson MI


  • Using Visio or another modeling tool of your choice, reproduce the diagram from your Modern Database Management

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

Step by Step Solution

3.46 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

Warehouse warehouse D warehousename warehouse location Manufacturer manufa... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Programming questions