Ask a question from expert

Ask now

Database Design for Food Delivery Service

8 Pages646 Words458 Views
   

Added on  2019-09-16

About This Document

This article discusses the database design for a food delivery service, including dependency diagrams, entity relationship diagrams, and relational model diagrams. The scenario involves a traditional paper system for managing orders, menus, restaurants, customers, and riders, which the company wants to replace with a database management system. The article outlines the assumptions made during the design process and the challenges faced, and provides visual representations of the database design.

Database Design for Food Delivery Service

   Added on 2019-09-16

BookmarkShareRelated Documents
STUDENT NAME04 November, 2016ASSIGNMENT 2
Database Design for Food Delivery Service_1
ContentsINTRODUCTION.....................................................................................................................................2ASSUMPTIONS.......................................................................................................................................2DEPENDENCY DIAGRAM........................................................................................................................3ENTITY RELATIONSHIP DIAGRAM..........................................................................................................5RELATIONAL MODEL DIAGRAM.............................................................................................................61 | P a g e
Database Design for Food Delivery Service_2
INTRODUCTIONThe scenario is about a food delivery service which provides riders to deliver food from restaurant tothe customer. The system is a traditional paper system or we can say book keeping where all recordsare on paper. Hence this makes it very complex to manage the information on paper and avoid any errors. So the company has decided to get a database management system built for the use. The requirements of the company are to hold information about orders, menus, restaurants, customers, and riders. So to design this we gathered all the available data to create a visual design of the database. The design consists of the entities and the attributes that will be required to fulfil the user needs. From this design, another database design will be built. Although designing makes the entire processsimple that of actual implementation, still there we some difficulties faced. There were large numberof records. We also had to find a way in which all past paper records can be added uniquely to the system and still the information not being altered. Apart from that meeting the requirements in sucha way that future requirements are considered and added was also a complex task. But after careful analysis and designing, the diagrams below have been created.ASSUMPTIONSThe following assumptions were made1.Each menu item will belong to a category2.Category table will hold information about different categories of food like starters, deserts, main course etc.3.Each category will have unique id.4.Each customer will have a unique id5.Customer’s basic info will be stored.6.Each rider will have information in rider table with unique rider id7.Each menu id item will have a unique id2 | P a g e
Database Design for Food Delivery Service_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Information About Different Categories of Food
|10
|990
|410

Database Design and Implementation for Fashion Outlet
|33
|5708
|93