12 RULES OF RDBMS

Answer Posted / povidyasagar

1. Data should be represent in the form of table.
2. data is logically accessible.
3. all the null vaules should be uniformly treated as
unknown values.
4. single language should be used to communicate with RDBMS
package.
5. every relational database should be self described.
oracle contains two types of tables.
(a) system tables -- tables which contains meta data of user
tables.
(b) user tables -- tables with business data.
6. logical data independence.
7. physical data independence.
8. altematives must be provided for viewing data.
9. every RDBMS package should supports setbased and
relational algebra operations.
10. integrity rule.
11. every RDBMS package should support distributed operations.
12. data integrity cannot be subverted.
Note: Any DBMS package supports 6 out of 12 codds rules.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are synonyms used for?

606


How to create a new oracle data file?

555


Explain about the analyze command in oracle?

586


Please explain drop constraint oracle?

627


How to define an anonymous procedure with variables?

544






how do u setup a replication site?

1497


please explain.. DB architecture ...

1557


Explain the difference between replace() and translate() functions in oracle?

580


State and explain about oracle instance?

547


ABOUT IDENTITY?

1557


what is the use of system.effective.date variable in oracle?

671


Why is oracle used?

555


What is a table in oracle?

541


What are the set operators union, union all, minus & intersect meant to do?

562


How to start instance with a minimal initialization parameter file?

533