Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff between dbms and rdbms(what are the 12
rilations in the rdbms).
- 5 Answers
- 8273 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sid
DBMS is a system that allows to insert, update, delete and
retrieve data
RDBMS stores data in the form of related tables. It allows
data security
12 rules for RDBMS are:
-data should be tabular
-accessing of data must be easy
-supports for null values in fields other than primary key
-tool must be same for database structure and for data itself
-database must support at least one programming language
-data can be represented as views
-insert,update and delete operations for multiple tables/rows
-data should be physically independent
-data must be logically independent
-integrity independence of database
-user should not know distribution of database
-modifying database structure must be through a language
like SQL
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / ashumku7
1: In DBMS files are stored and retrieved through programs
whereas in RDBMS everything is stored in the form of table.
2: DBMS does not support client server architecture whereas
RDBMS does;
3: DBMS satisfy less than 7 to 8 rules of E.F codd where as
RDBMS satisfy more than 7 to 8 rules.
4: In DBMS there is no security of data where as in RDBMS
there are different(generally 3)layers of security:
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rajesh
dbms : Database management system
types of dbms: network,hierarchial,object-oriented,relational,object-relational
rdbms : relational database management system.
It is a type of dbms which is the most popular one.
data is arranged based on Entity-Relationship model
(E-R model) in rows and columns (records,attributes)
So, RDBMS and DBMS are not comparable because DBMS is a concept and RDBMS is a kind of DBMS.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sunil kumar
dbms is database management system that allow instance
delete insert update
rdbms is store related tablespace data and folw 12 rulls
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / vikas gupta
dbms: is database management system
rdbms: it is the relational database management system.
12 rules for RDBMS are:
-data should be tabular or in normalized format
-accessing of data must be easy
-supports for null values in fields other than primary key
-tool must be same for database structure and for data
itself
-database must support at least one programming language
(SQL)
-data can be represented as views
-insert,update and delete operations for multiple
tables/rows
-data should be physically independent
-data must be logically independent
-integrity independence of database
-user should not know distribution of database
-modifying database structure must be through a language
like SQL
| Is This Answer Correct ? | 0 Yes | 4 No |
What is variable dbms?
What are stored-procedures? And what are the advantages of using them.
What's the difference between star and snow flake schema?
what are the acid properties in dbms?
Define database model.
What is Schema in DBMS?
wHAT IS THE difference between foreign key and reference key
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
Explain the functionality of dml compiler.
How do you backup a database?
Why normalisation is required?
What versions of clipper does netlib support?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
