top-rated free essay

Database Project

By spooklk Jan 31, 2014 1591 Words
AGGREGATED
CATERING SYSTEM
PROJECT REPORT
11/12/2012

Contents
1 Problem Description ..............................................................................................................................................3 1.1 Description of the organization ................................................................................................................3 1.2 Scope of the database ....................................................................................................................................3 2 Entity-Relationship Diagram ..............................................................................................................................4 3 Relational Database Schema ...............................................................................................................................5 4 Printouts of Data Input Screen Form ..............................................................................................................6 4.1 Flavor Input Screen Forms ..........................................................................................................................6 4.2 Restaurant Input Screen Forms ................................................................................................................7 4.3 Menu Input Screen Form .............................................................................................................................8 4.4 Individual Customer Input Screen Form ...............................................................................................9 4.5 Group Customer Input Screen Form .................................................................................................... 10 4.6 Special Discount Input Screen Form .................................................................................................... 11 4.7 Order Main Screen Form ........................................................................................................................... 12 4.8 Order Detail Screen Form ......................................................................................................................... 13 4.9 Delivery Company Input Screen Form ................................................................................................ 14 4.10 Delivery Employee Input Screen Form ............................................................................................ 15 4.11 Delivery Detail Screen Form ................................................................................................................. 16 5 Sample Reports ..................................................................................................................................................... 17 5.1 Restaurant Sorted By Flavor ................................................................................................................... 17 5.2 Delivery Company Sorting ....................................................................................................................... 17 5.3 Order Completed .......................................................................................................................................... 18 5.4 Order Incompleted ...................................................................................................................................... 18 5.5 Income Before Discount ............................................................................................................................ 19 5.6 Income After Discount ............................................................................................................................... 19 5.7 Menu Of Restaurant .................................................................................................................................... 20 6 Printouts of Menu Screens................................................................................................................................ 21 6.1 Aggregated Catering System Main Menu ........................................................................................... 21 6.2 Backstage......................................................................................................................................................... 21 6.2.1 Restaurant ................................................................................................................................................... 22 6.2.2 Delivery ........................................................................................................................................................ 23 6.2.3 Customer ...................................................................................................................................................... 24 6.3 Customer Inquery ........................................................................................................................................ 24 6 Who contributed to what part of our project ........................................................................................... 25 6.1 Preparation ..................................................................................................................................................... 25 6.2 Earlier Period................................................................................................................................................. 25 6.3 Later Period .................................................................................................................................................... 25 2

1 Problem Description
1.1 Description of the organization
The project of our group is aggregated catering systems. The main function is to classify the dishes offered by various restaurants for customers to select . Customers can choose and buy dishes through our system conveniently, and the order will be submitted to the merchant automatically. After the food is cooked, it will be delivered to the customer's home by local take-away company, and the delivery status of all orders can be tracked in the backstage.

1.2 Scope of the database
The database system consists of 12 tables, 11 forms and 6 reports, our database system includes 3 modules: customer information management, business information maintenance and order status tracking. The 5 tables, Restaurant, Menu, OrderMain, Flavor and OrderDetail, belong to business information maintenance module. IndividualCustomer, GroupCustomer, SpecialDiscount, these 3 tables belong to the customer information module. The last 3 tables, DeliveryCompany, DeliverEmployee and DeliveryDetail, belong to the order tracking module.

Following is detailed description of the database system:

3

2 Entity-Relationship Diagram
DeliveryCompany
DCNo
DCName
DCAdd
DCCity
DCState
DCZip
DCPhoneNo

DeliveryEmlyee
ENo
EFirstName
ELastName
DCNo

Order Detail
ONo
DishNo
DishQty

DeliveryDetail
DNo
ONo
ENo
DSt

Customer

OrderMain

CNo
CAdd
CCity
CState
Czip
CPhoneNo

ONo
RNo
CNo
ODate

D,C
Group Customer

DishNo
DishName
DishPrice
R.No

Flavor
FlavorID
FlavorDesc

Individual Customer

