the content mini case is about movie gallery in busisines analytical
Mini Case Study - A DelimaFull description
Stock Valation
Audit Class Mini Case
contoh makalah ERDFull description
contoh makalah ERD
Deskripsi lengkap
...Full description
Enterprise Information Systems
Entity Relationship Diagram Dept. of Industrial Engineering
Burger Franchise Project and Research
Problem
Given the following narrative description of entities and their relationship, prepare a draf draftt enti entity ty rela relati tion onsh ship ip diag diagra ram m (ERD) ERD).. Be sure sure to stat state e any any reas reason onab able le assumptions that you are making. Burger World Distribution Center serves as a supplier to 45 Burger World franchises. You are involved with a project to build a database system for distribution. Each franchise submits a day-by-day projection of sales for each of Burger World’s menu produc products ts (the (the produc products ts liste listed d on the menu menu at each each restau restauran rant) t) for the the coming coming month. All menu products require ingredients and/or packaging items. Based on projected sales for the store, the system must generate a day-by-day ingredients need and then collapse those needs into one-per-week purchase requisitions and shipments.
Entity Relationship Diagram
|1
Answer
ORDERED MENU ID Ordered Menu(PK) ID Franchise(FK) Jumlah Ordered Menu
Membutuhkan
Terdiri dari MENU ID Menu(PK) ID Ordered Menu(FK) Nama Menu JenisMenu Harga Menu Unit Pengukuran Ingredients
Terdiri dari INGREDIENTS
USED INGREDIENTS ID UsedIngredients(PK) ID Ingredients(FK) ID Menu(FK) Jumlah Used Ingredients
Terdiri dari
ID Ingredients(PK) NamaIngredients JenisIngredients Unit Pengukuran Ingredients Jumlah Ingredients
Terdiri dari
DAILY ORDER QTY ID Daily Order Qty(PK) ID UsedIngredients(FK) ID Ordered PackaghingItems (FK) Tgl. Daily Order Qty Jumlah Order Qty
Terdiri dari
WEEKLY ORDER QTY ID Weekly Order Qty(PK) ID Daily Order Qty(FK) Tgl. Weekly Order Qty Jumlah Weekly Order Qty
Diproyeksikan
Terdiri dari
ID Ordered PackagingItems(PK) ID PackagingItems(FK) ID Franchise(FK) Jumlah Ordered PackagingItems
ID SalesForecast(PK) ID Weekly Order Qty(FK) Nama SalesForecast JenisOrdered Product Jumlah Order
Membutuhkan
ID Franchise(PK) NamaFranchise Alamat Franchise Telp. Franchise E-mail Franchise
Terdiri dari
PACKAGING ITEMS ID PackagingItems(PK) NamaPackagingItems Jumlah PackagingItems HargaPackagingItems
Terdiri dari SALESFORECAST
FRANCHISE
ORDERED PACKAGING ITEMS
Dikirimkansebagai
PURCHASE REQUISITION
Memproyeksikan
ID Purchase Requisition(PK) ID SalesForecast(FK) ID Weekly Order(FK) NamaPurchase Requisition Jumlah Order
Terdiri dari
SHIPMENT ID Shipment(PK) ID Purchase Requisition NamaShipment Jumlah Shipment HargaShipment
SHIPPED PRODUCT Terdiri dari
ID Shipped Product(PK) ID Shipment(FK) ID Franchise(FK) Jumlah Shipped Product
