Test 1 review part 2

Question 1

is a candidate key that is chosen as the key the DBMS will use to uniquely identify each row in a given relation

Answer 1

primary key

Question 2

Determinant —> Candidate Key —> ________

Answer 2

Primary key

Question 3

a set of database specifications that can actually be implemented as a database in a DBMS.

Answer 3

Database design

Question 4

Each column can hold one value. Each column is of only one kind/domain (e.g. LastName)

Answer 4

INF

Question 5

Candidate keys are determined through the process of determinant / functional dependency identification; each table is in 1NF and all non-key attributes are determined by only the entire primary key

Answer 5

Second Normal Form (2NF)

Question 6

each table is in 2NF and no non-key attributes are determined by another non-key attribute; If more than one unique determinant is derived in the 2NF process, the separate theme entities must be separated

Answer 6

Third Normal Form (3NF)

Question 7

A __________stores data analysis used for research

Answer 7

online analytical processing (OLAP)