Relational Database

Question 1

Table:

Answer 1

Collection of related data consisting of columns and rows (fields and records)

Question 2

Database:

Answer 2

Method to structure and organize a collection of data

Question 3

Field

Answer 3

Set of data values of a similar type, also known as a column

Question 4

Record

Answer 4

Row of data in a database table consisting of a single value from each column of data within the table

Question 5

Primary key

Answer 5

Uniquely specifies a row in a table

Question 6

Foreign key

Answer 6

To develop a relationship between two tables, they will share a column called a foreign key which relates the two tables

Question 7

Normalization

Answer 7

Question 8

Syntax of CREATE DATABASE Statement (SQL DDL Commands)

Answer 8

Question 9

Atomicity

Answer 9

This defines the elements that encompass a database transaction and guarantees that all of the transaction succeeds or none of it does. If part of the transaction fails, the entire transaction fails

Question 10

Consistency

Answer 10

This defines rules for maintaining data in a correct state after a transaction. This includes constraints, cascades, and any rules.

Question 11

Isolation

Answer 11

This ensures that effects of transactions are invisible to others. Essentially no transaction can be affected by another transaction

Question 12

Durability

Answer 12

This ensures that data changes are permanent when a transaction is committed.