Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

 

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Programming questions

Question

Trace the use of the transaction log in database recovery.

Answered: 1 week ago