IT DBMS

what is primary key?

A primary key is a unique value that identifies a row in a table. These keys are also indexed in the database, making it faster for the database to search a record.

what is RDBMS?

A relational database management system (RDBMS) is a database management system that is based on the relational model. In the relational model of a database, all data is represented in terms of tuples (rows), grouped into relations (tables). A database organized in terms the relational model is a relational database.

what is candidate key?

It has all possible attributes to become a primary key but is not a primary key.

What is DBMS?

It is a software that is responsible for storing, manipulating, maintaining and utilizing database. A database along with the a DBMS is referred to as a database system.

Advantages of Database?

Reduces Data Redundancy Sharing of Data Data security Privacy Backup and Recovery

what is foreign key?

The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.

What is Data?

it's raw facts and figures.

what is information?

meaningful, useful interpretation of data.