Each monograph has a unique ISBN as well as a title and a publication date. Multi-author monographs have an editing author and one or more contributing authors, each related through the title of the contribution. All authors are identified by name and have a email address and Web home page. Problem 2 A company has projects that are performed, Each project, identified by its codename, has a number of employees working on it, Each employee, identified by id and having a name and number of years for which they have worked for the company, can be assigned to multiple projects, with each assignment having a certain percentage of employee effort indicated. Each subcontract is for a fixed amount of money and a fixed time period.
All employees have an employee number and name.
Clerical employees additionally have a hourly wage. Application programmers are assigned to a functional area of the company, and the date of that assignment is maintained. Systems programmers are not assigned to any functional area, but are assigned to a specific mainframe computer, identified by its serial number.