GCName

Menu

ICFirstName
ICLastname

Restaurant
RNo
RName
RAdd
RCity
RState
RZip
RPhoneNo
FlavorID

Special Discount
C.No
R.No
Discount

4

3 Relational Database Schema
Menu (RNo, Dishno, DishName, DishPrice)
Menu.Rno references Restaurant.Rno
Restaurant (RNo, RName, RAdd, RCity, RState, RZip, RPhoneNo, FlavorID) Restaurant.FlavorID references Flavor.FlavorID
Flavor (FlavorID, FlavorDesc)
GroupCustomer
(CNo, GCName, GCSize, GCAdd, GCCity, GCState, GCZip, GCPhone) GroupCustomer.CNo references Customer.CNo
IndividualCustomer
(CNo,ICFirstname, IClastName, ICAcc, ICCity, ICState, ICZip, ICPhoneNo) Individual.CNo references Customer.CNo
OrderMain (ONo, RNo, ICNo, GCNo, ODate)
OrderMain.RNo references Restaurant.RNo
OrderMain.CNo references Customer.CNo
DeliveryDetail (DNo, ONo, ENo, DSt)
DeliveryDetail.ONo references OrderMain.ONo
DeliveryDetail.ENo references DeliveryEmployee.ENo
DeliveryEmployee (ENo, EFirstName, ELastName, DCNo)
DeliveryEmployee.DCNo references DeliveryCompany.DCNo
DeliveryCompany
(DCNo, DCName, DCAdd, DCCity, DCState, DCZip, DCPhoneNo)
OrderDetail (ONo, DishNo, DishQty)
OrderDetail.ONo references OrderMain.ONo
SpecialDiscount (RNo, CNo, Discount)
SpecialDiscount.RNo references Restaurant.RNo
SpecialDiscount.CNo references Customer.Cno

5

4 Printouts of Data Input Screen Form
4.1 Flavor Input Screen Forms
In the Flavor Form, we can add a new flavor or delete unwanted flavor. In the field below the table, we list all restaurants come from that flavor, as well as restaurant information.

6

4.2 Restaurant Input Screen Forms
In the Restaurant Form, a new restaurant and its information can be added or deleted. What’s great is the state of the restaurant can be selected from a drop-down form, no need to be manually entered in. Besides, the flavor is selected from flavorID to classify the restaurant taste.

In the table below, we list the specific information about each restaurant’s cuisine and price.

7

4.3 Menu Input Screen Form
In the Menu Input Screen Form, the new dishes as well as the price can be added or deleted. Restaurant information is selected from a drop-down form, however other information need to be manually entered in.

We list each cuisine order in the table below the input field.

8

4.4 Individual Customer Input Screen Form
In our Database System, our customers are divided into two categories, one is the ordinary individual customers, the other is corporate clients. Personal customer table can be added to the new individual customers as well as specific information of individual customers, and also can delete individual customers. Customer state is selected from a drop-down form, do not need to be manually entered in.

In the table below the input field, we list every individual customer order’s information.

9

4.5 Group Customer Input Screen Form
In the database, our customers are divided into two categories, one is the ordinary individual customer, the other is group customer.
With the group customer form, we can add or delete a new customer’s information. And the state of the customer is selected from a drop-down form. We list each restaurant special discount to each group at below.

10

4.6 Special Discount Input Screen Form
In the Special Discount Input Screen Form, the new restaurant discounts for corporate clients can be added or deleted. Restaurant information, RNo, is selected from a drop-down menu. Group customers information, GCNo, is the same. But the discount is manually entered in.

11

4.7 Order Main Screen Form
In the Order Main Screen Form, the new orders, order customer ID, restaurant number and order date can be added and deleted. Restaurant information, RNo, is selected from a drop-down form, no need to be manually typed in, as well as the customer number. Order date can be selected from the calendar. We list each order detail in the table below the input field.

12

