Database Management System In Pizza Hut

BACKGROUND COMPANY OF SECTOR IN PIZZA HUT MALAYSIA

1.0 Introduction

The Pizza Hut is one of the leading fast food manufacturing companies in the world. The Keels Restaurants are the franchise holder for Sri Lanka and Maldives, Keel restaurant is a subsidiary company of John Keels Group, which is one of the largest companies in Sri Lanka. Currently Pizza Hut has extended to 15 outlets and 2 express outlets.

According to their marketing statistics home delivery system brings more profits to the company. It 's because the customers prefer more to have their fast food at their homes itself. Especially during the rainy season people do not like to go out. So the Pizza Hut doesn 't like to lose their profits during this period. They have many

The standard acronym for database management system is DBMS, so you will often see this instead of the full name. The ultimate purpose of a database management system is to store and transform data into information to support making decisions.

A DBMS consists of the following three elements:

1. The physical database: the collection of files that contain the data

2. The database engine: the software that makes it possible to access and modify the contents of the database

3. The database scheme: the specification of the logical structure of the data stored in the database

While it sounds logical to have a DBMS in place, it is worth thinking for a moment about the alternative. What would the data in an organization look like without a DBMS? Consider yourself as the organization for a moment, and the data are all the files on your computer. How is your data organized? If you are like most typical computer users, you have a large number of files, organized in folders.

You may have word processor documents, presentation files, spreadsheets, photographs, etc. You find the information you need based on the folder structure you have created and the names you have given to your files. This is called a file system and is typical for individual computer

Now consider the challenges you are faced with. Have you ever lost a file? Have you had difficulty finding a file? Probably. Perhaps you are using multiple computers and your files are located in different physical locations. And when was the list time you created a backup of all your files? You do back up, right?

You probably get the picture. A file system is relatively simple, but it only works if you keep yourself very organized and disciplined. Now consider an organization with 1,000 employees, each with their own computer. Can you see some of the challenges when using a file system? Do you really want critical financial data floating around the offices as simple files on individual computers?

3.0 Functions of a DBMS that used in Pizza Hut

A DBMS makes it possible for users to create, edit and update data in the database. The files more control over your data. Once created, the DBMS makes it possible to store and retrieve data from those database