can any one explain about normalization forms with clear
explanation in interview point of view.
thanks for ur answers.
Answer / ajeet khari
normalization is organizing data efficiently into database...
main thing is 1.elimination of redundant data,2. data
dependencies..
1NF-a table is decomposed into 2D table with no duplicate
column....
2nd NF- should be in 1NF and there should not be any
duplicate row...
3NF- should be in 2NF and contains transitive dependencies
remove that column which are not dependent on PK.
4NF-should be in 3NF and it has no malti valued dependencies.
| Is This Answer Correct ? | 10 Yes | 0 No |
Explain database partitioning.
Is storing images in a database a good idea?
What is the best database?
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
Explain database partitioning. What is its importance?
what are wrappers and build ups and what it's use?
aht is the difference b/w network & hierarchial & relational dbms????
What do you mean by database?
What are the two categories of Client-Server application development?
What is a reference table in database?
if i want to display the name of students such that to which city they belong must have count greaer than two
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
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)