/DBMS-Project

6th Semester Database Management Systems project

Primary LanguageSwift

DBMS-Project

Problem Statement

The McDonald’s Online Ordering System is a database system designed to facilitate the process of online food ordering. The system will provide a set of features to access unique menu items available in different branches of the aforementioned fast food chain in Delhi, and ordering. The database will include a set of all branches in the Delhi region, a set of menu items, a set of employee data to keep track of performance of employees along with their details, a set of existing customers, a set of menu items currently being selected by a customer (cart) and a set of all the invoices generated. Each customer will be identified by his/her phone number wherein customers with the same address but different phone numbers will be treated as different customers. Upon launching the application, the users will be prompted to enter their phone number where if a match is found, they will be directed to the menu of the closest branch (according to the customer’s address). Otherwise, the customer will be treated as a first time customer and will enter his/her information and then proceed towards the menu. Once a customer has registered he/she need not register again. The customer can choose from a variety of food items, in different portion sizes. The customer will be notified with the status of his/her order and name of the delivery person. The customer is expected to rate his/her experience upon (notification of) delivery of the order.

Enitity-Relation Model

Relational Model

Screenshots

Phone Number Cart User Settings Invoice

How to build

You will need:

  1. Xcode 8.x
  2. Apache server, MYSQL server (We used XAMPP)
  3. Git clone this repository into a directory of your choice.
  4. If you're using XAMPP, copy the php files into the htdocs folder. Else, change their path in the urls.
  5. Run!

Project Maintainers

This repository is actively maintained by Swapnil, Vishnu and Tanya. For any queries, please send an email on:

swapnildhanwal@hotmail.com

tanya.agarwal23696@gmail.com

vishnubhaskar.vb@gmail.com