NOMALIZATION STEPS
Normalization is the process of organizing data in a database. It used to reduce space in data base as well as form up speed and security. There are three types.
1. 1NF
This step is done for prevent blank and various values of data in cell. we use “NOT NULL” OR “default” keywords to prevent.
1. 2NF
This step is done for prevent from repeat values of
data
2. 3NF
This step is done to verify above two steps done
correctly.
RELATIONAL DATABASE
relational database is a collection
of information that organizes data in predefined relationships where data is
stored in one or more tables.
Tables in database
1) BOOKS
2) READERS
3) SUPLPLYERS
4) LIBRIANS
5) DELAY FEE
6) ISSUED BOOKS
7) PAYMENTS
8) AUTHOR
SQL statements of table creation
SQL statements of adding data
Adding data to BOOK table
Adding data to READERS table
Adding data to
SUPPLIERS table
Adding data to ISSUED BOOK table
Adding data to DELAY FEE table
Adding data to AUTHOR table
SELECT QUERIY
RESULT
UPDATE QUERIY
RESULT
DELETE QUERIY
