Q1. [ 50 points) Given an example database that stores students and course information (Fig. 1.2 from the book). (a) [ 10 points) Write at least FIVE advantages of using database systems for any industry employees? (b) (10 points) If the name of the 'CS' (Computer Science) Department changes to 'CIS' (Computer Information Systems) Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be updated, and fill-up the table below: Table Column(s) STUDENT COURSE SECTION PREREQUISITE! (c) [ 10 points] Can you restructure/split the columns in COURSE, SECTION, and PREREQUISITE tables so that only one column will need to be updated? Table Column Split Columns COURSE SECTION PREREQUISITE (d) [ 10 points] Can we consider additional users (example Resister Office User, Admission Office user Transcript office users), can use this database? Explain your answer. (e) [ 10 points) In the fig 1.2, Identify the column or the group of columns that must be unique across all rows in the table? Explain your answer. Student number Class Name Smith Brown 17 1 Major CS CS B 2 4 COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Courso_number Credit_hours Departmen CS1310 CS3320 MATH2410 3 MATH CS3380 3 188 4 13 SECTION Section identifier Course_number Semester 85 MATH2410 Fall 92 CS1310 Fall 102 CS3320 Spring 112 MATH2410 Fall 119 CS1310 Fall 135 CS3380 Fall Year 07 07 08 08 08 08 Instructor King Anderson Knuth Chang Anderson Stone GRADE REPORT Student_number Section_identifier Grade 17 112 17 119 85 00