Korean BBQ Restaurant Database Description
A list of companies which supply raw ingredients to the Korean BBQ Restaurant. This table contains a unique identification number for the supplier, the name of the company, the category of ingredients supplied, and their phone number.
A list of produce which is used by the Korean BBQ Restaurant. These are the items which were supplied by the suppliers. This table contains a unique identification number for the raw ingredient, the identification number for its supplier, and the name of the raw ingredient.
A list of drinks which is sold at the Korean BBQ Restaurant. This table contains a unique identification number for each drink, the identification number for its supplier, the name of the drink, and the price of the drink.
Copyright By PowCoder代写 加微信 powcoder
A list of chefs who work at the Korean BBQ Restaurant. This table contains a unique identification number for each chef, the name of the chef, their gender, salary, and phone number.
A list of food items which are sold at the Korean BBQ Restaurant. This table contains a unique identification number for each dish, the name of the dish, the preparation time for each dish in minutes, the price of each dish, and any associated allergies.
list of which raw ingredients are used to produce each dish, and the chef who cooks the dish. This table contains the unique identification numbers for chefs, produce, and food.
A list of existing customers who have visited the Korean BBQ Restaurant at least once. This table contains a unique identification number for each customer and their name.
A list of discounts offered by the Korean BBQ Restaurant. This table contains a unique identification number for each discount, the name of the discount, and the percentage of the discount.
Delivery Service
A list of delivery companies who work in partnership with the Korean BBQ Restaurant. This table contains a unique identification number for each delivery company, the name of the delivery company, the type of vehicle used for delivery, and their respective service fee.
A list of orders made at the Korean BBQ Restaurant, including the food and drink items that were ordered, the customer who ordered them, and any relevant discount or delivery service. This table contains the unique identification numbers for customers, food, drinks, discounts, and delivery service, as well as the date on which the order was placed, and whether the customer ate in store or at home.
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com