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 |
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Is sql the best database?
How do I order by ascending in sql?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is data manipulation language?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between nvl function, ifnull function, and isnull function?
What is scope of pl sql developer in future?
what are string data types? : Sql dba
Explain exception handling in pl/sql?
Its possible to add more than one primary key for the table
Name some usages of database trigger?