Interested to Buy Any Domain ? << Click Here >> for more details...
What is database normalization?
- 7 Answers
- 18642 Views
- Deloitte, Digicel, JPMorgan Chase, Verifone, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti-khammam
It is the process of removing redundancy(repeated data) by
splitting the tables into smaller tables.
| Is This Answer Correct ? | 37 Yes | 3 No |
Answer / anirudh
Normalization is breaking the database into different
tables and defining a relationship between them.
Objective is to isolate the data so that additions and
deletions can be made in one table and propagated to other
tables through relationships.
| Is This Answer Correct ? | 20 Yes | 1 No |
Answer / shruti
Normalization is the process of breaking tables of a
database into smaller tables and defining relations between
them to make them more flexible, efficient and to remove the
modification anamolies from the database.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / kranthi
Normalization is the process of structuring relational
database schema such that most ambiguity is removed. The
stages of normalization are referred to as normal forms and
progress from the least restrictive (First Normal Form)
through the most restrictive (Fifth Normal Form).
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / dr. tawfik khattab
Normalization is the process of efficiently organizing data
in a database.
The goals of the normalization process asfollows:
1- Eliminating redundant data
2- Ensuring data total dependence on the Pk or on the
Composite PK
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / padmapriya
Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply
| Is This Answer Correct ? | 3 Yes | 2 No |
Normalize the data from the detabase.It reduces by the
normalisation rule like(there are 4 normalization rule and
BCNF)
| Is This Answer Correct ? | 10 Yes | 11 No |
What is @@Identity in sql?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Which system table contains information on constraints on all the tables created?
Can you explain powershell included in sql server 2008?
What are the different types of subquery?
what authentication modes does sql server support? : Sql server database administration
How to turn on the mssql api module in php?
What is user-defined inline table-valued function?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to genrate automaticlly empid like gt001
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
