Database key terms: tables, keys, SQL and DBMS

Key Terms

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

Database

• A database is a what manages the data. For example data that is stored in a table.

Table

• A table is where all the information/data is stored.

Record

• A record is a row in the table that hold information about a single item. ( a group of selected data in that are associated in some way )

Field

• Inside a column there is information such as an item price this is the field. ( a piece of data in a record )

Primary Key

• A primary key gives a unique identification to the records in the table.

Foreign Key

• Foreign keys are primary keys that are in other tables. It can be used for cross-reference.

SQL

• Structured query language is a high level language which undertakes the management. Normally in 2 parts.

DDL

• Data definition language is a part which is used to define a database structure.

DML

• Data manipulation language is a part that is used to add, delete or change and query the data that is in the database.

DBMS

• DBMS is a software that allows you to use the data. ( Database management systems )

Threats and Protection Keywords

• . Physical Barrier
• . Passwords Control
• . Access Levels
• . Anti Virus Software
• . Firewall
• . Encryption
• . Backup

Physical Barriers

• Physical barriers include turning off computers and locking offices to make sure that there is no damage or theft to the systems.

Password Control

• Password control is a private and secret password that only the user knows so that they can access their computers and systems and no one else can, because it is protected with the password that is a mix of letters, upper case, lower case and characters.

Access Levels

• Access levels are set up to allow different levels of access for different people can access the data at different levels.

Anti Virus Software

• Anti Virus Software is set up to stop computer viruses before they affect the computer.

Firewall

• A firewall is a piece of software that monitors the data the leaves and comes through to your computer to stop unwanted things such as viruses.

Encryption

• Encryption is used to codify data so that it can not be read by people unless it is the person who it has been sent to and allowed permission too.

Backup

• A backup is when you backup data so that if it is lost it can be recovered. There are different types of backups., Such as full system backup which is when all of the data is saved. Incremental backups of files or data that has been changed since the last full backup.Backups to removable media, such as a removable hard drive