key terms

Question 1

The column or set of columns that can be used to uniquely identify a record in a table.

Answer 1

Primary Key

Question 2

A column in a table that refers to a primary key column in another table.

Answer 2

Foreign Key

Question 3

A primary key that includes more than one column.

Answer 3

Composite Key

Question 4

A record in the table. For example in a students table the row is all the information about one student.

Answer 4

Row

Question 5

A category of data in a table such as name, address, cost, etc.

Answer 5

Column

Question 6

One cell in the table or one column in the record eg. the first name of the student identified by 356789.

Answer 6

Field

Question 7

All the information about one thing in a table, eg. a row.

Answer 7

Data Record

Question 8

Mismatched, duplicated, missing or inaccurate data. It can occur during insert, update or delete of data in a table when there are insufficient data integrity constraints in a table or if the table is not normalized or structured correctly.

Answer 8

Data Anomaly

Question 9

The opposite of a data anomaly. It describes the extent to which data is correctly matched, complete and accurate.

Answer 9

Data Integrity

Question 10

A rule that prevents duplicate data from being stored in one column of a table. For example, a primary key.

Answer 10

Uniqueness Constraints

Question 11

The relationship between related data records eg. 1-to-1, 1-to-many, many-to-many.

Answer 11

Cardinality

Question 12

The quality of data relationships between primary keys and foreign keys in a database.

Answer 12

Referential Integrity

Question 13

An outline of how that data is organized in a database. It is a graphical illustration that shows how each table is a database is laid out, including the fields, the types of data they contain and how the different tables are connected.

Answer 13

Relational Schema

Question 14

Contains information about attributes or fields of a certain data set (attribute name(field name), format, max field size, data type, etc).

Answer 14

Data Dictionary

Question 15

The SQL statement created to align with the Data Dictionary in a practical setting when creating tables.

Answer 15

Table Definition

Question 16

Allows data administrators to provide different levels of access for users. This will link to user authentication because if their User Level Access cannot be authenticated the user will not be able to access certain data.

Answer 16

User Level Access

Question 17

A process used to secure data, databases and the overall database solution. Passwords can be hashed so they are not stored in plain text in the database table.

Answer 17

Encryption

Question 18

Databases need to be regularly backed up. Most of these processes will be automated in a Database Management System.

Answer 18

Backup and Disaster Recovery Process

Question 19

Potential security threats are malware, data theft and identity theft, invasion of privacy.

Answer 19

Security and Protection

Question 20

The type of data stored in a column. For example text, numbers, boolean, etc. The data type of a column is a type of domain constraint as it prevents the wrong type of data from being stored in a field.

Answer 20

Data Type