RDBMS - STUDY NOTES

Post Top Ad

RDBMS




A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. The leading RDBMS products are Oracle, IBM'sDB2 and Microsoft's SQL Server.

Features: -

- Provides data to be stored in tables
- Persists data in the form of rows and columns
- Provides facility primary key, to uniquely identify the rows
- Creates indexes for quicker data retrieval
- Provides a virtual table creation in which sensitive data can be stored and simplified query can be applied.(views)
- Sharing a common column in two or more tables(primary key and foreign key)
- Provides multi user accessibility that can be controlled by individual users.


Functional Dependency
Functional dependency is a relationship that exists when one attribute uniquely determines another attribute.

Attribute
In a database management system (DBMS), an attribute refers to a database component, such a table. It also may refer to a database field.

Tuple
In the context of databases, a tuple is one record (one row).

Field

In database management systems, a field can be required, optional, or calculated. 


for detailed information download PDF


downloading server are below

server 1 [media fire]

No comments:

Post a Comment

Post Bottom Ad