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...

The item marked 3 in the accompanying figure is the ____ bar.

a. options b. Tools c. status d. menu

Computer Science & Information Technology

Tiny charts that are embedded in cells are called ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

An entry in a field can be used to initiate the execution of a macro.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

The ____ file system can recover from all types of errors including those that occur in critical disk sectors.

A. FAT B. NTFS C. CDFS D. NFST

Computer Science & Information Technology