Database Design

Homework Set $1\mathrm{.}2$

Paul$$s Popcorn Poppers, a mail$-$order company, has hired you to develop its database

management system. After several meetings with the management of PPP$,$ you have come up

with the following set of entities and attributes:

CUSTOMER

CustomerNumber

LastName FirstName

PrimaryAddress

Street

City State

ZipCode

HomeTelephone

OfficeTelephone

SecondaryAddress

Street

City State

ZipCode

DatesOfResidency

SAPhone

ACCOUNT

AccountNumber

CreditLimit

CurrentBalance

PaymentHistory

SALESPERSON

SalesPersonID

LastName FirstName

CommissionRate

DateOfHire

DateOfBirth

PLANT

PlantID

Location

City State

PRODUCT

ProductCode

ProductDescription

Price

CORN

CornID

Description

SupplierID

QualityRating

Yield

SUPPLIER

SupplierID

Address

Street

City

State

ZipCode

ContactName

In addition to the above set of entities and attributes, you have determined the following set of

business rules:

a$.$ A product consists of one or only one type of corn used in a certain quantity to produce a

batch.

b$.$ A customer can have one and only one account. An account is for one customer only.

c$.$ Corn is supplied by one or more suppliers. A supplier may supply only one type of corn.

d$.$ Customers order products from one plant and the order is placed using a salesperson.

e$.$ The customer$$s order is charged to his or her account.

f$.$ A salesperson can sell popcorn through many plants.

Using the entities and attributes defined above as well as the business rules, create an ERD.

Please be sure to state any assumptions that you make.

You can either submit an ERD or share your LucidChart drawing with me$.$ If you do share it

with me$,$ make sure that I can comment on it$.$