1. b. Can you restructure the columns in this database - without adding or deleting any tables, so that to minimize the number of changes that cascade throughout the tables when such a renaming of a department occurs? Explain how to restructure (if you answered Yes) or why restructuring is not possible (if you answered No).

Can columns be restructured (Yes/No)? _____

If Yes -- explain all changes to each of the tables in the db:

If No -- explain why restructuring is not possible:

2) (10 points) Consider the relational database in the figure below and answer the following questions: STUDENT GRADE_REPORT Namo Student_number Major Student_number Smith 17 1 CS Brown 8 CS Class Grade Section_identifier 112 B 17 17 2 8 119 85 92 A 8 A B 8 102 135 8 4 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course_number Credit_hours Department CS1310 cs CS3320 4 CS MATH2410 3 MATH CS3380 3 CS PREREQUISITE Course_number CS3380 CS3380 CS3320 Prerequisite_number CS3320 MATH2410 CS1310 Year 07 07 SECTION Section_identifier Course_number Semester 85 MATH2410 Fall 92 CS1310 Fall 102 CS3320 Spring 112 MATH2410 Fall 119 CS1310 Fall 135 CS3380 Fall 08 Instructor King Anderson Knuth Chang Anderson Stone OB OB 08 a) (5 points) Assume that the identification code for the CS' (Computer Science) Department changes to 'CSSE' (Computer Science and Software Engineering Department and the corresponding prefix for the course numbers also changes (for example, CS1310 changes to CSSE1310). Identify all the columns in the database that would need to be updated; indicate below the table name and the column name for each column affected by the change. Table Columns Add as many rows as necessary to answer the