Normalize the relational database schema develop for exercise 4.6

131 MainFac department Art CSC CSC FIGURE 4.6A) Relations MainFac and BranchFac Adams Professor Instructor Professor F101 Tanaka F221Smith BranchFac nane Adams department Id rank Professor Assistant Associate Professor Art F101 110 F115 F221 0 Byrne Math Smith History Smith CSC MainFac UNION BranchFac FIGURE 4.6(B) MainFac UNION BranchFac facld name F101 F105 F110 F115 Adams Tanaka C Byrne Smith Smith department rank Art CSc Math History CSC Professor Instructor Assistant Associate Professor F221 FIGURE 4.6(C) MainFac INTERSECTION BranchFac MainFac INTERSECTION BranchFac acid F101 F221 name Adams Smith department rank Art CSC Professor Professor