Assignment #2 -- Happy Burgers ERD/Table
Ryan Fobart // TR 2:00 - 3:20
| SALE | |
| Reciept_No | Sale_Date |
| 6532 | Jan-03-00 |
| 8456 | Mar-26-00 |
| ITEM_SALE | ||
| Reciept_No (FK) | Product_No (FK) | Quantity_Sold |
| 6532 | 254-14 | 100 |
| 8465 | 956-86 | 10 |
| PRODUCT | |
| Product_No | Priduct_Description |
| 254-14 | Hamburger Bun - Pack of 10 |
| 956-86 | Ketchup Packets - Box of 250 |
| INVOICE | |||
| Invoice_No | Vendor_ID (FK) | Invoice_Date | Paid_Status |
| 32458 | 852 | Feb-23-00 | Paid |
| 94167 | 253 | Apr-09-00 | Billed |
| INVOICE_ITEM | |||
| Invoice_No (FK) | Item_No (FK) | Vendor_ID (FK) | Quantity_Added |
| 32458 | 45678 | 852 | 100 |
| 94167 | 64268 | 253 | 10 |
| INVENTORY_ITEM | ||||
| Item_No | Item_Desc | Quantity_in_Stock | Item_Type | Min_Order_Quantity |
| 45678 | Hamburger Buns | 650 | Food - Perishable | 20 |
| 64268 | Ketchup Packets | 87 | Food - Non-perishable | 5 |
| VENDOR | |||||
| Vendor_ID | Vendor_Name | Vendor_Street | Vendor_City | Vendor_State | Vendor_Zip |
| 852 | Bread Unlimited | 1616 Wheat Way | Heartland | MO | 78548 |
| 253 | Tamato Paste International | 8645 Red River Road | Freidgreen | AR | 24658 |
| PRODUCT_INVENTORY_ITEM | ||
| Product_No (FK) | Item_No (FK) | Quantity_Ordered |
| 254-14 | 45678 | 100 |
| 956-86 | 64268 | 10 |