Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between DBMS and RDBMS...CODD's rules
- 4 Answers
- 16987 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyoti ranjan parida
DBMS-Database management system.
=>In dbms no relationship concept
=>It can't impliment constraints in table and no security
of data.
=>It supports Single User only
=>It treats Data as Files internally
=>It supports 3 rules of E.F.CODD out off 12 rules
=>It requires low Software and Hardware Requirements.
=>Examples:Foxpro
RDBMS-Relational management system
=>It is used to establish the relationship concept between
two database objects, i.e, tables
=>It impliment constraints in table and no security of data.
=>It supports multiple users
=>It treats data as Tables internally
=>It supports minimum 6 rules of E.F.CODD
=>It requires High software and hardware requirements.
=>examples:Oracle,mysql,DB2.
| Is This Answer Correct ? | 39 Yes | 3 No |
Answer / avi007
DBMS-Database management system.
1> consider as file says field,attributes,record and file.
2> table relationship mentained by programmaticaly.
3> high network trafic.
4> distributed datable not supported.
5> no security
RDBMS-Relational management system
1> says column, row and table.
2>table relationship mentained at the time of table
creations.
3>low network trafic.
4>distributed database supported.
5>login level security.
| Is This Answer Correct ? | 10 Yes | 3 No |
what is the difference between myisam static and myisam dynamic? : Sql dba
What are the two different parts of the pl/sql packages?
how tsql statements can be written and submitted to the database engine? : Transact sql
Explain the order of sql statement execution?
Main diff between varray and nested tablea
Can you select everything, but 1 or 2 fields, without writer's cramp?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body
What is t sql used for?
What problem one might face while writing log information to a data-base table in pl/sql?
What is the usage of sql functions?
How to count the no of records of a table without using COUNT function?
-
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)
