Difference between DBMS and RDBMS...CODD's rules

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I audit the sql sent to the server?

730


Show code of a cursor for loop.

771


explain the difference between myisam static and myisam dynamic. : Sql dba

705


What is partition in sql query?

721


How can I change database name in sql?

703






write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

728


Can a table have no primary key?

774


Can you load data into multiple tables at once? : aql loader

800


Is it possible to include an insert statement on the same table to which the trigger is assigned?

734


What is break?

845


What is partition by in sql?

784


How do I save a stored procedure?

729


What is a trigger in sql?

886


Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

735


What is a full join sql?

785