Hoosier Burger Case Exercises Solutions

Hoosier Burger Case Exercises Solutions a.Based on the education provided in the nerve scenario, what entities support Hoosier Burger need to store learning nearly? As illustrated in meet 710, Hoosier Burger shortly stores learning about its sales, wearicular sales, products, recipes, inventory items, invoice items, and invoices. The new-fangled delivery musical exhibition will require information about charges, delivery customers, and sanctify histories. b.For the entities identified in part a, identify a particularize of attributes for separately entity. A suggested serve well 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, Ph peerlessNumber, FaxNumber) ORDER_HISTORY(CustomerID, ReceiptNumber) c.Specify an identifier for for severally one entity. What rules did you apply when selecting the identifier? The identifiers are famed in the previous answer.

quartette rules were mentioned in the chapter; these include: (1) choosing a candidate key that will not change its order over the life of individually instance of the entity type; (2) choosing a candidate key such(prenominal) that, for distributively instance of the entity, the attribute is guaranteed to agree valid determine and not be null; (3) avoiding the riding habit of intelligent keys; and (4) considering the commuting of single-attribute foster keys for larger composite keys. d.Modify Figure 710 to excogitate the addition of these new entities. Be sealed to specify the cardinalities for each relationship. A suggested answer is provided below. Microsoft Visio was employ to make grow the E-R diagram.If you compliments to get a fully essay, order it on our website: Ordercustompaper.com

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