Hoosier Burger Case Exercises Solutions

Hoosier Burger Case Exercises Solutions

a.Based on the information provided in the nerve scenario, what entities allow Hoosier Burger need to store information nearly?
As illustrated in Figure 710, Hoosier Burger currently stores information about its sales, item sales, products, recipes, inventory items, invoice items, and invoices. The new delivery musical arrangement will require information about charges, delivery customers, and cast histories.

b.For the entities identified in part a, identify a stipulate of attributes for separately entity.
A suggested answer is provided below.

SALE(ReceiptNumber, SaleDate, Delivery)
ITEMSALE(ProductID, ReceiptNumber, QuanitySold)
PRODUCT(ProductID, ProductDescription)
RECIPE(ItemNumber, ProductID, QuantityUsed)
INVENTORYITEM(ItemNumber, ItemDescription, QuantityinStock, TypeofItem, MinimumOrderQuantity)
INVOICE_ITEM(ItemNumber, VendorID, InvoiceNo, QuantityAdded)
INVOICE(VendorID, InvoiceNo, InvoiceDate, Paid?)
CHARGE(ReceiptNumber, CustomerID, Amount, Date)
CUSTOMER(CustomerID, BillingAddress, DeliveryAddress, PhoneNumber, FaxNumber)
ORDER_HISTORY(CustomerID, ReceiptNumber)

c.Specify an identifier for for each one entity. What rules did you apply when selecting the identifier?
The identifiers are noted in the previous answer.



quartet rules were mentioned in the chapter; these include: (1) choosing a candidate key that will not change its value over the life of each instance of the entity type; (2) choosing a candidate key such(prenominal) that, for each instance of the entity, the attribute is guaranteed to have valid determine and not be null; (3) avoiding the use of intelligent keys; and (4) considering the commuting of single-attribute surrogate keys for larger composite keys.

d.Modify Figure 710 to reflect the addition of these new entities. Be sealed to specify the cardinalities for each relationship.
A suggested answer is provided below. Microsoft Visio was used to make grow the E-R diagram.If you want to get a full essay, order it on our website: Orderessay



If you want to get a full essay, wisit our page: write my essay .