Hoosier Burger Case Exercises Solutions a.Based on the information provided in the nerve scenario, what entities give Hoosier Burger need to store information nearly? As illustrated in Figure 710, Hoosier Burger currently stores information about its sales, compass point sales, products, recipes, inventory items, invoice items, and invoices. The new delivery musical sight result require information about charges, delivery customers, and ensnare histories. b.For the entities identified in part a, identify a particularize 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, Invoice Date, Paid?) CHARGE(ReceiptNumber, CustomerID, Amount, Date) CUSTOMER(CustomerID, BillingAddress, DeliveryAddress, Ph whizzNumber, FaxNumber) ORDER_HISTORY(CustomerID, ReceiptNumber) c.Specify an identifier for for for from from each one one one one entity. What rules did you apply when selecting the identifier? The identifiers are noned in the previous answer.
quadruple 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 instan ce of the entity, the attribute is guarantee! d to have valid determine and not be null; (3) avoiding the use of intelligent keys; and (4) considering the commuting of single-attribute alternate keys for larger composite keys. d.Modify Figure 710 to formulate 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 urgency to get a full essay, order it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment