Database Foundations

Exercise 2: Normalize Academic Database ERD Overview In this practice, you use un-normalized database models to create normalized database models. Tasks 1. For the Academic Database ERD, evaluate each entity against the rules of normalization, identify the misplaced attrbutes, and explain which rule of normalization each misplaced attribute violates PARENT INFORMATION * Parent 1 First Name * Parent 1 Last Name o Parent 2 First Name o Parent 2 Last Name ACADEMIC SESSION #ID * Name STUDENT #ID - First Name Last Name * Registration Year Email * Number of Working Days * Number of Days Of o Eligibility for Exam che be STUDENT COURSE DETAIL Grade EXAM RESULT * Grade have ber COURSE #ID * Name DEPARTMENT #ID * Name * Head belor 1 host EXAM #ID ONLINE #Logon ID * Password SEATED # Building # Room # Date/Time o Start Date o Description * Type * Name FACULTY #10 *First Name Last Name * Email Login Date "Login Time o Detals FACULTY COURSE DETAIL Contact Hours FULL TIME salary insurance plan PART TIME hourly rate