Explain the Importance of Data Normalization.
- 1 Answers
- 292 Views
- I also Faced
- E-Mail Answers
The practice of structuring data to reduce redundancy and enhance data integrity is known as data normalization. It entails creating associations between the smaller tables in a database. The significance of normalization is that it
minimizes the duplication of data.
guarantees the consistency of the data.
simplifies the structure, which facilitates updating and maintenance.
removes unneeded data to improve query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is variable dbms?
What is default value database?
Define view, sequence and index in DBMS.
Define primary and unique key?
What are the four objectives of the selection of a data type?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
What do you understand by join?
What is drivermanager getconnection?
Define fragmentation.
What does <> mean in database?
For a field in a repeating frame, can the source come from a column ?
What is an ALERT ?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
