Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between DBMS and RDBMS...CODD's rules
- 4 Answers
- 16800 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 |
How to read/write files from pl/sql?
Explain what is a database?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
How do I view a procedure in sql?
What is input buffer in sql*plus?
Can a commit statement be executed as part of a trigger?
What is keys and its types?
Can a foreign key be a duplicate?
Differentiate between % rowtype and type record.
what is the difference between to_char and to_date functions?
How will you make performance better for application including front end and back
why sql is used as interpreter frequently rather than a compile?
-
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)
