AllFreePapers.com - All Free Papers and Essays for All Students
Search

Database Design and Management

Autor:   •  June 29, 2016  •  Coursework  •  1,538 Words (7 Pages)  •  939 Views

Page 1 of 7

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        

...

Download as:   txt (9.1 Kb)   pdf (1.5 Mb)   docx (678.5 Kb)  
Continue for 6 more pages »