Q1. Think of different users for the database shown in Figure 1. What types of applications would each user need? To which user category would each belong, and what type of interface would each need? STUDENT Name Student number Class Major Smith 17 1 CS Brown 8 2 CS COURSE Course name Course number Credit hours Department Intro to Computer Sci CS1310 4 CS Data Structures CS3320 4 Discrete Maths MATH2410 3 MATH Database CP-363 3 CS CS SECTION Section identifier 85 92 102 112 119 135 Course number MATH2410 CS1310 CS3320 MATH2410 CS1310 CP-363 Semester Fall Fall Spring Fall Fall Fall Year 07 07 08 08 08 08 Instructor King Anderson Knuth Chang Anderson Syed GRADE REPORT Student number Section identifier 17 112 17 119 8 85 8 92 8 102 8 135 Grade B A A B A PREREQUISITE Course_number CP-363 CP-363 CS3320 Prerequisite number CS3320 MATH2410 CS1310 Figure 1. A database that stores student and course information. Q2. Consider Figure 2 below. In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values in a column or a combination of columns within a table. One such constraint dictates that a column or a group of columns must be unique across all rows in the table. For example, in the STUDENT table, the Student_number column must be unique (to prevent two different students from having the same Student_number). Identify the column or the group of columns in the other tables that must be unique across all rows in the table. STUDENT Name Student_number Class Major COURSE Course_name Course_number Credit_hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section identifier Course number Semester Year Instructor GRADE REPORT Student number Section identifier Grade Figure 2. Schema diagram for the database in Figure 1 (of Q1). Q3. If you were designing a web-based system to make airline reservations and sell airline tickets, which DBMS architecture (Centralized. Distributed, etc. (see slides Lecture # 2, Section 2.5 of text)) would you choose. Why? Why would the other architectures not be a good choice