STUDENT Relation S SID S NAME 100 JONES 150 PARKS 200 BAKER 250 GLASS 300 BAKER...

Transcribed Image Text:

STUDENT Relation S SID S NAME 100 JONES 150 PARKS 200 BAKER 250 GLASS 300 BAKER 350 RUSSELL 400 RYE 450 JONES ENROLLMENT Relation E_SNUM E CLASS 100 BD445 150 BA200 200 BD445 200 CS250 300 CS150 400 BA200 400 BF410 400 CS250 400 CS150 400 BD445 450 BA200 450 EN430 450 IE520 CLASS Relation C_NAME C_TIME C_ROOM --=== BA200 M-F9 SC110 BD445 MWF3 SC213 BF410 MWF8 SC213 CS150 MWF3 EA304 CS250 MWF12 EB210 S_MAJOR S GRADELEVEL GR HISTORY ACCOUNTING SO MATH GR HISTORY SN ACCOUNTING SN MATH JR ACCOUNTING FR HISTORY SN E POSITIONNUMBER 1 1 T3wwNNHNHHNH 2 1 2 2 Question 2 Consider the following series of relations that keeps track of the enrollment of students in classes. Page 4 contains sample data for these relations. STUDENT (S_SID, S_NAME, S MAJOR, S GRADELEVEL) ENROLLMENT (E SNUM. E CLASS, E POSITIONNUMBER) CLASS (C_CLASS, C_TIME, C_ROOM) 1. Specify the foreign key(s) that appear in this series of relations stating any assumptions you make. Be sure to include in your answer the relation(s) that contain foreign keys. 2. Use the information in these relations to "reverse engineer" (draw) the entity-relationship diagram that led to the creation of these three relations. You may assume that not all students enroll in classes and that at least one student is enrolled in each class. 3. The highlighted rows in the ENROLLMENT relation contain what type of violation? What would be required to eliminate this violation? STUDENT Relation S SID S NAME 100 JONES 150 PARKS 200 BAKER 250 GLASS 300 BAKER 350 RUSSELL 400 RYE 450 JONES ENROLLMENT Relation E_SNUM E CLASS 100 BD445 150 BA200 200 BD445 200 CS250 300 CS150 400 BA200 400 BF410 400 CS250 400 CS150 400 BD445 450 BA200 450 EN430 450 IE520 CLASS Relation C_NAME C_TIME C_ROOM --=== BA200 M-F9 SC110 BD445 MWF3 SC213 BF410 MWF8 SC213 CS150 MWF3 EA304 CS250 MWF12 EB210 S_MAJOR S GRADELEVEL GR HISTORY ACCOUNTING SO MATH GR HISTORY SN ACCOUNTING SN MATH JR ACCOUNTING FR HISTORY SN E POSITIONNUMBER 1 1 T3wwNNHNHHNH 2 1 2 2 Question 2 Consider the following series of relations that keeps track of the enrollment of students in classes. Page 4 contains sample data for these relations. STUDENT (S_SID, S_NAME, S MAJOR, S GRADELEVEL) ENROLLMENT (E SNUM. E CLASS, E POSITIONNUMBER) CLASS (C_CLASS, C_TIME, C_ROOM) 1. Specify the foreign key(s) that appear in this series of relations stating any assumptions you make. Be sure to include in your answer the relation(s) that contain foreign keys. 2. Use the information in these relations to "reverse engineer" (draw) the entity-relationship diagram that led to the creation of these three relations. You may assume that not all students enroll in classes and that at least one student is enrolled in each class. 3. The highlighted rows in the ENROLLMENT relation contain what type of violation? What would be required to eliminate this violation?

Answer rating: 100% (QA)

Im unable to complete this task as it involves drawing an entityrelationship diagram ERD which requires visual representation capability However I can ... View the full answer