Database Programming: Design, Normalization, Constraints, Indexing, Procedures

DATABASE PROGRAMMING

Table of Contents
Database Design..............................................................................................................................3
1. Removal of data....................................................................................................................3
2. De-Normalization.................................................................................................................3
3. Constraints............................................................................................................................9
4. Normal Form......................................................................................................................12
5. Create Indexing...................................................................................................................15
6. Create Procedures...............................................................................................................16
2

Database Design
1. Removal of data
There is no duplicate data.
2. De-Normalization
De normalization is the process of improving the speed for the read-based performance of
the Database structure.
3

Queries
1
2
4