In SQL data consistency is that whenever a transaction is performed, it sees a consistent database. During the transaction, if the database is not consistent, then there are two reasons for it, which are as follows:
1-database failure (software or hardware failure)
2-multiple accesses
data consistency makes sure data integrity and vice versa.
:)
sdfsfas
what do u mean by lossiess join in dbms
multivalued data
save point saves the dbms and check point simply check the database thats it simple
TUPLE : Is the "ROW" in a table
sdfsfas
it describes the instance of one entity is associated with each instances of an entity depending upon the range of cardinality constraints are two types they are minimum cardinality maximum cardinality
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS
no, Java is not dbms.. Java is a programming language Dbms is database
dbms
A concurrent schedule in DBMS refers to multiple transactions running concurrently without interfering with each other. This allows for improved performance and efficiency in handling multiple operations simultaneously. However, it requires careful management to ensure data consistency and avoid conflicts such as race conditions.
Hierarchical DBMSNetwork DBMSRelational DBMS
In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.
importance of DBMS
What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.
DBMS (Database Management Systems) typically overcome TFBS (Transaction Failure Before System) by using transaction management techniques such as ACID properties (Atomicity, Consistency, Isolation, Durability). These ensure that transactions are either fully completed or reverted to their original state in case of failure, maintaining data integrity. Additionally, DBMS often implement logging and recovery mechanisms to help recover the database state in case of unexpected failures.
Polyhedra DBMS was created in 1993.