Difference between DBMS and RDBMS...CODD's rules
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 |
Why self join is used in sql?
Why do we use view in sql?
I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS
how mysql optimizes distinct? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
What is the use of triggers?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is composite data type in pl sql?
How can we debug in PL/SQL?
Why stored procedure is faster than query?
What is plpgsql language?
How to set up sql*plus output format in oracle?
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)