The production manager at PVFC is concerned about support for purchased parts in products owned by customers. A simple analysis he wants done is to determine for each customer how many vendors are in the same state as that customer. Develop a list of all the PVFC customers by name with the number of vendors in the same state as that customer. (Label this computed result NumVendors.) FIGURE 3-13 Entity clustering for Pine Valley Furniture Company(a) Possible entity clusters (using Microsoft Visio)CUSTOMERCUSTOMERSELLING UNITSALESPERSONCustomer TypeNational?Regular?SubmitsCustomer TypeServesSALES TERRITORYDOES BUSINESS INREGULAR CUSTOMERNATIONAL CUSTOMERAccount ManagerPRODUCT LINEORDERITEMSALEIncludesVENDORHITEMPRODUCTORDER LINESUPPLIERUSESPRODUCED INContract NumberMATERIAL SUPPLIESRAW MATERIAL.WORK CENTEREMPLOYEEWORKS INSKILLHAS SKILLEmployee Typed) Employee Type"M""U"UNION EMPLOYEEMANAGEMENT EMPLOYEEMANUFACTURINGSupervises

In this answer the SQL code is provided.

Answered: FIGURE 3-13 Entity clustering for Pine…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

The production manager at PVFC is concerned about support for purchased parts in products owned by customers. A simple analysis he wants done is to determine for each customer how many vendors are in the same state as that customer. Develop a list of all the PVFC customers by name with the number of vendors in the same state as that customer. (Label this computed result NumVendors.)

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions