$(25$ pts$)$ Consider the image below:

$(5$ pts$)$ If the name of the $\text{'}$CS$\text{'}($Computer Science$)$ Department changes to 'CSSE' $($Computer Science and Software Engineering$)$ Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be updated.

$(10$ pts$)$ Specify the relationships among the records of the database shown in the image below.

$(10$ pts$)$ Retrieve the transcript of all courses and grades of Brown.