which are horizontally fragmented on the department number, deptNo. Assume there is an integrity constraint that requires that every member of staff earns less than every manager in the same department. Further assume that we wish to insert the tuple (‘S9100’, ‘John Smith’, ‘1-May-1960’, 30000, ‘D1’) into the Staff relation. Under what conditions can this constraint be checked locally?

Consider the following two relations:
```
Staff (staffNo, name, DOB, salary, deptNo)
Department (deptNo, deptName, managerStaffNo)
```


If a record has previously been inserted that satisfies the constraint, then that can be used as a basis
for a local integrity check. For example, suppose that department D1 already has an employee
S1000 whose salary is £40,000. Given that the constraint has not been violated by the existing
tuple, we know that the salary of every manager in department D1 is more than £40,000.
Therefore, it would be OK to insert a record with salary £30,000.

Computer Science & Information Technology

You might also like to view...

Calculate the cardinality and minimum cost for each of the following Join operations:

? a hash index with no overflow on the primary key attributes, roomNo/hotelNo in Room; ? a clustering index on the foreign key attribute hotelNo in Room; ? a B + -tree index on the price attribute in Room; ? a secondary index on the attribute type in Room. nTuples(Room) = 10000 bFactor(Room) = 200 nTuples(Hotel) = 50 bFactor(Hotel) = 40 nTuples(Booking) = 100000 bFactor(Booking) = 60 nDistinct hotelNo (Room) = 50 nDistinct type (Room) = 10 nDistinct price (Room) = 500 min price (Room) = 200 max price (Room) = 50 nLevels hotelNo (I) = 2 nLevels type (I) = 2 nLevels price (I) = 2 nLfBlocks price (I) = 50 J1: Hotel hotelNo Room Assume nBuffer = 100 J2: Hotel hotelNo Booking J3: Room roomNo Booking J4: Room hotelNo Hotel J6: Booking roomNo Room

Computer Science & Information Technology

PowerPoint presentations are saved with a(n) .pptn file extension.

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

Computer Science & Information Technology

?When a slide is created from a Word outline, PowerPoint uses the heading styles in the Word document to determine how to format the text in the slide.

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

Computer Science & Information Technology

The accompanying figure contains code that styles normal links, and links will be displayed in _____.

A. gray B. yellow C. blue D. red

Computer Science & Information Technology