X hits on this document

Word document

For the exam you should be able to - page 5 / 11

41 views

0 shares

0 downloads

0 comments

5 / 11

4.

An employee must always have a lower salary than his/her manager(s). There may be more than one manger if the employee works in more than one department.

5.

Whenever an employee is given a raise, the manager's salary must be increased to be at least that much (if, an only if it, is less than the employee's new salary amount). Furthermore, whenever an employee is given a raise, the department's budget must be increased to be greater than the sum of all salaries of all employees in the department. In particular, it should be made 1000 greater than the sum of all salaries in the department.

5. The Hollywood database contains the following entities and relationships:

ENTITIES:

critic Attributes: 1. cId (char) : The unique id to identify a critic. 2. cName(char) : The name of the critic.

filmProject Attributes: 1. filmId (char) : The unique id to identify a film project. 2. title (char) : The name of the film project.

movieStar Attributes : 1. starId (char) : The unique id to identify a movie star. 2. starName (char) : The name of the movie star.

Document info
Document views41
Page views41
Page last viewedSat Dec 10 21:24:23 UTC 2016
Pages11
Paragraphs265
Words2948

Comments