Software development life cycle-hotel sales Management System Example---1. Database design

Software project development Model

a spiral development model

Suitable for the early part of the project needs of the situation, for each module to develop each:

Analysis, design, coding, testing, on-line.

Benefits: Reduce the risk of software development (products to meet user needs as far as possible)

Two waterfall mode

First of all the requirements of the module analysis, when the analysis is over, only to enter the next phase of the project, namely design, coding, testing, on-line

It is easier to control the project, the quality of the project is controlled.

"Restaurant King" system function analysis

1. Table Management

2. Food category Management (cuisine)

3. Food information (dishes)

4. Order Management

Detailed analysis

1. Background input table, to be displayed in the foreground: and only show not booked

2. Background input menu category, display on the front page

3. Background input menu information, displayed on the front page

4. Orders generated by the foreground, show order details in the background

================================================

Database system table Design

================================================

----1. Table

CREATE DATABASE Hotel Character Set UTF8;

Use Hotel;

CREATE TABLE dinnertable

(

ID INT PRIMARY auto_increment,-----table primary Key

TableName VARCHAR,-----table name

Tablestatus INT deafult 0,-----table State 0 Free 1 Reservations

OrderDate DATETIME

);

----2. Table of Cuisine categories

CREATE TABLE FoodType (

ID INT PRIMARY Key auto_increment,---primary key

TypeName VARCHAR----Dish alias

);

----3. Table of varieties of dishes

CREATE TABLE Food (

ID INI PRIMARY Key auto_increment,---primary key

Foodname VARCHAR,---dish name

FOODTYPE_ID INT,----owned cuisine, foreign key field

Price DOUBLE,---prices

Mprice DOUBLE---member price

Remark VARCHAR ($),---Introduction

IMG VARCHAR (---) 's photos

);

----4. Order Form

CREATE TABLE Orders (

ID INI PRIMARY Key auto_increment,----primary key

TABLE_ID INT,---foreign key, table number

OrderDate datetime,---order date

Totalprice Double,--the total amount required for the order

Orderstatus INT DEFAULT 0,--order status 0 not checkout 1 checkout

);

----5. Order schedule (mainly of dishes)

CREATE TABLE OrderDetail (

ID INT PRIMARY Key auto_increment,---primary key

OrderId INT,---Foreign key, introduces the primary key of the order table

FOOD_ID INT,---foreign key, refers to the primary key of the menu information table

Foodcount INT---The number of dishes

);

----To add a relationship constraint to a dish category

ALTER TABLE Food ADD constaint fk_food_foodtype_id FOREIGN KEY (foodtype_id) REFERENCES foodtype (ID);  

----Order Details, relationship to the order form

ALTER TABLE orderdetail ADD CONSTRAINT orderdetail_order_id FOREIGN KEY (orderId) REFERENCES orders (ID);

----Order Details, and the relationship of the menu information ALTER TABLE orderdetail ADD CONSTRAINT orderdetail_food_id FOREIGN KEY (food_id) REFERENCES food (ID); ----Order table, relationship with table table ALTER TABLE orderdetail ADD CONSTRAINT order_table_id FOREIGN KEY (table_id) REFERENCES dinnertable (ID);

Software development Life cycle-hotel sales Management System Example---1. Database design