$34$ Part $1$ Database Concepts

$11.$ Using your school's student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name, class credit hours, class instructor name, the class meeting days and times, and the class room number. Use Figure P$1\mathrm{.}11$ as a template to complete the following actions.

FIGURE P$1\mathrm{.}11$ STUDENT SCHEDULE DATA FORMAT

$\backslash$table$[[$STU$\_$ID$,\backslash$table$[[$STU$\_],[$NAME$]],\backslash$table$[[$CLASS$\_],[$CODE$]],\backslash$table$[[$CLASS$\_],[$NAME$]],\backslash$table$[[$CLASS$\_],[$CREDHRS$]],\backslash$table$[[$INSTR$\_],[$NAME$]],\backslash$table$[[$CLASS$\_],[$DAYS$]],\backslash$table$[[$CLASS$\_],[$TIMES$]],$ROOM$]]$

a$.$ Create a spreadsheet using the template shown in Figure P$1\mathrm{.}11$ and enter your current class schedule.

b$.$ Enter the class schedule of two of your classmates into the same spreadsheet.

c$.$ Discuss the redundancies and anomalies caused by this design.