What is database normalization?
Answer Posted / 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 |
Post New Answer View All Answers
Write a code to select distinct records without using the DISTINCT keyword.
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Can we join two tables without primary key?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is logshipping and its purpose?
What is a fill factor?
How can we rewrite sub-queries into simple select statements or with joins?
Explain the difference between control flow and data flow?
tell me the disaster recovery plan
what are different types of backups available in sql server? : Sql server database administration
What is a trigger in sql server?
What are transactions in sql?
Do you know how to implement service broker?
What is triggers and stored procedures?
What is table level trigger?