COMP1690 Component Programming Assignment.

Part A -

With the help of the tutor, organise yourselves into groups consisting of 2 students to engage in pair programming.

Implementation - As a team you are required to:

Design/implement a database which meets the requirements of the case-study described above.

You can use any relational database management system you wish (e.g. JavaDB, SQLServer, MySQL, Oracle, Access, etc.). The database should be normalised and use primary key and foreign key constraints.

Create a set of entity/model classes which reflect entities from the database. Feel free to use LINQ or Entity Framework, if you wish.

Implement a desktop application using C#, which offers the following functionality to admin users:

- User log in

- User management enabling an admin user to create/edit/delete employees. It must be possible to allocate an employee to a department and assign him/her a role.

Group report section - The group report section should contain the design documentation that you created as a group, which should contain an Entity Relationship Diagram outlining the database structure and an architecture diagram which shows the overall setup of the system. This should be prepared by the group and each member then includes the same diagrams in their final report (unless you make further modifications during the individual phase of the assessment).