subject
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

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 10:50
Choose the statement that is incorrect. a. search activity occurs only in markets where there is a shortage. b. when a price is regulated and there is a shortage, search activity increases. c. the time spent looking for someone with whom to do business is called search activity. d. the opportunity cost of a good is equal to its price plus the value of the search time spent finding the good.
Answers: 3
question
Business, 22.06.2019 11:10
Sam and diane are completing their federal income taxes for the year and have identified the amounts listed here. how much can they rightfully deduct? • agi: $80,000 • medical and dental expenses: $9,000 • state income taxes: $3,500 • mortgage interest: $9,500 • charitable contributions: $1,000.
Answers: 1
question
Business, 22.06.2019 14:50
Pederson company reported the following: manufacturing costs $480,000 units manufactured 8,000 units sold 7,500 units sold for $90 per unit beginning inventory 2,000 units what is the average manufacturing cost per unit? (round the answer to the nearest dollar.)
Answers: 3
question
Business, 22.06.2019 22:20
What type of negotiating strategy requires the supplier to open its books to the purchasers? a. competitive biddingb. cost-based price modelc. price-based modeld. market-based price modele. transparent negotiations
Answers: 1
You know the right answer?
Boundless Bagel Bakers, a mail-order baking company, has hired you to develop its database managemen...
Questions
question
Mathematics, 06.05.2020 06:20
question
Physics, 06.05.2020 06:20
Questions on the website: 13722367