Database Design and Management
Autor: escaaaaa • June 29, 2016 • Coursework • 1,538 Words (7 Pages) • 931 Views
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
...