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.
- 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