Consider the UNIVERSITY EER schema of Figure 8.10. Write some rules (in English) that could be implemented via active rules to enforce some common integrity constraints that you think are relevant to this application.

What will be an ideal response?


RULE 1: Every time a graduate student receives a grade of C of lower, notify his or
her advisor.
RULE 2: When a faculty member becomes a department chair, raise her or his salary
15%.
RULE 3: If a student changes his or her major, delete all of his or her minors, and
notify the student to sign up for minors again.

Computer Science & Information Technology

You might also like to view...

In the Table Properties dialog box, you can set a border width and color, but if you want to specify a border type or create a border that appears on just one side, you need to use the Modify Table dialog box.

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

Computer Science & Information Technology

An encoded set of video data is known as a(n) ____.

A. encoding B. stream C. container D. plugin

Computer Science & Information Technology

A downloadable program that extends the functionality of a mobile device.

What will be an ideal response?

Computer Science & Information Technology

In the figure above, which number points to the text box that will hold the link to the page that will be displayed when the hotspot is clicked?

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology