Which of these are not a type of rdbms:
a)
Oracle © b)
MsAccess © c)
MS Sql Server © d)
MS Excel (nc)
Explain: Excel is not a
relational database; it's a spreadsheet. A relational database contains tables where each column holds the value for an attribute. Every value in that column
holds the same attribute, but for a different entity.
Which of these are not a type of dbms:
a) Oracle © b)
MsAccess © c)
MS Sql Server © d)
MS Excel (nc)
Explain: Excel is not actually
a DBMS. Excel can do some of these functions but is not a DBMS and MS Word stores data in flat files as such and is therefore not a DBMS .
Difference Between RDBMS and DBMS
A DBMS has to be persistent, that is it should be
accessible when the program created the data ceases to exist or even the
application that created the data restarted. A DBMS also has to provide some
uniform methods independent of a specific application for accessing the
information that is stored.
RDBMS is a Relational Data Base Management System Relational DBMS. This adds
the additional condition that the system supports a tabular structure for the
data, with enforced relationships between the tables. This excludes the
databases that don't support a tabular structure or don't enforce relationships
between tables.
Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.
DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard because rdbms define the integrity constraint for the purpose of holding ACID PROPERTY.
DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern and RDBMS are designed to take care of large amounts of data and also the security of this data.
Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.
DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard because rdbms define the integrity constraint for the purpose of holding ACID PROPERTY.
DBMS are for smaller organizations with small amount of data, where security of the data is not of major concern and RDBMS are designed to take care of large amounts of data and also the security of this data.
great one can you describe further more about this
ReplyDelete