Question

In your own words discuss the benefits of normalization

Answer 1

Benefits of normalization - 7 Noomalization is defined as a process in database management System in order to meduce medundancy of data. + By normalization techniques we can organize the data in such a way that there will be no repetition of data. → used for removing O update anamoly deletion anamoy Insertion anamdy → Queries will be executed very fastly after normalizing t he data the → Data consistency:- Afler normalization - data is not ambigous. Scanned with CamScanner

- When we normalize data, we can convert the large table into small table so that it leads to table compaction → bata base is organized properly by applying hoomalization techniques → small amount of data can be understood by the database users very easily. iyin a non-normalized data the extraction I of data becomes hard and there are many chances of getting erroos. So the data should be normalized - some normal forms are: normal forms CS Scanned with INFO CON ONE BCNF) CamScanner

These normal forms are applied on the data and thus data consistency and data integrity happens. FF:- 1 NF:- A data table is in first normal form if it contains atomic values. anFico 'The table should be ostale ☺ There should be no functional dependency ① table should be a NF 3NF:- There should be no transitive dependency. BUN+- (Boyce codd nloomal foom): ② table should be BNE cs x @ if every function al dependency 4 within is super key.