|
|
Category:
Database
|
Date:
12/6/2009 5:05:27 AM
|
|
|
|
Data integrity means the correctness and consistency of data. Enforcing data integrity ensures the q....
|
Category:
Database
|
Date:
10/7/2009 4:43:37 AM
|
|
|
|
One-to-One relationship can be implemented as a single table and rarely as two tables with primary a....
|
Category:
Database
|
Date:
10/7/2009 2:51:09 AM
|
|
|
|
Database denormalization is the reverse process of database normalization. Denormalization is the pr....
|
Category:
Database
|
Date:
10/7/2009 2:29:21 AM
|
|
|
|
Database Normalization is a process to ensure that every non-key column in every table is directly d....
|
Category:
Database
|
Date:
10/7/2009 2:16:03 AM
|
|
|
|
Commit command is used to make all the changes permanent to the underlying database which we made du....
|
Category:
Database
|
Date:
9/21/2009 9:51:29 PM
|
|
|
|
ROLLBACK command is used to end the current transaction and undo all the changes we made since the c....
|
Category:
Database
|
Date:
9/21/2009 9:49:59 PM
|
|
|
|
COMMIT command is used to make all the changes permanent to the underlying database which we made du....
|
Category:
Database
|
Date:
9/21/2009 9:47:19 PM
|
|
|
|
Cardinality refers to the type of relationship like the relationship between two entities is one to ....
|
Category:
Database
|
Date:
8/20/2009 3:06:52 AM
|
|
|
|
When number of transaction are running at the same time and if a situation occurs when the one trans....
|
Category:
Database
|
Date:
8/20/2009 3:04:53 AM
|
|
|
|
Concurrency refers when the two or more transaction are executed simultaneously.
|
Category:
Database
|
Date:
8/20/2009 3:03:52 AM
|
|
|
|
Candidate key is a set of one or more attribute other than primary key that can uniquely identify a ....
|
Category:
Database
|
Date:
8/20/2009 3:02:40 AM
|
|
|
|
A foreign key is a referential constraint between two tables. The foreign key identifies a column or....
|
Category:
Database
|
Date:
8/20/2009 3:01:26 AM
|
|
|
|
Primary key is the unique identifier for a record in the table. Here record refers to the value in t....
|
Category:
Database
|
Date:
8/20/2009 2:57:19 AM
|
|
|
|
DBMS is a system where all interrelated data is atored and it allows the user to access data, modify....
|
Category:
Database
|
Date:
8/20/2009 2:56:07 AM
|
|
|