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
What is exporting utility?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the types of dml?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
How many types of stored procedures are there in sql server?
What is index in an assignment?
Is it important for a database administrator to understand the operating system and file access?
How to generate create table script on an existing table in ms sql server?
Explain nested join?
What is bit data type? What's the information that can be stored inside a bit column?
What are entities and relationships?
How to execute function in stored procedure sql server?
What is the purpose of the model database?
How many types of local tables are there in sql server?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration