Consider the following relation schema for table R:
R(ENO, CNo, PNo, EName, ERoom, EPhone, CSize, PAmount)
Relation R contains all the information involved in the modeling in respect to employ-
ees, clubs and projects in a company.
Attributes starting with "E" refer to employees, those starting with "C" refer to
clubs, and those with "P" to projects. Employees, clubs and projects are each identi-
fied by their unique numbers.
Names for employees are not generally unique. An employee is allocated with only
one room and phone number, but a room and a phone number can be shared by a
few employees. A room may be associated with a few different phone numbers, but a
phone number is only mapped to a single room.
Each club is characterised by its own size (i.e., the number of employees belonging
to this club). However, multiple clubs may be of the same size.
Each project has an amount of funding associated with it. Yet, multiple projects
may be supported with the same amount of funding.
An employee may be involved in different clubs and different projects. Also, a
club may have multiple employees as its members and a project may involve multiple
employees.
