Database Design: Removal of data, De-Normalization, Constraints, Normal Form, Create Indexing, ER Diagram, Relational Schema, Create Procedures

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. ER Diagram: Crow's Foot Notation....................................................................................16
7. Relational Schema..............................................................................................................17
8. Create Procedures...............................................................................................................18
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 and it is used to decrease the some problem in the Database queries with
the help of adding some redundant copies of information as well as reduce the schema layer of
normalization.
3

Queries
1
2
4

3a (i)
3a (ii)
5

3a (iii)
3a (iv)
6