Database Design and Management

Godiva ChocolatierInc. Initial Research Project

Database Design and Management

Contents

1. Introduction        

2. Description of Business        

3. Data Flow Diagrams        

Context        

The Zero Level DFD        

The First Level DFD        

4. REA/ERD of Business        

5. Database Schema        

6. Tables        

Cashier Table        

1） Table Creation        

2) Insert Value        

3) Select * from cashier        

Customer table        

1)        Table creation        

2)        Insert value        

3)        Select * from customer        

Salesperson Table        

1)        Table creation        

2)        Insert value        

3)        Select * from salesperson        

Bank account table        

1)        Table creation        

2)        Insert value        

3)        Select * from bank account        

7. Queries        

1) Selection        

2) Group function        

3) Sorting function        

4)        Inner join        

5)        Sub-query        

8.        Procedure (If-else)        

9.        Procedure cursor        

While loop        

Goto loop