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:
* Order details
The different attributes related to them are also shown. These attributes provide a better understanding of the design part needed in MS-Access.
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 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
DATABASE FOR EMPLOYEE:
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| 8/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...