12 RULES OF RDBMS
Answer / 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 |
Is the After report trigger fired if the report execution fails ?
How to convert times to characters in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What are the arithmetic operations?
What is a subquery?
Why do we need integrity constraints in a database?
How to create index-by table in oracle?
what is the syntax of UPDATE command?
How do we get field details of a table?
who is the father of oracle and send chodd rules
What suggestions do you have to reduce the network traffic?