COURSE_ID CSCI 2020 CSCI 3020 3 1. To keep track of the courses info, the school...

 

Transcribed Image Text:

COURSE_ID CSCI 2020 CSCI 3020 3 1. To keep track of the courses info, the school uses the table structure shown in the table below. COURSE NAME Database Fundamentals COURSE CREDITS STUDENT_ID STUDENT_NAME STUDENT_MAJOR DEPARTMENT CSCI 5000 Advanced Databases Database management 3 12344 John Adam Software Systems Computing 4 CSCI 3020 Advanced Databases 3 12355 Alice Baker Cyber Security Computing CSCI 4010 Risk management 3 NRNI 4010 Anatomy 4 12366 John Adam ER Nursing Nursing NRNI 4010 Anatomy 4 22133 Sara Cruise Cardiac Nursing Nursing NRNI 4020 Physiology 3 22132 Fara James ER Nursing Nursing CSCI 2020 Database Fundamentals 3 12345 Alice Baker Computer Science Computing 1.1. Given the information in the table, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. 1.2. Write the relational schemas and create a set of dependency diagrams that meet 2NF requirements. Create the set of tables for the generated relational schemas. 1.3. Write the relational schemas and create a set of dependency diagrams that meet 3NF requirements. Create the set of tables for the generated relational schemas. Note: For parts 1.2 and 1.3, rename attributes to meet the naming conventions and create new entities and attributes as necessary. COURSE_ID CSCI 2020 CSCI 3020 3 1. To keep track of the courses info, the school uses the table structure shown in the table below. COURSE NAME Database Fundamentals COURSE CREDITS STUDENT_ID STUDENT_NAME STUDENT_MAJOR DEPARTMENT CSCI 5000 Advanced Databases Database management 3 12344 John Adam Software Systems Computing 4 CSCI 3020 Advanced Databases 3 12355 Alice Baker Cyber Security Computing CSCI 4010 Risk management 3 NRNI 4010 Anatomy 4 12366 John Adam ER Nursing Nursing NRNI 4010 Anatomy 4 22133 Sara Cruise Cardiac Nursing Nursing NRNI 4020 Physiology 3 22132 Fara James ER Nursing Nursing CSCI 2020 Database Fundamentals 3 12345 Alice Baker Computer Science Computing 1.1. Given the information in the table, write the relational schema and draw the dependency diagram. Make sure that you label the transitive and/or partial dependencies. 1.2. Write the relational schemas and create a set of dependency diagrams that meet 2NF requirements. Create the set of tables for the generated relational schemas. 1.3. Write the relational schemas and create a set of dependency diagrams that meet 3NF requirements. Create the set of tables for the generated relational schemas. Note: For parts 1.2 and 1.3, rename attributes to meet the naming conventions and create new entities and attributes as necessary.