FIGURE 3-13 Entity clustering for Pine Valley Furniture Company (a) Possible entity clusters (using Microsoft Visio) CUSTOMER CUSTOMER SELLING UNIT SALESPERSON Customer Type National? Regular? Submits...


Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each finish by each salesperson.


FIGURE 3-13 Entity clustering for Pine Valley Furniture Company<br>(a) Possible entity clusters (using Microsoft Visio)<br>CUSTOMER<br>CUSTOMER<br>SELLING UNIT<br>SALESPERSON<br>Customer Type<br>National?<br>Regular?<br>Submits<br>Customer Type<br>Serves<br>SALES TERRITORY<br>DOES BUSINESS IN<br>REGULAR CUSTOMER<br>NATIONAL CUSTOMER<br>Account Manager<br>PRODUCT LINE<br>ORDER<br>ITEM<br>SALE<br>Includes<br>VENDOR<br>HITEM<br>PRODUCT<br>ORDER LINE<br>SUPPLIER<br>USES<br>PRODUCED IN<br>Contract Number<br>MATERIAL SUPPLIES<br>RAW MATERIAL.<br>WORK CENTER<br>EMPLOYEE<br>WORKS IN<br>SKILL<br>HAS SKILL<br>Employee Type<br>d) Employee Type<br>

Extracted text: FIGURE 3-13 Entity clustering for Pine Valley Furniture Company (a) Possible entity clusters (using Microsoft Visio) CUSTOMER CUSTOMER SELLING UNIT SALESPERSON Customer Type National? Regular? Submits Customer Type Serves SALES TERRITORY DOES BUSINESS IN REGULAR CUSTOMER NATIONAL CUSTOMER Account Manager PRODUCT LINE ORDER ITEM SALE Includes VENDOR HITEM PRODUCT ORDER LINE SUPPLIER USES PRODUCED IN Contract Number MATERIAL SUPPLIES RAW MATERIAL. WORK CENTER EMPLOYEE WORKS IN SKILL HAS SKILL Employee Type d) Employee Type "M" "U" UNION EMPLOYEE MANAGEMENT EMPLOYEE MANUFACTURING Supervises

Jun 08, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here