QUESTION $1$

$(8$OMARKS$)$

$1\mathrm{.}1$ What are the six phases of the Database Analysis Lifecycle and what are the activities that occur in each phase?

$(10)$

$1\mathrm{.}2$ Consider the table below,

Convert the report into a set of BCNF tables. Describe each step in detall and show the relational schema associated with each step.

$(20)$

$\backslash$table$[[$EMP NUM,EMP FNAME,EMP LNAME,,,,,,$],[200,$Luke,Shaw,$\backslash$table$[[$JOB$\_$DEsc$],[$Manager$]],\backslash$table$[[$BENEFIT $1],[$Companyy$],[$Car$]],\backslash$table$[[$BENEFIT$\_?],[$Medical$],[$Aid$]],\backslash$table$[[$BENEFII$\_3],[13$th$],[$Cheque$]],($ PRO$]ID,\backslash$table$[[$PROJFGT$],[$Suo Zero$]]],[200,$Luke,Shaw,Manager,$\backslash$table$[[$Company$],[$Car$]],\backslash$table$[[$Medical$],[$Ald$]],\backslash$table$[[13$ th$],[$Cheque$]],555,$Scorpion$],[300,$Matthew,Matthews,Marketing,$\backslash$table$[[$Company$],[$Car$]],,,445,$Sub Zero$],[500,$John,Staples,Marketing,$\backslash$table$[[$Company$],[$Car$]],,,445,$Sub Zero$],[600,$Samuel,Jackson.,Accountant,,,$\backslash$table$[[13$th$],[$Cheque$]],445,$Sub Zero$],[600,$Samuel,Jackson,Accountant,,,$\backslash$table$[[13$th$],[$Cheque$]],555,$Scerpion$]]$

QUESTION $2$

$(30$ MARKS$)$

$2\mathrm{.}1$ XYZ Corporation, an IT and Digital media company is restructuring their organisation, part of which includes redesigning their database into a relational database. You have been tasked with redesigning the new database. You have been given the following business rules, a manager can be a project manager or project lead. A project manager oversees a department, a project lead oversees a project. An employee can be a programmer or designer. A programmer must be front$-$end or back$-$end or both. A designer must always have a project they are working on$.$

Draw the EERD for XYZ corporation and include all the necessary attributes.

$(30$ MARKS$)$