26-10-2016, 09:29 AM
1461180170-262132030RESTAURANTMANAGEMENTSYSTEM.ppt (Size: 1.4 MB / Downloads: 14)
Objective of the project:
The primary objective of the project is to develop a data base on restaurant management system . By using this project,I get an clear idea on how the data base works and how to use.
By working on this project I am able to understand the uses and accessing of data base systems.
Relevance to the Subject:
A database management system is system software for creating and managing databases.The DBMS provides the users and programmers with a systematic way to create,retrieve,update and manage data.
The Restaurant management system helps to understand how the data bases work in restaurants.Every restaurant have many entities and every entity has many attributes.By identifying the entities ,attributes and relations in the restaurant management system it becomes easier to go forward and work on it.
Firstly we come up with identifying all the entities ,attributes and relations in the data base and later building up a E-R diagram which gives an overview of the data base.The construction of E-R diagram comes in External level (or) View level.
Architecture
The External level/View level of the data base is represented in the form of E-R diagram.The Entity-Relationship diagram gives the basic idea of how the data base is developed.This is also called as E-R model of data base.
Implementation:-
This is implemented by using Vb.net.Before this we have to convert the above E-R diagram into tables i.e into Relational model . The Conceptual level or Logical level has different models such as Network model,Hierarchial model etc,where as Relational model is among the models of Conceptual level.
DATABASE TRRIGERS
Objective:
1) Creation of Triggers
2) Implementing Triggers: Create a transparent audit system for a table restaurant.The system must keep track of the records that are being deleted.The functionality being when a record is deleted the original record details and the date of operation are stored in the audit table then delete is allowed to go through.
Explanation: Here we have created a trigger on restaurant table . our aim is to keep track of records on restaurant table so that if any delete operation is fired on restaurant then our restaurant_audit table will be updated with the information that which record is deleted, who deleted it and on what date it was deleted.
We have restaurant table:
Specification: HardDisk
Applications:-
1) This restaurant database management system is useful in retrieving , storing and deleting data easily without any problem of redundancy and inconsistency.
2) The data can be accessed easily.It can store large amount of data without any confusion and repetition.
3) The concept of database management is not only used in restaurant management sytem but also in various systems like Hospital management system,University management system, Library management system etc.