Welcome

Anti Essays offers essay examples to help students with their essay writing.

Sign Up

Hoosier Burger Case Exercises Solutions Essay

Open Document

Below is an essay on "Hoosier Burger Case Exercises Solutions" from Anti Essays, your source for research papers, essays, and term paper examples.

Hoosier Burger Case Exercises Solutions

a. Based on the information provided in the case scenario, what entities will Hoosier Burger need to store information about?
As illustrated in Figure 7–10, Hoosier Burger currently stores information about its sales, item sales, products, recipes, inventory items, invoice items, and invoices.   The new delivery system will require information about charges, delivery customers, and order histories.

b. For the entities identified in part a, identify a set of attributes for each 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 each entity.   What rules did you apply when selecting the identifier?
The identifiers are noted in the previous answer.   Four 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 that, for each instance of the entity, the attribute is guaranteed to have valid values and not be null; (3) avoiding the use of intelligent keys; and (4) considering the substitution of single-attribute surrogate keys for larger composite keys.

d. Modify Figure 7–10 to reflect the addition of these new entities.   Be sure to specify the cardinalities for each relationship.
A suggested answer is provided below.   Microsoft Visio was used to prepare the E-R diagram.

Show More


Citations

MLA Citation

"Hoosier Burger Case Exercises Solutions". Anti Essays. 13 Dec. 2018

<http://parimatch-stavka7.com/free-essays/Hoosier-Burger-Case-Exercises-Solutions-309895.html>

APA Citation

Hoosier Burger Case Exercises Solutions. Anti Essays. Retrieved December 13, 2018, from the World Wide Web: http://parimatch-stavka7.com/free-essays/Hoosier-Burger-Case-Exercises-Solutions-309895.html


FiiO M9 High Res Lossless (DSD/FLAC/WAV/MP3) Digital Audio Player DAC - Black | £0 Shipping | Good Girls Revolt