4. Consider the following relation: Assume each student is assigned an advisor from a department. Each classroom is assi

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

4. Consider the following relation: Assume each student is assigned an advisor from a department. Each classroom is assi

Post by answerhappygod »

4 Consider The Following Relation Assume Each Student Is Assigned An Advisor From A Department Each Classroom Is Assi 1
4 Consider The Following Relation Assume Each Student Is Assigned An Advisor From A Department Each Classroom Is Assi 1 (94.65 KiB) Viewed 27 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”