Answer Posted / nashiinformaticssolutions
Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention what is the function that is used to transfer a pl/sql table log to a database table?
how are mysql timestamps seen to a user? : Sql dba
Is it possible to read/write files to-and-from PL/SQL?
Is primary key is clustered index?
what is an index? : Sql dba
What is flag in sql?
Is sql a oracle?
Explain scalar functions in sql?
How to get help at the sql prompt?
What is cost in sql execution plan?
How many disk partitions should I have?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Name the different types of indexes in sql and define them.
How to add new employee details in an employee_details table with the following details
What is mdf ldf and ndf?