Glossary

Glossary

Backup : It is a program or process of copying table contents into a file for future reference. It’s a challenging task for DBA’s

Primary : Key This key of relational table identifies each record in the table in a unique way.

Relationship : There exists a relationship between two tables when the foreign key of one table references primary key of other table.

Cardinality : It is defined as the number of different values in any given table column

Open Source : Open source – refers to the design that is publicly accessible by people for modification and sharing

SQL : It (Structured query Language) is a programming language designed mainly for managing data in RDBMS

Record : Record is referred in a table, which are composed of fields.

Query : In SQL, all commands are named as query. The query statement is executed against the databases.

Join : Retrieves data from two or more tables, by referencing columns in the tables that hold identical values