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

The uno company was formed on january 2, year 1, to sell a single product. over a 2-year period, uno’s acquisition costs have increased steadily. physical quantities held in inventory were equal to 3 months’ sales at december 31, year 1, and zero at december 31, year 2. assuming the periodic inventory system, the inventory cost method which reports the highest amount for each of the following is inventory december 31, year 1/ cost of sales year 2 a: lifo fifo b: lifo lifo c: fifo fifo d: fifo lifo

Answers: 3

Answer

Business, 22.06.2019 07:30

Which of the following is an example of an unsought good? a. cameron purchases a new bike. b. jordan buys paper towels. c. taylor buys cupcakes from her favorite bakery. d. riley buys new windshield wipers for her car.

Answers: 3

Answer

Business, 22.06.2019 18:50

Retirement investment advisors, inc., has just offered you an annual interest rate of 4.4 percent until you retire in 40 years. you believe that interest rates will increase over the next year and you would be offered 5 percent per year one year from today. if you plan to deposit $13,000 into the account either this year or next year, how much more will you have when you retire if you wait one year to make your deposit?

Answers: 3

Answer

Business, 22.06.2019 19:00

Which of the following is likely not a benefit of requiring a grand jury to listen to and examine all of the evidence against a person suspected of committing a serious crime and then independently deciding whether or not to hand down an indictment? 1.the grand jury system provides the accused another safeguard against being sent to trial and facing conviction based on flawed evidence. 2.the members of the grand jury are drawn from the community and are empowered to render independent decisions about whether or not the government has collected enough evidence to bring an individual to trial. 3.the grand jury’s decision can provide prosecutors insight into what is necessary to build a sufficient case if a similar crime is presented later. 4.the grand jury is impaneled to rubber-stamp prosecutors’ cases, which makes it possible for more cases to reach trial.

Answers: 2

Answer

You know the right answer?

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

Questions