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
Can we use insert statement in function?
What is a full join?
What is Difference Between Unique and Primary Key Constraints?
What are the disadvantages of not performing database normalization?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
how to fetch alternate records from a table? : Sql dba
how would you get the current date in mysql? : Sql dba
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are the three forms of normalization?
How do you explain an index number?
What is the use of sql trace?
how many columns can be used for creating index? : Sql dba
What is index example?
What is scalar function in sql?
Is microsoft sql free?