Database - What is RDBMS? Explain its features

What is RDBMS? Explain its features.

RDBMS stands for Relational Database Management System. It organizes data into related rows and columns.

Features:

- It stores data in tables.
- Tables have rows and column.
- These tables are created using SQL.
- And data from these tables are also retrieved using SQL.

What is RDBMS? Explain its features.

RDBMS is a database management system based on relational model defined by E.F.Codd. Data is stored in the form of rows and columns. The relations among tables are also stored in the form of the table.

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.

Database - What is an Entity-Relationship diagram?
ER diagram is a conceptual and abstract representation of data and entities. ER is a data modeling process......
Database - Define referential integrity
Referential integrity is a RDBMS concept and ensures the relationships among tables remain consistent.....
Database - Define Primary key and Foreign key
A column or combination of columns that identify a row of data in a table is Primary Key.....
Post your comment
Discussion Board
Rdbms
Rdbms is database management system which based on reletional model,reletional model is simplest than other model
atul 04-15-2012