Business, 04.07.2020 02:01 miko96

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

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 14:50

For fundamental-type variables, list-initialization syntax prevents narrowing conversions that could result in data loss. for fundamental-type variables, list-initialization syntax allows narrowing conversions that could result in data loss.

Answers: 2

Answer

Business, 21.06.2019 19:30

Clonex labs, inc., uses the weighted-average method in its process costing system. the following data are available for one department for october: percent completed units materials conversion work in process, october 1 53,000 90 % 65 % work in process, october 31 29,000 74 % 52 % the department started 381,000 units into production during the month and transferred 405,000 completed units to the next department. required: compute the equivalent units of production for october.

Answers: 2

Answer

Business, 22.06.2019 00:40

Select the statement that indicates tina's company is a partnership. tina jones is a dancer specializing in latin dance styles. she always wanted to have her own dance studio where she could teach dancing to young and old alike. in 2006, she opened her first dance studio, electric diva, in madison triangle. it was a great choice as a business location because it's well-connected by highways to most places in the city. she leased the space for three years. her initial investment included a good sound system, cheerful interior design, and strong flooring. to raise capital for the business, tina turned to her brother-in-law, philip. philip made half the financial investment. he manages the accounts and social media needs of the business. he has a 30% share in trisha's business. together, they expanded the business to three dance studios in the city and plan to open franchises in other cities.

Answers: 1

Answer

Business, 22.06.2019 05:30

Financial information that is capable of making a difference in a decision is

Answers: 3

Answer

You know the right answer?

Boundless Bagel Bakers, a mail-order baking company, has hired you to develop its database managemen...

Questions