A Project management company approached your IT company for a system to keep track of their...

Transcribed Image Text:

A Project management company approached your IT company for a system to keep track of their projects. It is possible for an employee to work on more than one project. Each employee will have only one job title, e.g., System analyst, Project manager, Programmer etc. The company will be working on many projects at the same time. Each project will have only one client. Each project must be managed by only one Project manager. Adjusted from Source: Coronel, C., Morris, S. & Rob, P. 2011. Database principles: Fundamentals of design, implementation, and management. Cengage leaming p 190. 5.1 Create a class diagram to keep track of their projects. Indicate possible attributes. operations, relationship names and multiplicities. (20 Marks) 5.2 Employees can be classified as part time, full-time, or contract employees. Illustrate with a diagram how this can be implemented with generalisation. (5 Marks) A Project management company approached your IT company for a system to keep track of their projects. It is possible for an employee to work on more than one project. Each employee will have only one job title, e.g., System analyst, Project manager, Programmer etc. The company will be working on many projects at the same time. Each project will have only one client. Each project must be managed by only one Project manager. Adjusted from Source: Coronel, C., Morris, S. & Rob, P. 2011. Database principles: Fundamentals of design, implementation, and management. Cengage leaming p 190. 5.1 Create a class diagram to keep track of their projects. Indicate possible attributes. operations, relationship names and multiplicities. (20 Marks) 5.2 Employees can be classified as part time, full-time, or contract employees. Illustrate with a diagram how this can be implemented with generalisation. (5 Marks)