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 |
how to insert the image in table
Can we create trigger on view in oracle?
please explain.. DB architecture ...
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
what are views?
17. Display the order number and average item cost for each order.
How do I call oracle stored procedures that take no parameters?
Can we protect our pl/sql source code?
How to create a testing table in oracle?
What are the database administrators utilities available?
What are the type of Synonyms?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?