WGU C170 Data Management Applications VHT2
Task 1 | Actual Normalization and Database
Design Assessment with Answers (2026/2027)
SCENARIO: University Student Course Registration System
You are a database designer for a regional university. The Registrar's Office currently
tracks student course registrations using a spreadsheet system that has become
increasingly problematic as enrollment grows. The current spreadsheet contains
student information, course details, instructor assignments, and registration data all in a
single table.
Management has asked you to design a normalized relational database to replace the
spreadsheet system. The current unnormalized data contains the following sample
records:
UNNORMALIZED DATA SET (Current Spreadsheet)
Table
S St Co In Re
C S G
t Stu ud ur st Instr gist
Stude o Cours Instru e r
u den en se ru uctor rati
ntEm Major u eNam ctorN m a
d tNa tP Cr ct Offic on
ail r e ame e d
e me ho ed or e Dat
s s e
n ne its ID e
e t
t
,I I e
D D r
F
Build
S C Datab a
Emi emily. 55 Comp Dr. ing 202
1 S ase I1 ll
ly c@uni 5- uter Sarah A, 4-0
0 2 Funda 3 0 2 A
Che versit 01 Scien Johns Roo 8-1
0 0 mental 1 0
n y.edu 01 ce on m 5
1 1 s 2
301
4
F
Build
S C a
Emi emily. 55 Comp Dr. ing 202
1 S Data I1 ll
ly c@uni 5- uter Micha B, 4-0 B
0 2 Struct 4 0 2
Che versit 01 Scien el Roo 8-1 +
0 0 ures 2 0
n y.edu 01 ce Brown m 5
1 5 2
205
4
M F
Build
S A a
Emi emily. 55 Comp ing 202
1 T I1 Dr. ll
ly c@uni 5- uter Calcul C, 4-0 A
0 H 4 0 Lisa 2
Che versit 01 Scien us I Roo 8-1 -
0 1 3 Davis 0
n y.edu 01 ce m 5
1 5 2
110
0 4
, F
B Build
S Mar marc Busin Introd Dr. a
55 U ing 202
1 cus us.r@ ess uction I1 Jame ll
5- S D, 4-0
0 Rod univer Admi to 3 0 s 2 B
01 1 Roo 8-1
0 rigu sity.e nistra Busine 4 Wilso 0
02 0 m 6
2 ez du tion ss n 2
1 401
4
E F
Build
S Mar marc Busin C a
55 Princip Dr. ing 202
1 cus us.r@ ess O I1 ll
5- les of Aman D, 4-0 C
0 Rod univer Admi N 3 0 2
01 Econo da Roo 8-1 +
0 rigu sity.e nistra 2 5 0
02 mics Garcia m 6
2 ez du tion 0 2
402
0 4
F
Build
S Mar marc Busin C Datab a
55 Dr. ing 202
1 cus us.r@ ess S ase I1 ll
5- Sarah A, 4-0
0 Rod univer Admi 2 Funda 3 0 2 B
01 Johns Roo 8-1
0 rigu sity.e nistra 0 mental 1 0
02 on m 6
2 ez du tion 1 s 2
301
4
S Sop sophi Introd
55 Dr. F 202
1 hia a.w@ P uction I1 Build
5- Psych Rober a 4-0
0 Will univer S to 3 0 ing A
01 ology t ll 8-1
0 iam sity.e Y Psych 6 E,
03 Taylor 2 7
3 s du 1 ology Roo
0
Task 1 | Actual Normalization and Database
Design Assessment with Answers (2026/2027)
SCENARIO: University Student Course Registration System
You are a database designer for a regional university. The Registrar's Office currently
tracks student course registrations using a spreadsheet system that has become
increasingly problematic as enrollment grows. The current spreadsheet contains
student information, course details, instructor assignments, and registration data all in a
single table.
Management has asked you to design a normalized relational database to replace the
spreadsheet system. The current unnormalized data contains the following sample
records:
UNNORMALIZED DATA SET (Current Spreadsheet)
Table
S St Co In Re
C S G
t Stu ud ur st Instr gist
Stude o Cours Instru e r
u den en se ru uctor rati
ntEm Major u eNam ctorN m a
d tNa tP Cr ct Offic on
ail r e ame e d
e me ho ed or e Dat
s s e
n ne its ID e
e t
t
,I I e
D D r
F
Build
S C Datab a
Emi emily. 55 Comp Dr. ing 202
1 S ase I1 ll
ly c@uni 5- uter Sarah A, 4-0
0 2 Funda 3 0 2 A
Che versit 01 Scien Johns Roo 8-1
0 0 mental 1 0
n y.edu 01 ce on m 5
1 1 s 2
301
4
F
Build
S C a
Emi emily. 55 Comp Dr. ing 202
1 S Data I1 ll
ly c@uni 5- uter Micha B, 4-0 B
0 2 Struct 4 0 2
Che versit 01 Scien el Roo 8-1 +
0 0 ures 2 0
n y.edu 01 ce Brown m 5
1 5 2
205
4
M F
Build
S A a
Emi emily. 55 Comp ing 202
1 T I1 Dr. ll
ly c@uni 5- uter Calcul C, 4-0 A
0 H 4 0 Lisa 2
Che versit 01 Scien us I Roo 8-1 -
0 1 3 Davis 0
n y.edu 01 ce m 5
1 5 2
110
0 4
, F
B Build
S Mar marc Busin Introd Dr. a
55 U ing 202
1 cus us.r@ ess uction I1 Jame ll
5- S D, 4-0
0 Rod univer Admi to 3 0 s 2 B
01 1 Roo 8-1
0 rigu sity.e nistra Busine 4 Wilso 0
02 0 m 6
2 ez du tion ss n 2
1 401
4
E F
Build
S Mar marc Busin C a
55 Princip Dr. ing 202
1 cus us.r@ ess O I1 ll
5- les of Aman D, 4-0 C
0 Rod univer Admi N 3 0 2
01 Econo da Roo 8-1 +
0 rigu sity.e nistra 2 5 0
02 mics Garcia m 6
2 ez du tion 0 2
402
0 4
F
Build
S Mar marc Busin C Datab a
55 Dr. ing 202
1 cus us.r@ ess S ase I1 ll
5- Sarah A, 4-0
0 Rod univer Admi 2 Funda 3 0 2 B
01 Johns Roo 8-1
0 rigu sity.e nistra 0 mental 1 0
02 on m 6
2 ez du tion 1 s 2
301
4
S Sop sophi Introd
55 Dr. F 202
1 hia a.w@ P uction I1 Build
5- Psych Rober a 4-0
0 Will univer S to 3 0 ing A
01 ology t ll 8-1
0 iam sity.e Y Psych 6 E,
03 Taylor 2 7
3 s du 1 ology Roo
0
