a) Choose a database application with which you are familiar. Design a schema and show a sample database for that application, using the notation of Figure 1 and Figure 2. b) Write SQL update statements to do the following on the database schema shown in Figure 1. i. Insert a new student, <‘Johnson’, 25, 1, ‘Math’>, in the database. ii. Change the class of student ‘Smith’ to 2. 09:04 - PA Iall 16 all 2STUDENTName udentumber17CaasMajorSmithCSBrownCSCOURSECoure namCars tunberCrud eur Departnartt Computer ScenceCSI310CSDuta StractuDiscreta MathematiceDatabasecsaa30CsMATH10MATHSECTIONSection identer Cour unber SenadrImatrucorMATHI410Fall07King92CS1310Fll07AndersonC83320SpringKnuth112MATH2410Fal00Chang119CS1310FallAnderaon135CS3380FallStoneGRADE REPORTShudent merSection identiferGrade1711217110102136PREREQUISITECourse umbehenquate unberCS3320CS380C83380MATH2410Cs1310CS3320Figure 2: A database that stores student and course information.Question 1a) If you were designing a Web-baIsed system to make airline reservations and sell airlinetickets, which DBMS architectue would you choose and why? Why would the otherarchitectures not he a good choice?BlontnsDesignationMajur TupieSenreData ModelII 09:04 - P A ICS312 KCC WKND_MTE Q_MARCH2022 (1).pdfTHREE QUESTIONS ANSWER TWOSTUDENTName Student number Class MajorCOURSECourse name Course number Credit hours DepartmentPREREQUISITECourne number Proroquieite numberSECTIONSection identifer Course number Samester Yoar InatructorGRADE REPORTStudent_number Section identilier GradeFigure 1: Schema diagram for the database shown aboveSTUDENTNameStudentunbter17ClussMajorSmihBrownCSCOURSECourse umeru to Computer ScienceData StructurDiacrete MuthaaticaCoun umber Credt houns DepartmentCSI310CSesCS10CSMATH2410MATHDatataseCS3380SECTIONQFullscreenSearch

Given information, Given a schema diagram and sample database in Figure 1 and Figure 2. It is…

Answered: a) Choose a database application with…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

a) Choose a database application with which you are familiar. Design a schema and show a sample database for that application, using the notation of Figure 1 and Figure 2.

b) Write SQL update statements to do the following on the database schema shown in Figure 1.
i. Insert a new student, <‘Johnson’, 25, 1, ‘Math’>, in the database.
ii. Change the class of student ‘Smith’ to 2.