













Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Project on DBMS using oracle 10g. ER diagram, schema, description, entities and all relevant information on online food ordering system.
Typology: Assignments
1 / 21
This page cannot be seen from the preview
Don't miss anything!
ACKNOWLEDGEMENT
Introduction It is known globally that, in today’s market, it is extremely difficult to start a new small-scale business and live-through the competition from the well-established and settled owners. In fast paced time of today, when everyone is squeezed for time, the majority of people are finicky when it comes to placing a food order. The customers of today are not only attracted because placing an order online is very convenient but also because they have visibility into the items offered, price and extremely simplified navigation for the order. Online ordering system that I am proposing here, greatly simplifies the ordering process for both the customer and the restaurant. System presents an interactive and up-to-date menu with all available options in an easy to use manner. Customer can choose one or more items to place an order which will land in the Cart. Customer can view all the order details in the cart before checking out. At the end, customer gets order confirmation details. Once the order is placed it is entered in the database and retrieved in pretty much real time. This allows Restaurant Employees to quickly go through the orders as they are received and process all orders efficiently and effectively with minimal delays and confusion.
Motivation
User: Reason :
Order:
Payment: Obviously when users will give order they will submit payment. Reason:
ER DIAGRAM:
User:
Order: Datatype And Size:
Payment:
DDL & DML..statement create table User ( User_Id varchar (20) not null, email varchar (30) not null, name varchar (45) not null, password varchar (45) not null, address varchar (45) not null, primary key ( User_Id) );
Tables