Page 1 of 1
4. Consider the following relation: Assume each student is assigned an advisor from a department. Each classroom is assi
Posted: Tue Jul 12, 2022 8:15 am
by answerhappygod
- 4 Consider The Following Relation Assume Each Student Is Assigned An Advisor From A Department Each Classroom Is Assi 1 (94.65 KiB) Viewed 28 times
4. Consider the following relation: Assume each student is assigned an advisor from a department. Each classroom is assigned a classroom. (Student#, Class#) is the primary key to this relation. Is this relation in 2NF? Is it in 3NF? Decompose it into 2NF then 3NF when necessary. Student# Class# | Classroom Advisor Advisor-office Department 101-07 WIL230 Jones 201-02 OVR212 Jones 310-11 WIL224 Jones 101-07 WIL230 201-02 OVR212 120-12 WIL306 1011 1011 1011 2010 2010 2010 212 212 212 Anderson 308 Anderson 308 Anderson 308 CSCI CSCI CSCI MATH MATH MATH