Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Copy of PIZZA HUT ORDERING DATABASE MANAGEMENT SYSTEM

No description
by

Carissa Faustina

on 8 October 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Copy of PIZZA HUT ORDERING DATABASE MANAGEMENT SYSTEM

PIZZA HUT ORDERING DATABASE MANAGEMENT SYSTEM
Presented by,
Sameea Jamal - 16077
Maaera Altaf - 15663
Payail Tharani - 15690
Imran Abro - 15557
BBA (H)

Presented to,
SIR
WAQAR KHAN
Introduction
Database

What is a DBMS?

Structure of DBMS

Our Project

DATABASE
A database as an electronic filing system.

A database is basically a collection of information organized in such a way that a computer program can quickly select desired pieces of data.

Traditional databases are organized by fields, records, and files.
WHAT IS A DATABASE
MANAGEMENT SYSTEM?

To access information from a database, you need a database management system (DBMS).

DBMS is primarily used for storing, modifying, extracting, and searching for information within a database.

There are many different types of DBMS, ranging from small systems that run on personal computers to huge systems that run on mainframes.
TABLES
A table is a collection of related records.

If there are 100 employees, then each employee would have a record and the collection of 100 such records would constitute a table.
FIELDS
In database systems, fields are the smallest units of information you can access.

Most fields have certain attributes associated with them.

A field can be required, optional, or calculated.
Tables are integrated into a database.

This is done using a Database Management System.
RECORD
A record is a collection of related FIELDS.

An Employee record may contain name field(s), address field(s), birth date field and so on.
DATA HIERARCHY
refers to the systematic organization of data.
Database Management Systems
SUB FORMS
A subform is a form that is inserted in another form.

The primary form is called the main form, and the form that is enclosed in form is called the subform.

A form-subform combination is sometimes referred as a parent-child form.

Subforms are especially effective when you want to show data from tables or queries that have a one-to-many relationship.
KEYS
Primary Key
Secondary Key
Foreign Key
Super Key
Sort or Control Key
Alternate Key

REPORTS
Reports are a great way to organize and present data from your Microsoft Access database.

Reports enable you to format your data in an attractive and informative layout for printing or viewing on screen.
FORMS
A form is a database object that you can use to create a user interface for a database application.

A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.
In this ordering system we have created five tables namely,
1. Crew 2. Customer 3. Item 4. Order 5. Order Details

OUR PROJECT
The Ordering Database Management System
of
PIZZA HUT
TABLES
FIELDS
TABLE 1 - CREW
1. Crew Number 2. Crew Name 3. Contact No
4. Address 5. Salary

TABLE 2 - CUSTOMER

1. Customer No 2. Name 3. Age 4. Gender
5. NIC 6. Contact No 7. Email ID 8. Address


TABLE 3 - ITEM
1. Item No 2. Item Name 3. Item Detail 4. Standard Quantity 5. Item Price

TABLE 4 - ORDER

1. Order ID 2. Customer 3. Crew Name 4. Date

TABLE 5 - ORDER DETAILS
1. ID 2. Order ID 3. Product ID 4. Quantity

REPORTS
We have also generated the reports to pull information from the tables of our database and put it into a nice readable report format.
SUB FORM
FORMS
We have created forms of all the tables to provide an on-screen "form" for the customer to fill.
Order Details
We have also enclosed a sub form in the form "Order", to provide the customer, a variety of items to choose from.
FORM
SUB FORM
Thank you
Hope we delivered it the best :)
Full transcript