TEST BANK FOR DATABASE SYSTEMS AN APPLICATION ORIENTED APPROACH 2ND EDITION BY Michael Kifer, Arthur Bernstein, Philip M. Lewis Converted

Design the following two tables (in addition to that in Figure 2.1) that might be used in the Student Registration System. Note that the same student Id might appear in many rows of each of these tables. a. A table implementing the relation CoursesRegisteredFor, relating a student’s Id and the identifying numbers of the courses for which she is registered Solution: Id CrsCode CSE515 CSE505 CSE532 CSE532 CSE541 CSE504 CSE504 CSE515 CSE505 b. A table implementing the rel...