Keywords

Keywords

• Database
• Table
• Record
• Field
• Primary Key
• Foreign Key
• SQL
• DDL
• DML
• DBMS

Datebase

• A structured set of data held in a computer, especially one that is accessible in various ways.

Table

• A set of facts or figures systematically displayed, especially in columns.

Record

• A group of selected data which are associated in some way.

Field

• A single piece of data within a record.

Primary Key

• A single unique key used to identify each record in a table.

Foreign Key

• A fi eld which can be used to cross-reference and access associated information across many tables.

SQL

• Structured Query Language (SQL) is a high-level language which is used to undertake this management activity. It is normally in two parts.

DDL

• Data Definition Language (DDL) is a standard for commands that define the different structures in a database.

DML

• A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating data in a database.

DBMS

• A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data.