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 15:30

Abenefit of using a debit or credit card instead of cash is that it provides a paper record of a purchase. looking at the purchases below, which one should be made using a credit or a debit card?

Answers: 3

Answer

Business, 22.06.2019 16:20

Stosch company's balance sheet reported assets of $112,000, liabilities of $29,000 and common stock of $26,000 as of december 31, year 1. if retained earnings on the balance sheet as of december 31, year 2, amount to $74,000 and stosch paid a $28,000 dividend during year 2, then the amount of net income for year 2 was which of the following? a)$23,000 b) $35,000 c) $12,000 d)$42,000

Answers: 1

Answer

Business, 22.06.2019 20:20

Fractional reserve banking which of the following statements about fractional reserve banking are correct? check all that apply. fractional reserve banking allows banks to create money through the lending process. fractional reserve banking does not allow banks to hold excess reserves. fractional reserve banking allows banks to create additional wealth by lending some reserves. fractional reserve banking relies on everyone not withdrawing their money at the same time.

Answers: 2

Answer

Business, 22.06.2019 21:30

Which is cheaper: eating out or dining in? the mean cost of a flank steak, broccoli, and rice bought at the grocery store is $13.04 (money.msn website, november 7, 2012). a sample of 100 neighborhood restaurants showed a mean price of $12.75 and a standard deviation of $2 for a comparable restaurant meal. a. develop appropriate hypotheses for a test to determine whether the sample data support the conclusion that the mean cost of a restaurant meal is less than fixing a comparable meal at home. b. using the sample from the 100 restaurants, what is the p-value? c. at a = .05, what is your conclusion? d. repeat the preceding hypothesis test using the critical value approach

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