“Sky” construction is a leading private sector construction company. The senior management of
the company decided to create a web desktop based project management system to improve their work
Each branch of the Sky construction owns details such as a unique name, identification code,
telephone number address, email etc... The employee who manages the branch is separately
captured along with his/her start date when that employee began managing the branch. A numbers
of projects are being controlled by each branch manager. Only the branch managers have the
authority to initiate work of a new project. Each project has a project name for direct identification
purpose apart from relevant project related details. Also the system should maintain employee
details such as name, address, DOB, salary, contact details, work experience, qualifications, job
role etc... Employees are allowed view only their profile, but manager can view profiles of all the
employees in his/her branch.
Normally an employee is assigned to one branch, but they can work in many projects. System
should have a facility to trace the number of hours employees work on a given project. Additionally
the system maintains employee dependent information as well, for insurance purpose. System will
capture dependent’s name, DOB & relationship to the employee. Each employee can insure
maximum up to three dependents.
Provide a well-designed, user friendly system addressing the following features:
● System should have differential access rights to the system users.
● Interactive user friendly interfaces
● Clear implementation of the business flow via the system.
● Design & implement suitable sets of reports, which you think will add more value to the
● Use test driven development and include test classes to test your application
You are free to make necessary assumption on system design & granting access permissions
other than mentioned within the scenario, but all suggestions must be well explained with the
You can add any functionality which will enhance the system and make the proposed
solution more comprehensive.
Use Harvard referencing to properly acknowledge all the external sources you use.