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?

Computer Science & Information Technology

You might also like to view...

A probability distribution takes on the shape of a bell and is often referred to as the ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

Which of the following can affect electrostatic discharge in a network operations center?

A. Fire suppression B. Environmental monitoring C. Proximity card access D. Humidity controls

Computer Science & Information Technology