Databases

Front 1

Logical operators in database queries

Back 1

< Less than

> Greater than

NOT

AND

OR

SELECT * FROM Pets

WHERE Age < 7 AND Type NOT(Dog)

Front 2

Primary & Foreign keys

Back 2

Primary and Foreign keys are used to link related records in different tables.

Primary key is a unique identifier.

Foreign key is a value which is the primary key of a record in another table.

Front 3

Data validation

Back 3

Data validation is used to make sure the data entered meets set rules.

Front 4

What is a relational database?

Back 4

A database which contains multiple tables linked by primary and foreign keys.

Relational databases remove the repetition and inconsistency usually found in flat-file (single table) databases.

Front 5

What is an entity?

Back 5

A real world object about which data is being held.

Represented as a table in a database.

Front 6

Tables

Back 6

Tables hold data about a specific entity, ie a Student.

They are made up of rows (records) and columns (fields) .

Front 7

Forms

Back 7

A form is an input screen that allows data to be displayed and edited.

They use text boxes, drop down menus and checkboxes to update the database.

Front 8

Queries

Back 8

A query is a command used to search the database and return relevant results.

SELECT * FROM Students

WHERE Age > 17

Front 9

Report

Back 9

An output of data in the database in a specific format (layout), usually printed.

Front 10

Modules

Back 10

Used to add functionality to a database.

Modules contain statements and subroutines that are stored together as a unit and can be executed by a user.

Front 11

What is a DBMS?

Back 11

DataBase Management System

Used to manage the database by creating tables, inserting data, executing queries.

It also keeps data secure and is used to create relationships.

Front 12

Separating the application and database

Back 12

Separating the application and the database means that the data can be accessed from lots of different applications.

For example desktop application and online.

Front 13

Customised data handling applications

Back 13

Using the DBMS to create a set of tools for setting up and maintaining a specific database.

These can be created by experts to make editing the database easy for non-specialists.

Front 14

What is a database?

Back 14

A persistent, organised, structured store of data.

Front 15

Data handling software

Back 15

Data handling software (like Microsoft Access or BaseBear) is used to create databases, add new information and edit existing information.