Interested to Buy Any Domain ? << Click Here >> for more details...
Explain different types of Normalization.
- 1 Answers
- 1833 Views
- HPCL, Hughes Systique Corporation, Ittiam Systems, I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
• 1NF (First Normal Form) – Eliminates duplicate columns, ensures atomicity.
• 2NF (Second Normal Form) – Removes partial dependencies.
• 3NF (Third Normal Form) – Removes transitive dependencies.
• BCNF (Boyce-Codd Normal Form) – Ensures every determinant is a candidate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a constant or literal in ms sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Explain differences between web edition and business edition?
What does the on delete cascade option do?
Write a program using SQL queries to find a unique entry in a table.
How many full-text indexes can a table have?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is the index requirement in SQL Azure?
What is multi-statement table-value user-defined function?
What is the difference between a local and a global temporary table?
Explain the usage of floor function in sql server.
How to use subqueries in the from clause in ms sql server?
Define views.
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is a filestream?