4.8 Order Detail Screen Form
In the Order Detail Screen Form, the new order detail, the number of orders for specific dishes can be added or deleted. Order number, as well as the dishes number, can be selected from a drop-down form. Dishes quantity need to be manually input in.

13

4.9 Delivery Company Input Screen Form
In the Delivery Company Input Screen Form, the new delivery company and their specific information can be added or deleted. Company state is selected from a drop-down form, while other information are manually input in. We list the name and ID of each Delivery Company In the table below in the input field.

14

4.10 Delivery Employee Input Screen Form
In the Delivery Employee Input Screen Form, the ID and name of a new Employee can be added, you can also delete it. The ID of the company which hires the employee, DCNo, can be selected from a drop-down form. Other information are manually input in.

In the table below in the input field, we list the status of delivery order by each employee.

15

4.11 Delivery Detail Screen Form
In the Delivery Detail Screen Form, We can add a new delivery detail and status, and the corresponding order number and ID of employee who is responsible for the delivery. We can also delete a detail of the order. Besides, order number ,as well as the Employee Number, is selected from a drop-down table. After delivery is done, we select the DSt, which means the order has been delivered.

16

5 Sample Reports
5.1 Restaurant Sorted By Flavor
Here's the specific list of restaurants sorted by flavors.

5.2 Delivery Company Sorting
Here's the list of all delivery companies and the number of employees of each company.

17

5.3 Order Completed

Cite This Document

Related Documents

  • Database Assignment

    ...BCO 1102 Information Systems for Business Database Assignment Sunway- Kuala Lumpar Semester 1, 2011 The database assignment is divided into two major sections. The first requires you to develop a database in Access 2007. Imagine that this is a prototype that will have four tables and some basic features such as forms, reports and queries. ...

    Read More
  • Database management system notes

    ...inserted record. Dense indices – if the search-key value does not appear in the index, insert it. Sparse indices – if index stores an entry for each block of the file, no change needs to be made to the index unless a new block is created. If a new block is created, the first search-key value appearing in the new block is inserted into t...

    Read More
  • Database Management

    ...ITM540 – Database and Knowledge-base Management Module 3 Case Assignment 3 Robert T. Goodwin Database Applications In his book Groupware -- Computer Support for Business Teams, Robert Johansen defines groupware as "specialized computer aids that are designed for the use of...

    Read More
  • Lab Project

    ... Lab Project A Restaurant Database DBST651, Spring 2008 Submitted To Graduate School University of Maryland University College Date: Table of Contents: Statement of Work (SOW...

    Read More
  • Project Vulcan

    ...this group project: Learning Outcomes It is intended that by the end of this project, students will be able to:  Understand the structure of exploration data files,  Create, validate and composite a drillhole database,  Build a block model,  Estimate grades to blocks using Inverse Distance Technique,  Generate the r...

    Read More
  • Determining databases and Data Communications

    ... Determining databases and Data Communications Bis/320 September 23, 2013 Dr. Julie Ruse Determining databases and Data Communications Electronic Company To determine ways of managing a trade show booth the individual shall keep certain things in mind about the components, equipment, shippers, shipment, and time to assemble...

    Read More
  • Database and Local Borough

    ...ilondon.co.uk/profile/87337/Farringdon/Dystonia-Society/ S 06/02/14 Text The charity Is local and is situated in my local borough. http://www.boozyfruitychocolatyaffairs.com/?gclid=CKyg S 06/02/14 Text This is a charity site to raise money. The charity is local and is situated in my local borough. http://www.bouncycastleclub.co.uk/?gclid=C...

    Read More
  • what is reliability and integrity on databases

    ... What is Reliability and integrity for database? Alvin W. Demore II University of Maryland University College Abstract In this document we will be learning what reliability and integrity to databases and how company’s uses this technique to make sure that their company is strong and safe. Reliability plays a big part in database...

    Read More

Discover the Best Free Essays on StudyMode

Conquer writer's block once and for all.

High Quality Essays

Our library contains thousands of carefully selected free research papers and essays.

Popular Topics

No matter the topic you're researching, chances are we have it covered.