AdvNum StuNum AdvName AdvOffice StuName StuMajor S101 P100 T. Jones 10-110A G. White CIS S101 P105 T. Jones 10-110A J. B

[answerhappygod]

AdvNum StuNum AdvName AdvOffice StuName StuMajorS101 P100 T. Jones 10-110A G. White CISS101 P105 T. Jones 10-110A J. Bell MATHA264 P108 M. Thomas 10-110B I. McKay ENGA264 P110 M. Thomas 10-110B P. Wax CISV555 P105 R. Brown 10-111A J. Bell MATHV555 P110 R. Brown 10-111A P. Wax CIS
CIS 2165 - Database ManagementQuestion 4Convert the table from Question 3 above and convert into a set oftables in third normal form.Draw an entity-relationship diagram of your database design anddocument the fields for yourtables using DBDL format. It is safe to assume this is similar toChapter 6 question.