Modules Of Mcd

MODULES This project has six types of modules with their description listed below  Product & price The product is the physical product or service offered to the consumer. In the case of physical products, it also refers to any services or conveniences that are part of the offering. Product decisions include aspects such as function, appearance, packaging, service, warranty, etc. Pricing decisions should take into account profit margins and he probable pricing response of competitors. Pricing includes not only the list price, but also discounts, financing, and other options such as leasing.  Order In this module we will take the order from the customers, will make an order list And this order will be sent to the respective customers.  Employees

 Customers

 Distributors & Sales  Marketing

Structure of Tables Product & Price This table gives the information about the product of a particular code like qty of the product, price and data of manufacturing type etc. The structure of the table is defined below: For Veg:Name Product Name Code Qty Price Flavors Production date

Null?

Type VARCHAR2 (30) VARCHAR2 (6) NUMBER (10) NUMBER (10.2) VARCHAR2(10) DATE

In this table the column (Product Code & Code) is used as a primary key. For Non-Veg:Name Product Name Code Qty Price Flavors Production date

Null?

Type VARCHAR2 (30) VARCHAR2 (6) NUMBER (10) NUMBER (10.2) VARCHAR2(10) DATE

In this table the column (Product Code & Code) is used as a primary key.

Employees: It includes all the information about a particular employee, his personal details like his employee number in the company, name, address, phone, sex, date of birth, salary, etc. The structure of the table is defined below: -

Name employee_no employee_name address date_of_hire salary emp_cell emp_email emp_salary sex

Null?

Type NUMBER (5) VARCHAR2 (20) VARCHAR2 (50) DATE NUMBER (10) VARCHAR2 (50) VARCHAR2 (255) NUMBER (12,2) CHAR (1)

In this table the column (emp_no) is used as a primary key

Customers: In this table Customers, it includes the information about the Customers of the Mcdonald’s and his personal details like Customer name, address, phone, comments etc. The structure of the table is defined below: Name Customers Phone No Name Address comments

Null?

Type NUMBER (2) VARCHAR2 (15) VARCHAR2 (35) VARCHAR2 (15)

In this table the column (Customers Phone No) is used as a primary key

Distributors: In this table Distributors it includes the information about the distributors of the company. It also contains the Name of the distributors, Address, Phone No, product provided by the distributors etc. The structure of the table is as below:Name Distributor ID Name Address Phone No Product Provided

Null?

Type NUMBER (2) VARCHAR2 (15) NUMBER (10) NUMBER (10) NUMBER (10)

In this table the column (Distributors ID & Phone No) is used as a primary key

Stock Maintenance : -

In this table Stock Maintenance it includes the information about the daily sales of the Products. It also contains the Name of the Products, Quantity in Hand, Basic Rate, etc. The structure of the table is as below:Name Product ID Name Qtyinhand Basic Rate Qtysales Product Availability

Null?

Type NUMBER (2) VARCHAR2 (15) NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10)

In this table the column (Product ID) is used as a primary key

:In this table Daily sales it includes the information about the daily sales of the Products. It also contains the Name of the Products, Quantity in Hand, Basic Rate, etc. The structure of the table is as below:Name Product ID Name

Null?

In this table the column () is used as a primary key

Type NUMBER (2) VARCHAR2 (15) NUMBER (10) NUMBER (10) NUMBER (10) NUMBER (10)