The following data was collected during CSU’s data-gathering efforts. Show a logical

design (normalization) for the data.

Student Data:

Student ID

advisor firstname

Sname

advisor MI

birth date

advisor department

gender

classYear

marital status

resident status

advisor ID

major

advisor lastname

minor

HomePhone

CellPhone

Phone3

Clubs

Progress Data:

Term 1

Term 2

course name 1.1

course name 2.1

course description 1.1

course description 2.1

hours 1.1

hours 2.1

grade 1.1

grade 2.1

course name 1.2

course name 2.2

hours 1.2

hours 2.2

grade 1.2

grade 2.2

and so on