Quiz 2 - Ch 6

Question 1

Process of evaluating and correcting table structures to minimize data redundancies : N…………..

Answer 1

Normalization

Question 2

Reduces data anomalies: N……..

Answer 2

Normalization

Question 3

H……… normal forms are better than l…….. normal forms

Answer 3

Higher / lower

Question 4

… is as high as we need to go in normalization process

Answer 4

3NF

Question 5

Produces a lower normal form: D………..

Answer 5

Denormalization

Question 6

Results in increased performance and greater data redundancy: D……….

Answer 6

Denormalization

Question 7

Need for Normalization
Used while d………a new d………. s…….
Analyzes the r………… among the a……… within each e…..
Determines if the s……….. can be i………….
Improves the existing d………. s…….. and creates an appropriate d…….. d……..

Answer 7

Used while designing a new database structure
Analyzes the relationship among the attributes within each entity
Determines if the structure can be improved
Improves the existing data structure and creates an appropriate database design

Question 8

Characteristic of 1NF: Table f….., no repeating g….., and P…. k….. identified

Answer 8

format/ groups/ primary key

Question 9

Characteristic of 2NF: 1NF and no p…….. d……….

Answer 9

partial dependecies

Question 10

Characteristic of 3NF: 2NF and no t………. d……….

Answer 10

transitive dependencies

Question 11

Characteristic of 4NF:3NF and no i……… m…………. d………

Answer 11

independent multivalued dependecies

Question 12

Functional dependence in which the determinant is only part of the primary key: P…….. d……….

Answer 12

Partial Dependency

PK(A,B)->(C,D), B->C

Question 13

An attribute functionally depends on another nonkey attribute: T…………… d…………

Answer 13

Transitive dependency

PK(X)->Y, Y->Z, Then X->Z

Question 14

Requirements for Good Normalized Set of Tables
Evaluate P….. K….. assignments and n…….. c…………
Refine a……… a……..
Identify new a……… and new r……….
Refine p….. k…… as required for data granularity
Maintain h…….. a……… and evaluate using d…….. a……….

Answer 14

Evaluate PK assignments and naming conventions
Refine attribute atomicity
Identify new attributes and new relationships
Refine primary keys as required for data granularity
Maintain historical accuracy and evaluate using derived attributes

Question 15

A…….. a………..: Cannot be further subdivided

Answer 15

Atomic attribute

Question 16

A…………: Characteristic of an atomic attribute

Answer 16

Atomicity

Question 17

G……… : Level of detail represented by the values stored in a table’s row

Answer 17

Granularity

Question 18

S………. K…….. :Used by designers when the primary key is considered to be unsuitable

Answer 18

Surrogate Keys

Question 19

S………. K……..: Have a numeric value which is automatically incremented for each new row

Answer 19

Surrogate Keys

Question 20

Characteristic of BCNF: Every d……….. is a c…….. k….

Answer 20

determinant / candidate / key

Question 21

Same characteristics as primary key but not chosen to be the primary key: C………… K………..

Answer 21

Candidate Key

Question 22

N………… should be part of the design process

Answer 22

Normalization

Question 23

Proposed entities must meet the required normal form b…… table structures are created

Answer 23

before

Question 24

Principles and normalization procedures to be understood to r……… .and m…….. databases

Answer 24

redesign / modify

Question 25

ERD is created through an i……….. process

Answer 25

iterative

Question 26

Normalization focuses on the c……….of specific e………..

Answer 26

characteristics / entities

Question 27

Number of database tables e……. when tables are decomposed to conform to n………requirements

Answer 27

expands / normalization

Question 28

Circumstances for denormalization:
R......... data
D............ data
P.................data
I................. requirements

Answer 28

Redundant data
Derived data
Reaggregated data
Information requirements