expand icon
book Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe cover

Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

Edition 6ISBN: 0136086209
book Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe cover

Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

Edition 6ISBN: 0136086209
Exercise 7
  -Consider Figure 1.2.  a. If the name of the 'CS' (Computer Science) Department changes to 'CSSE' (Computer Science and Software Engineering) Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be updated. b. Can you restructure the columns in COURSE, SECTION, and PREREQUISITE tables so that only one column will need to be updated?
-Consider Figure 1.2.
a. If the name of the 'CS' (Computer Science) Department changes to 'CSSE' (Computer Science and Software Engineering) Department and the corresponding prefix for the course number also changes, identify the columns in the database that would need to be updated.
b. Can you restructure the columns in COURSE, SECTION, and PREREQUISITE tables so that only one column will need to be updated?
Explanation
Verified
like image
like image

a. The following columns will need to be...

close menu
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
cross icon