Key words (Databases)

Key Words

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

Database

• A database is a system for managing a collection of data. Data about a particular type of thing – for example, customers or products – is stored in a table.
• https://www.youtube.com/watch?v=FR4QIeZaPeM (Embed)
• Caption: Use for SQL

Table

• A table has a specified number of columns, but can have any number of rows.
• https://www.youtube.com/watch?v=FCtGbrou5DM (Embed)
• Caption: Use for Primary Key, Foreign Key.

Record

• You can think of a table as a grid. Every row in the table holds information about a single item; this is also called a record.

Field

• Every column holds information about a property of the items in the table, such as a customer’s name or an item’s price – these properties are called fields.
• https://www.youtube.com/watch?v=ijsDlEbqS4g (Embed)

Primary Key

• All tables have a primary key on which they are organised. The primary key is the unique identifier of each record in the table.

Foreign Key

• The tables may themselves hold fields which are primary keys in other tables ( foreign keys ) which can be used to access associated information from many tables in one query.

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
• DML

DDL

• This is the part which is used to define the database structure.
• https://www.youtube.com/watch?v=i676Jmtb0V0 (Embed)
• Caption: Use for DML

DML

• This is the part used to add, delete, change and query the data which is held in the database structure.

DBMS

• A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data
• https://www.youtube.com/watch?v=R5BN-1Llhcw (Embed)