1. If you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose from Section 2.5 of your textbook? Why? Why would the other architectures not be a good choice? 2. Write SQL update statements to do the following on the database schema shown in Figure 1.2. (Chapter 1) of your textbook. a. Insert a new student <'Johnson', 25, 1, 'MATH'> in the database. b. Change the class of student 'Smith' to 2. c. Insert a new course <'Knowledge Engineering','COSC4390', 3,'COSC'>. d. Delete the record for the student whose name is 'Smith' and student number is 17. 3. Discuss the naming conventions used for ER schema Diagrams. 4. Discuss the concept of Polymorphism/Operator Overloading. 5. Consider the ER diagram in Figure 7.23 of your textbook. Assume that a course may or may not use a textbook, but that a text by definition is a book that is used in some course. A course may not use more than five books. Instructors teach from two to four courses. Supply (min, max) constraints on this diagram. State clearly any additional assumptions you make. If we add the relationship ADOPTS between INSTRUCTOR and TEXT, what (min, max) constraints would you put on it? Draw the diagram with the min/max constraints.