The sample essay on Er Diagram For Restaurant Management System deals with a framework of research-based facts, approaches, and arguments concerning this theme. To see the essay’s introduction, body paragraphs and conclusion, read on.
IBS IT project—Restaurant management system Executive Summary Of Part-D This part of the project is to fulfill the requirements in the Software Requirement Specifications document. This part is accomplished with the help of the MS-Access and MS-Visio. We the team members of the GROUP-6 have divided the task, and completed their respective parts.
In this part, first of all we have drawn the ER diagram of our information system i. e. Restaurant Management Information System. Here all the entities and attributes are clearly mentioned which helps in the better understanding of the project.Then the various Database tables in MS-Access are shown with the help of the snapshots. A brief description of each database is done. Also the attributes in each database are mentioned. The Queries generated in the MS-Access are shown, and a brief decription is provided.
This queries helps the managers to take their decisions to allocate resources accordingly and thus maximizing the efficiency of the system with lowering on the costs and maximizing the system. Then the different forms implemented in the system are shown . At the last, various reports have been shown, which are of real concern to the top management of the company.Reports are the basis on which operational and tactical decision on vaious levels in the organization are taken.
ENTITY RELATIONSHIP DIAGRAM In the above ER diagram, the various Entities are: * Employee * Customer * Menu * Inventory * Order details * Purchase The different attributes related to them are also shown. These attributes provide a better understanding of the design part needed in MS-Access. TABLES Tables are the most important part of MS-Acess part as being the input which will result into the output. In this system we had used several tables , the screenshots of which had been given below.Below given are the different databases used in the project. A brief description of the databases is also provided under it. DATABASE FOR CUSTOMER customer| Customer ID| CUSTOMER nAME| CUSTOMER ADDRESS| PHONE NO| Feedback satisfactory| Emp id| C2| Neha singh| ibs| 9666463464| Yes| E12| C3| Namrata| ibs| 7569038707| No| E12| C4| Nalin Gupta| ibs| 9392751318| Yes| E13| C5| Mudit| ibs| 9666714362| Yes| E14| C6| Mayank Kaushik| ibs| 9666497287| No| E15| C7| Makankshi Agarwal| ibs| 9666467658| Yes| E15| C8| Krutarth Mankad| ibs| 9666463044| No| E15| C9| Kritika Negi| ibs| 9177613017| Yes| E13|Restaurant Management Information System is associated with many attributes. Some of the attributes in the Customer Details used are:- * CUSTOMER ID * CUSTOMER NAME * CUSTOMER ADDRESS * PHONE NO * FEEDBACK SATISFACTORY * EMPLOYEE ID PRIMARY KEY:- CUSTOMER ID DATABASE FOR EMPLOYEE: Employee Detail| Emp ID| Emp name| Emp add| Emp ph no| Emp designation| Emp joining Date| Emp salary| E10| Rashmi Choudhary| ibs| 9951112346| chef| 7/6/2010| 200000| E11| Purushottam Sharma| ibs| 9666714173| chef| 8/16/2007| 150000| E12| Purnima Mehta| ibs| 9666496631| wt| /2/2010| 100000| E13| Priyanka Pathak| ibs| 9666463853| wt| 11/15/2008| 100000| E14| Praveen Kothee| ibs| 9985382811| wt| 4/6/2010| 100000| E15| Poorvi Patel| ibs| 9666463946| wt| 8/2/2010| 100000| E5| Saurabh Bhutaney| ibs| 9666715041| mgr| 10/2/2009| 500000| E6| Ritika Singh| ibs| 9587959990| ast mgr| 4/28/2009| 300000| E7| Ritika Dugar| ibs| 9666713405| ast mgr| 10/28/2008| 250000| E8| Ritesh Marwah| ibs| 9666715085| ast mgr| 5/8/2008| 200000| E9| Richa Baid| ibs| 9705837678| chef| 1/8/2008| 200000| Some of the attributes in the Employee Details used are:- EMPLOYEE ID * EMPLOYEE NAME * EMPLOYEE ADDRESS * EMPLOYEE PHONE NO * EMPLOYEE DESIGNATION * EMPLOYEE JOINING DATE * EMPLOYEE SALARY PRIMARY KEY:- * EMPLOYEE ID DATABASE FOR INVENTORY Inventory Management| Item ID| Item Name| Item availibilty| Item Quantity| Purchase Date| A1| ladyfinger| No| 0| 8/10/2010| A2| carrot| No| 0| 8/9/2010| A3| potato| Yes| 12| 8/10/2010| A4| tomato| Yes| 15| 8/11/2010| A5| onion| Yes| 12| 8/11/2010| A6| cauli flower| Yes| 10| 8/10/2010| A7| cabbage| Yes| 5| 8/10/2010| Some of the attributes in the Item Details used are:- * ITEM ID ITEM NAME * ITEM AVAILABILITY * ITEM QUANTITY * PURCHASE DATE PRIMARY KEY:- * ITEM ID DATABASE FOR MENU Menu database| Dish ID| Dish Name| Dish Price| Availibility| 1| palak paneer| 124| Yes| 2| korma| 100| Yes| 3| malai kofta| 121| No| 4| Roti| 10| Yes| 5| tandoori chicken| 150| No| 6| tandoori mutton| 200| Yes| 7| dal makhani| 50| Yes| 8| shahi paneer| 100| No| 9| murg afghani| 250| Yes| 10| murg peshawari| 250| Yes| 11| mutter paneer| 100| Yes| 12| naan| 15| Yes| 13| butter naan| 25| Yes| Some of the attributes in the Menu Details used are:- * DISH ID DISH NAME * DISH AVAILABILITY * DISH PRICE PRIMARY KEY:- * DISH ID DATABASE FOR ORDER DETAIL Order Detail| Order ID| Dish ID| Order date| Customer ID| Quantity| Dish price| 101| 1| 8/10/2010| C2| 1| 124| 102| 2| 8/10/2010| C2| 2| 100| 103| 3| 8/10/2010| C2| 1| 121| 104| 4| 8/9/2010| C5| 2| 10| 105| 5| 8/9/2010| C5| 3| 150| 106| 12| 8/5/2010| C7| 4| 15| 107| 13| 8/6/2010| C8| 2| 25| 108| 10| 8/7/2010| C9| 1| 250| Some of the attributes in the ORDER Details used are:- * ORDER ID * DISH ID * ORDER DATE * CUSTOMER ID * QUANTITY * DISH PRICE PRIMARY KEY:- * ORDER IDDATABASE FOR PURCHASE: Purchase Database| Item ID| Supplier ID| Supplier NAme| Supplier Address| Supplier Ph no| Item name| Invoice no| A1| A 101| Wali Mohammad| ibs| 8125010911| potato| 12034| A2| A102| Tarun Patro| ibs| 9951116109| tomato| 43555| A3| B203| Shivesh| ibs| 9666464065| onion| 56577| A4| C475| Sanjiv Khemka| ibs| 7416942020| cauli flower| 56266| A5| D234| Sayan Chatterjee| ibs| 9666497167| cabbage| 67876| Some of the attributes in the PURCHASE Details used are:- * ITEM ID * SUPPLIER ID * SUPPLIER NAME * SUPPLIER ADDRESS * INVOICE NO * SUPPLIER PHONE NO QUERIESQueries are the basis of any management system . The queries generated helps the managers to take their decisions to allocate resources accordingly and thus maximizing the efficiency of the system with lowering on the costs and maximizing the system. There are infinite query which can be generated, but we have shown few queries which can help us understand how this system can help us get the most vital information. Note:- The Design view of the queries is only shown below. These queries can be run in the MS-Access easily and the respective outputs can be easily derived. 1.To check the availability of item? 2. To check the dish availability? 3. How to check employee details? employee deatail| Emp ID| Emp name| Emp designation| Emp joining Date| Emp salary| E10| Rashmi Choudhary| Chef| 7/6/2010| 200000| E11| Purushottam Sharma| Chef| 8/16/2007| 150000| E12| Purnima Mehta| Wt| 8/2/2010| 100000| E13| Priyanka Pathak| Wt| 11/15/2008| 100000| E14| Praveen Kothee| Wt| 4/6/2010| 100000| E15| Poorvi Patel| Wt| 8/2/2010| 100000| E5| Saurabh Bhutaney| Mgr| 10/2/2009| 500000| E6| Ritika Singh| ast mgr| 4/28/2009| 300000| E7| Ritika Dugar| ast mgr| 10/28/2008| 250000|E8| Ritesh Marwah| ast mgr| 5/8/2008| 200000| E9| Richa Baid| Chef| 1/8/2008| 200000| 4. To check the item purchse date? 5. What are the payment details? 6. To check the details of the suppliers? 7. To know about the satisfied customers? FORMS Dish Availability Form Employee Detail Form Item Purchase Form Payment Reciept Form Supplier Invoice Form: SWITCHBOARD The switchboard acts as a main interface to access all forms and reports. It is created to increase the ease of use. Switchboard consists of trigger buttons for all forms and reports . REPORTSReports are the reflection of the queries which we have generated. These are the most important aspect of the system which really concerns the top management of the company as these are the final reports which helps studying understanding the customer pattern and behaviour and important decision can me made as per those outcomes. Reports are the basis on which operational and tactical decision on vaious levels in the organization are taken. Following are the various reports generated by the given this system. Employee Report ITEM PURCHASE REPORT: MENU REPORT PAYMENT REPORT UNSATIFIED CUSTOMERS REPORT