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
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
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
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
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
Boundless Bagel Bakers, a mail-order baking company, has hired you to develop its database managemen...
Mathematics, 06.05.2020 06:20
Mathematics, 06.05.2020 06:20
English, 06.05.2020 06:20
English, 06.05.2020 06:20
Mathematics, 06.05.2020 06:20
Arts, 06.05.2020 06:20
Physics, 06.05.2020 06:20