a) If you were designing a Web-based system to make airline reservations and sell airline tickets, which DBMS architecture would you choose and why? Why would the other architectures not be a good choice? b) Specify all the relationships among the records of the database shown in Figure 1. c) Discuss the differences between the candidate keys and the primary key of a relation. d) Write SQL update statements to do the following on the database schema shown in Figure 1.i. Insert a new course, <‘Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>.ii. Delete the record for the student whose name is ‘Smith’ and whose student number is 17. STUDENTStudent_numberMajorCSNameClassSmith17Brown82CSCOURSECourse_nameIntro to Computer ScienceData StructuresDiscrete MathematicsDatabaseCourse_number Credit_hours DepartmentCS1310CS33204CS4CSМАТН24103MATHCS33803CSSECTIONSection_identifier Course_number SemesterMATH2410YearInstructor85Fall07King92CS1310Fall07Anderson102CS3320Spring08Knuth112MATH2410Fall08Chang119CS1310Fall08Anderson135CS3380Fall08Stone GRADE REPORTStudent_numberSection_identifierGrade17112B1711985A92A102B135APREREQUISITECourse_numberPrerequisite_numberCS3320CS3380CS3380МАТН2410CS3320CS1310Figure 1: A database that stores student and course information.

According to the question, we have to explain If we were designing a Web-based system to make…

Answered: a) If you were designing a Web-based…

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) If you were designing a Web-based system to make airline reservations and sell airline
tickets, which DBMS architecture would you choose and why? Why would the other
architectures not be a good choice?

b) Specify all the relationships among the records of the database shown in Figure 1.

c) Discuss the differences between the candidate keys and the primary key of a relation.

d) Write SQL update statements to do the following on the database schema shown in
Figure 1.
i. Insert a new course, <‘Knowledge Engineering’, ‘CS4390’, 3, ‘CS’>.
ii. Delete the record for the student whose name is ‘Smith’ and whose student
number is 17.