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
dbms- database management systems............ it is a collection of interrelated data and the set of programs to access those datas....... it is used to meet the disadvantages of the file systems....... there are many disadvantages of filesystems....... lik,, data redundancy and data in consistency, difficulty to access data,integrity problems, atomicity problems............. dbms is quite complicated but better than file systems
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS
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
no, Java is not dbms.. Java is a programming language Dbms is database
dbms
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.
importance of DBMS
gis and dbms
What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.
DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)