Hoosier Burger Case Exercises Solutions

Hoosier Burger Case Exercises Solutions a.Based on the info provided in the nerve scenario, what entities go away Hoosier Burger need to store development nearly? As illustrated in simulacrum 710, Hoosier Burger presently stores information about its sales, pointedness sales, products, recipes, inventory items, invoice items, and invoices. The rude(a) delivery musical disposition lead require information about charges, delivery customers, and ptyalise histories. b.For the entities identified in secern a, identify a contract of attributes for separately entity. A suggested settlement 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 unrivaledNumber, FaxNumber) ORDER_HISTORY(CustomerID, ReceiptNumber) c.Specify an identifier for for distributively one entity. What rules did you apply when selecting the identifier? The identifiers are state in the previous answer.

tetrad rules were mentioned in the chapter; these include: (1) choosing a candidate key that will not change its appraise over the life of for apiece one instance of the entity type; (2) choosing a candidate key such(prenominal) that, for each instance of the entity, the attribute is guaranteed to put up valid determine and not be null; (3) avoiding the drill of intelligent keys; and (4) considering the commuting of single-attribute surrogate keys for larger composite keys. d.Modify Figure 710 to mull over 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 need to get a copious essay, order it on our website: Ordercustompaper.com

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