DB

DB 1

100

A unique identifier for each row in a table

primary key

200

A field in one table that links to the primary key in another table

Foreign key

300

Relationships

How tables are connected (one-to-one, one-to-many, many-to-many).

400

First Normal Form (1NF)

Eliminate repeating groups and ensure atomic values

500

Second Normal Form (2NF)

Meet 1NF and remove partial dependencies

DB 2

100

Two-dimensional structure with rows and columns.

Table

200

Data about data

Metadata

300

SQL - expand abbreviation

Structured Query Language

400

Third Normal Form (3NF)

Meet 2NF and remove transitive dependencies.

500

The database remains in a consistent state before and after the transaction.

Consistency

DB 3

100

What is a relational database?

A type of database that 'relates' tables to each other.

200

What is D in ACID?

Durability: Once a transaction is committed, it stays committed.

300

The two main actors that participate in any database transaction

Client and server

400

What is A in ACID?

Atomicity. All or nothing. If any part of the transaction fails, the entire transaction is rolled back.

500

What is I in ACID?

Isolation. Transactions don't interfere with each other.

Queries

100

Specifies how data is sorted in a result set.

Order by

200

Select everything from the Personnel table.

SELECT * FROM Personnel

300

What are wild card characters in SQL?

* % _

400

A function returns the total sum of a numeric column.

SUM()

500

How do you add comments to SQL?

Use the syntax /* */ or --

DB 4

100

Data vs information

Information - data processed with context.

200

Structure or plan of the database which defines the tables and relationships that exist in the database

Schema

300

Function returns the average value of a numeric column.

AVG()

400

Select all customers that start with the letter "a":

SELECT * FROM Customers
WHERE Name LIKE 'a%';

500

Add Name Bob to the Customers table

INSERT INTO Customers (Name, ) VALUES ('Bob');