MIDTERMS

Question 1

is a database design technique that organizes tables in a manner that reduces redundancy and dependency of data

Answer 1

Normalization

Question 2

Divides larger tables into smaller tables and links them using relationships

Answer 2

Normalization

Question 3

The purpose of ___ is to eliminate _____ (___) data and ensure data is stored logically

Answer 3

Normalization

Question 4

Three main rules for normalizing data

Answer 4

Eliminate repeating data

Eliminate partial dependencies

Eliminate transitive dependencies

Question 5

This rule is all about disallowing multivalued attributes

Answer 5

Eliminating repeating data

Question 6

This refers to situations where the key for a table is a composite primary key, which means a key composed of MULTIPLE COLUMNS

Answer 6

Eliminating partial dependencies

Question 7

This refers to situations where in a column in the table refers to a non-key column instead of referring to the primary key of a table

Answer 7

Eliminate transitive dependencies

Question 8

PROBLEMS that can occur in poorly planned, unnormalized data bases where all the data is stored in one table (flat-file database)

Answer 8

Anomaly

Question 9

Types of anomalies

Answer 9

Insert
Delete
Update

Question 10

States that the domain of an attribute must include only atomic values and that the value of any attribute in a row must be single

Atomic value pertains to the built-in atomic data types

ACID

Answer 10

First normal form

Question 11

ACID MEANING

Answer 11

ATOMICITY
CONSISTENCY
ISOLATION
DURABILITY

Question 12

According to EF CODD, a relation is in __NF if it satisfies the following conditions

The table should be in the first normal form
there should be no partial dependency

Answer 12

Second normal form

Question 13

The attributes which are used to form a candidate key are called ___ attributes

Answer 13

Prime attribute

Question 14

The attributes which do not form a candidate key are called ___ attributes

Answer 14

Non-prime attribute

Question 15

___ dependency is a concept that specifies the relationship between two sets of attributes where one attribute determines the value of another attribute

Answer 15

Functional dependency

Question 16

____ dependency is a specific type of dependency that happens in table with a composite primary key (a primary key made up of two columns)

Answer 16

partial dependency

Question 17

According to the EF CODD, a relation is in ____ normal form if it satisfies the following:

It should be in second normal form

it should not have transitive dependencies

All transitive dependencies are removed to place in another table

Answer 17

Third normal form (3NF)