what is normalization?
what is denormalization?
Answer Posted / shantanub
Normalization is the process of organizing data in a
database. This includes creating tables and establishing
relationships between those tables according to rules
designed both to protect the data and to make the database
more flexible by eliminating two factors: redundancy and
inconsistent dependency.
Is This Answer Correct ? | 51 Yes | 5 No |
Post New Answer View All Answers
What is difference between joins and subqueries?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How you can get a list of all the table constraints in a database? : Sql server administration
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Can I use sql azure as a backup with log shipping or database mirroring?
What is the difference between for xml raw and for xml auto?
How to generate create function script on an existing function?
What is the default server name for sql server?
What is difference between primary key and foreign key?
what is normalization? : Sql server database administration
What are out-of-range errors with date and time literals?
What is an indexed view?
How sql server executes a statement with nested subqueries?
How many non clustered indexes there can be on table ?
How to add a new dsn with the odbc driver for sql server?