19-01-2006

Dependencies of three types
Partial Dependencies.
Transitive.
Functional

Functional Dependency is set to exist when Non Primary key is dependent on Primary key and also on the whole of primary key.

For successful operation of RDBMS, normalized tables are required.

Normalization is a process of identifying primary key and ensuring that all the non key attributes (all the columns in a table not a part of primary key) have full functional dependencies on the primary key and whole of the primary key.

RDBMS can handle one to many relationships.

Normalization can also be defined as resolving many to many relationships to one to many relationships.

Degree of normalized data is measured in normal form.

Oracle claims that it has implemented 11.5 rules of E.F. Codd. But few critics say that it is a false claim because according to them Oracle has implemented only 8 rules. What ever may be the controversy but fact remains that Oracle has implemented maximum rules proposed by E.F. Codd.

Primary and Foreign Keys values are Functional values.

Non Program Access or Non Procedural Access (E. F. Codd)
In this method of accessing data user may not be required to know the programming to access the data. It doesn’t mean that no procedure is followed to access the data. Of course some procedure is followed but user doesn’t need to worry about it. Following the procedure is part and parcel of Database. In brief it is Database’s responsibility and not user’s. All user needs to do is to select the data he needs.

For Non Procedural access we need to know different Languages. E.F. Codd proposed the language SQL. SQL stands for Structured Query Language.

Different statements are as follows:
DML à Data Manipulation Language.
EG: Insert, Update, Delete,

DLL à Create, Drop


DCL à Data Control Language

TC à Transaction.
EG: Rollback

Administration.
EG: Startup, Shutdown and Archive.


Oracle also provides procedural method called PL/SQL. PL/SQL stands for Programmable Language Structured Query Language.

Next feature of RDBMS is Relational Algebra.

Set of attributes is called Table. Tables are defined only by columns. Rows came after columns. You don’t need columns to define Table.

Set algebra related to relational sets is called Relational Algebra.

Selection
Projection
Intersection
Mining
Union
Product
Join

Selection: Selection allows you to provide certain Laws. Selection is a process of filtering.

Projection: If I want to select a particular attribute or I want to select whole set of attributes or columns then the procedure of selection is called Projection.

Intersection: If there are two sets A and B and I want to select the elements common to set A and set B, then the procedure of selection of such elements is called Intersection.
Take for instance A= {1, 3, 5, 6, 9} and B= {3, 4, 5, 8}
Then A intersection B = {3, 5}

Union: Again considering above example if I want to select the elements such that the new set includes all the elements of A and B but excluding the repeated elements then such a method of selection of elements is called Union. Therefore A union B = {1, 3, 4, 5, 6, 8, 9}

We can also take union in such a manner that A union B includes the elements which are repeated as well.

Product: A = {1, 3, 5} and B = {2, 4, 6}
Then A product B = {
(1, 2)
(1, 4)
(1, 6)
(3, 2)
(3, 4)
(3, 6)
(5, 2)
(5, 4)
(5, 6)
}

Scientific name of tables is called Relational.

Data Dictionary:
Tables maintained by the system or information of system stored in the form of tables is called Data Dictionary. Data Dictionary is also called Meta Data indicating that data of data. It is stored in RDBMS.

Concept of Null:
If certain value is not known or not applicable then it is called Null. Null is not equal to other null. Because either both are unknown or not applicable. Arithmetic of null is also null.
EG: null + 3 = null

Null Value Locator (NVL):
It is denoted by (x, 0) for addition and (x, 1) for multiplication. If we know the value of x then of course we will use it but if we don’t know the value of x then instead of making it null we can assign a value 0 for addition or 1 in case of multiplication.