Exercise: Student Grades You are working an on application to store student data for the several departments in the College of Engineering. Based on the data in the following table CID CPS196 CECS B- EPS114 EE Dept grade SID 142 142 123 857 857 456 217 email bart@fox.com bart@fox.com name Bart Bart Milhouse milhouse@fox.com CPS196 CECS B+ Lisa Lisa Ralph Maggie lisa@fox.com lisa@fox.com ralph@fox.com Maggie@fox.com C CPS196 CECS A+ MPS130 ME EPS114 EE CPS196 CECS B- Draw the relation scheme for this table as it is shown above. Identify the primary key Draw the relation scheme for a lossless join decomposition of this table Exercise: Student Grades You are working an on application to store student data for the several departments in the College of Engineering. Based on the data in the following table CID CPS196 CECS B- EPS114 EE Dept grade SID 142 142 123 857 857 456 217 email bart@fox.com bart@fox.com name Bart Bart Milhouse milhouse@fox.com CPS196 CECS B+ Lisa Lisa Ralph Maggie lisa@fox.com lisa@fox.com ralph@fox.com Maggie@fox.com C CPS196 CECS A+ MPS130 ME EPS114 EE CPS196 CECS B- Draw the relation scheme for this table as it is shown above. Identify the primary key Draw the relation scheme for a lossless join decomposition of this table