Chapter 4

Question 1

Define field

Answer 1

column that runs vertically within a table

Question 2

Define foreign key

Answer 2

link records of one type with those of another type

Question 3

Define keys

Answer 3

uniquely identify a row or record in a table

Question 4

Define normalization

Answer 4

a three-step technique used to organize data attributes in a more efficient, reliable, flexible, and maintainable structure (ERFM)

Question 5

Define primary key

Answer 5

a field whose value uniquely identifies every row in a table

Question 6

Define row

Answer 6

a record that represents a collection of information relating to an item in a table

Question 7

Define table

Answer 7

structured file containing rows and columns

Question 8

What does first normal form mean?

Answer 8

there must be only one distinct group per table

Question 9

How is first normal form accomplished?

Answer 9

breaking tables into smaller, more-logical components and adding primary keys

Question 10

What are the three steps in normalization?

Answer 10

First, second, and third normal form

Question 11

What does second normal form mean?

Answer 11

all columns in a table are dependent on the primary-key column

Question 12

How is second normal form accomplished?

Answer 12

continue to break down tables until all columns are dependent on the primary key

Question 13

What does third normal form mean?

Answer 13

reexamining all the groups of information to make sure all data directly relates to the primary key

Question 14

How is the third normal form accomplished?

Answer 14

removing any remaining columns that do not relate to the primary key