Define normalization, Database Management System


Normalization:It is a process of examine the given relation schemas based on their primary key and Functional Dependencies (FDs) to achieve the properties

  • Minimizing redundancy
  • Minimizing deletion, insertion and update anomalies.

Database normalization is the process of arranging the tables and fields of a relational database to minimize dependency and redundancy. Normalization generally adds dividing large tables into smaller tables and describing relationships between them.

 

477_normalisation.png

Posted Date: 7/30/2012 2:02:32 AM | Location : United States







Related Discussions:- Define normalization, Assignment Help, Ask Question on Define normalization, Get Answer, Expert's Help, Define normalization Discussions

Write discussion on Define normalization
Your posts are moderated
Related Questions
Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

Given the following relations Vehicle (Reg_no, make, colour) Person(eno, name, address) Owner(eno, reg_no) Write expressions in the relational algebra to answer the following

What is SQL Profiler? SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save dat

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

Although how will the system recover The selection of REDO or UNDO for a transaction for the recovery is completed on the basis of the state of the transactions. This state is

Domain Constraint It shows that each attribute in a relation has to contain an atomic value only from the corresponding domains. The data types associated with commercial RDBMS

#quCreate a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu