Consider the following data report: Sname John Smith Byron Duncan Kirby Address Level CourseNo CourseSection CourseName...

 

Transcribed Image Text:

Consider the following data report: Sname John Smith Byron Duncan Kirby Address Level CourseNo CourseSection CourseName Instructor Grade Phone Columbus, GR COMP630 Q1 Database Todd 1230 OH Aileen Reed Sharon Rodriguez Columbus, GR OH Dublin, UG Macdonald OH Columbus, GR OH Dayton, UG OH COMP501 Q1 ENG500 U1 COMP630 Q1 COMP201 R1 ISEC 200 U1 COMP630 R1 COMP204 R1 Python Database Hardware iii. List all existing functional dependencies. iv. List all FK constraints. Network ISEC 200 U1 a. Identify the primary key and all the functional dependencies. b. Normalize the schema to 3NF. Cybersecurity Todd Database Li Tim Mike Todd c. Explain your process and assumptions. In each step: Tim Cybersecurity Todd Tim BAC A A D A i. Show the complete schema at that level with the primary key(s) identified. ii. Explain what functional dependencies are removed. 2356 5647 1230 2356 1230 9871 2356 1230 Note: You are not allowed to add any new column to the relation (such as a surrogate key to "make the dependencies go away"). You must take one step at a time to normalize to the next NF. Consider the following data report: Sname John Smith Byron Duncan Kirby Address Level CourseNo CourseSection CourseName Instructor Grade Phone Columbus, GR COMP630 Q1 Database Todd 1230 OH Aileen Reed Sharon Rodriguez Columbus, GR OH Dublin, UG Macdonald OH Columbus, GR OH Dayton, UG OH COMP501 Q1 ENG500 U1 COMP630 Q1 COMP201 R1 ISEC 200 U1 COMP630 R1 COMP204 R1 Python Database Hardware iii. List all existing functional dependencies. iv. List all FK constraints. Network ISEC 200 U1 a. Identify the primary key and all the functional dependencies. b. Normalize the schema to 3NF. Cybersecurity Todd Database Li Tim Mike Todd c. Explain your process and assumptions. In each step: Tim Cybersecurity Todd Tim BAC A A D A i. Show the complete schema at that level with the primary key(s) identified. ii. Explain what functional dependencies are removed. 2356 5647 1230 2356 1230 9871 2356 1230 Note: You are not allowed to add any new column to the relation (such as a surrogate key to "make the dependencies go away"). You must take one step at a time to normalize to the next NF.

Answer rating: 100% (QA)

To address the question lets proceed step by step a Identify the primary key and all the functional dependencies To identify the primary key we need to find a combination of attributes that uniquely i... View the full answer