what is Normalization?
Answers were Sorted based on User's Feedback
Answer / cr
Normalization is a design technique to develop table
structures. Purpose of normalization is to eliminate
redundant data.
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / murthybabu
The process of decomposing tables to eliminate data
redundancy is called Normalization.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / subhash
Normalizatiin is the scientific method of breaking down
complex table sturcture into simple table structure by
using certain rules.using this method you can reduce
redundency in a table and eliminate the problem of
inconsisteny and disk space usage.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sudipta
Normalization is a technique by which successive redundancy
of a given relation is make into a more easier form.it
improves the tuple quality and make the data in a
consistence state,also helps to improves redundant data.
(Higher the normal form better the tuple type)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / anjali
normalization is to crystalizing the table into small
tables to avoid the redundancy. splitting table into small
ones.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gladys
Is the process of efficiently organizing data in a database.
| Is This Answer Correct ? | 0 Yes | 2 No |
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Explain about post-relational databases?
What is the system function to get the current user's user id?
Can an extended stored procedure be called from inside a user-defined function?
Explain what a database is?
Write the difference between case version and decode version.
Explain the role of indexing in databases?
Explain about normal forms?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain about the relational database?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What is DB Development software?
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)