Boundless Bagel Bakers, a mail-order baking company, has hired you to develop its database management system. After several meetings with the management of BBB, you have come up with the following set of entities and attributes: CUSTOMER :

CustomerNumber
LastName
FirstName
Address
Street
City
State
ZipCode
HomeTelephone
OfficeTelephone
ACCOUNT
AccountNumber
CreditLimit
CurrentBalance
SALESPERSON
SalesPersonID
LastName
FirstName
CommissionRate
DateOfHire
DateOfBirth
BAKERY
BakeryID
Location
City
State
ProductsBaked
PRODUCT
ProductCode
ProductDescription
Price
INGREDIENT
IngredientID
Description
SupplierID
StandardMeasure
SUPPLIER

SupplierID

Address

Street

City

State

ZipCode

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

a. A bakery can bake one or more products but must bake at least one product.
b. A product consists of one or more ingredients that are used in a certain quantity.
c. A customer can have one or more accounts. An account is for one customer only.
d. Ingredients are supplied by one or more suppliers. A supplier may supply one or more ingredients or may supply no ingredients at all.
e. Customers order products from one bakery and the order is placed using a salesperson. f. The customer’s order is charged to his or her account. g. A salesperson works for only one bakery and a bakery employees many salespeople.
h. Each bakery bakes only certain products. Some bakeries may bake all products.

Required:
1. Using the entities and attributes defined above as well as the business rules, create an ERD.
2. Create a set of relations from the ERD