Reproduce the diagram – Crows Foot diagram

You need to use a modeling tool of your choice, reproduce attached diagram in crows foot diagram

I attached

130 Part II . Database Analysis
Chapter 2 . Modeling Data in the Organization 129
FIGURE 2-22 Data model for Pine Valley Furniture Company in Microsoft Visio notation
SALESPERSON
PK Salesperson ID
Serves
DOES BUSINESS IN
Salesperson Name
Salesperson Telephone
Salesperson Fax
TERRITORY
PK Territory ID
Territory Name
PRODUCT LINE
PK Product Line ID
CUSTOMER
PK Customer ID
Product Line Name
Customer Name
Customer Address
Customer Postal Code
Submits
Includes
ORDER
PK Order ID
Order Date
a sales-
PRODUCT
PK Product ID
ORDER LINE
From a study of the business processes at Pine Valley Furniture Company, we
have identified the following entity types. An identifier is also suggested for each entity,
together with selected important attributes:
• The company sells a number of different furniture products. These products are
grouped into several product lines. The identifier for a product is Product ID,
whereas the identifier for a product line is Product Line ID. We identify the fol-
lowing additional attributes for product: Product Description, Product Finish, and
Product
Standard Price. Another attribute for product
line is Product Line Name.
A product line
may group any number of products but must group at least one
. Customers submit orders for products. The i
product. Each product must belong to exactly one product line.
The identifier for an order is Order ID, and
but need not submit any orders. Each order is submitted by exactly one customer.
another attribute is Order Date. A customer may submit any number of orders
The identifier for a customer is Customer ID. Other attributes include Customer
Name, Customer Address, and Customer Postal Code.
A given customer
order must request at least one product and only one product
per order line item. Any product sold by Pine Valley Furniture may not appear on
any order line item or may appear on one or more order line items. An attribute
associated with each order line item is Ordered Quantity.
Pine Valley Furniture has established sales territories for its customers. Each
customer may do business in any number of these sales territories or may not
do business in any territory. A sales territory has one to many customers. The
identifier for a sales territory is Territory ID and an attribute is Territory Name.
Pine Valley Furniture Company has several salespersons. The identifier
person is Salesperson ID. Other attributes
include Salesperson Name, Salesperson
Telephone,
and person Fax. A salesperson serves
exactly one sales territory.
served by one or more salespersons.
product is assembled
from a specified quantity of one or more raw materials.
The identifier for raw material entity is Material ID. Other attributes include
Unit Of Measure, Material Name, and Material
Standard Cost. Each raw mate-
rial is assembled into one or more products, using a specified quantity of the raw
material for each product.
• Raw materials are supplied by vendors. The identifier for a vendor is Vendor ID.
Other attributes include Vendor
Name and Vendor Address. Each raw material
supplied by one
or more vendors. A vendor may supply any number of
raw materials or may not supply any raw materials to Pine Valley Furniture.
Supply Unit Price is the unit price at which a particular vendor supplies a
particular raw material.
• Pine Valley Furniture has established a number of work centers. The identifier for
a work center
at
Work Center ID. Another attribute is Work Center Location. Each
is produced in one or more work centers. A work center may be used to
produce
any number of products or may not be used to produce any products.
Employee ID. Other attributes include Employee Name, Employee Address, and
An employee may have more than one skill. Each employee may work in one
or more work centers. A work center must have at least one employee working in
that center but may have any number of employees. A skill may be possessed by
more than one employee or possibly no employees.
• Each employee has exactly one supervisor; however, a manager has no supervisor.
An employee who is a supervisor may supervise any number of employees, but
not all employees are supervisors.
+
Each sales territory i
Product Description
Product Finish
Product Standard Price
Ordered Quantity
Each
VENDOR
PK Vendor ID
USES
PRODUCED IN
Vendor Name
Vendor Address
Goes Into Quantity
can be
RAW MATERIAL
PK Material ID
SUPPLIES
WORK CENTER
PK Work Center ID
product
Material Name
Material Standard Cost
Unit Of Measure
Work Center Location
Supply Unit Price
Is Supervised By
Skill..
WORKS IN
Supervises
HAS SKILL
SKILL
PK Skill
EMPLOYEE
– PK Employee ID
>O!
Employee Name
Employee Address
Hea
PINE
DATABASE PROCESSING AT PINE VALLEY FURNITURE
VALLEY
The purpose of the data model diagram in Figure 2-22 is to provide a conceptual design
FURNITURE for the Pine Valley Furniture Company database. It is important to check the qual-
ity of such a design through frequent interaction with the persons who will use the