Normalization in database

Anonymous
timer Asked: Jan 21st, 2021

Question Description

I'm working on a databases question and need support to help me learn.

Normalize the attached file to the third normal form.

Show all functional dependencies and show all the tables and records at each normal form.

Unformatted Attachment Preview

Examination Part II Table showing staff of a company and the project they are working on STID S1 S2 S1 S3 S4 S3 S4 NAME KOBINA THOMAS KOBINA SAMPSOM JOYCE SAMPSON JOYCE BCODE B1 B1 B1 B2 B2 B2 B2 DCODE D3 D1 D3 D2 D3 D2 D3 B_NAME KINGS KINGS KINGS CITY CITY CITY CITY DNAME COMP. SCI. ENGINEERING COMP. SCI. INFO. SYS. COMP. SCI. INFO. SYS. COMP. SCI. B_MAN MENSAH MENSAH MENSAH ATO ATO ATO ATO HOD FRANK FRED FRANK BUABIN FRANK BUABIN FRANK PRO P1 P1 P3 P3 P2 P2 P1 PRO_NAME EDUPORTAL EDUPORTAL DEPT. WEBSITE DEPT. WEBSITE E - CAMPUS E - CAMPUS EDUPORTAL PRO_HEAD HRS_WRK RON 38 RON 56 EDEM 24 EDEM 49 JANE 54 JANE 36 RON 71 Normalize the table above to the third normal form. Show all functional dependencies and show all the tables and records at each normal form. SOLUTION To qualify for third normal form: • The data must be in Second Normal Form • A relation has no transitive functional dependencies on the primary key • There is no other non-key attribute that you would need to change in table if you changed a non-key attribute ...
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors