Consider the relation shown in Figure 24.2 (d). How would it appear to a user with classification U? Suppose a classification U user tries to update the salary of "Smith" to $50,000; what would be the result of this action?

What will be an ideal response?


EMPLOYEE would appear to users within classification U as follows:
NAME SALARY JobPerformance TC
Smith U null U null U U
If a classification U user tried to update the salary of Smith to $50,000, a third
polyinstantiation of Smith's tuple would result as follows:
NAME SALARY JobPerformance TC
Smith U 40000 C Fair S S
Smith U 40000 C Excellent C C
Smith U 50000 U null U U
Brown C 80000 S Good C S

Computer Science & Information Technology

You might also like to view...

When PowerPoint opens, it displays a default template presentation.

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

Computer Science & Information Technology

Although photos can be edited using paint software like the kind shown in the accompanying figure, photo editing software typically provides tools that simplify common editing photo editing tasks.

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

Computer Science & Information Technology

A blank document with no text may have several Styles applied to it

Indicate whether the statement is true or false

Computer Science & Information Technology

The use of function ____________________ permits the compiler to error-check data types.

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

Computer Science & Information Technology