Create demo SQL database for online restaurant using Oracle SQL and APEX. Also prepare ERD+relational schema
Budget: $10 – $30 USD
Design a database for online restaurant service, that serves dishes in six different ways: smoked, jellied, grilled, fried, baked and as eel sushi. They also sell beer and sake. Provides only delivery service; it does not have any tables or chairs. Orders are placed over the Web, and the food and drinks are delivered. You are to provide a method for a patron to enter an order for any of the six types of dishes and beer and sake. Management is to be able to produce reports of total sales and number of each item ordered by the week and month.
A Web application takes customer orders and collects payments. The management application assigns delivery people to make deliveries of orders that have arrived. It also tracks and reports inventory, sales by category and revenue. It pays employees.
A Web application takes customer orders and collects payments. The management application assigns delivery people to make deliveries of orders that have arrived. It also tracks and reports inventory, sales by category and revenue. It pays employees.