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 |
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,
What are the different types of constraints?
Can we create table in function?
what are myisam tables? : Sql dba
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
What is structural independence and why is it important?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Is sql sequential or random?
How to fetch common records from two tables?
What normalization means?
how view used for security purposes?
How do you write a subquery?
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)