Send the link below via email or IMCopy
Present to your audienceStart 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
Copy of PIZZA HUT ORDERING DATABASE MANAGEMENT SYSTEM
Transcript of Copy of PIZZA HUT ORDERING DATABASE MANAGEMENT SYSTEM
Sameea Jamal - 16077
Maaera Altaf - 15663
Payail Tharani - 15690
Imran Abro - 15557
What is a DBMS?
Structure of DBMS
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
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.
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.
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.
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.
refers to the systematic organization of data.
Database Management Systems
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.
Sort or Control Key
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.
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
The Ordering Database Management System
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
We have also generated the reports to pull information from the tables of our database and put it into a nice readable report format.
We have created forms of all the tables to provide an on-screen "form" for the customer to fill.
We have also enclosed a sub form in the form "Order", to provide the customer, a variety of items to choose from.
Hope we delivered it the best :)