Question Two

The following human resources $($personnel$)$ data has been provided to you to analyse and

store by the Ferris Companvy

Martin P Adams, DoB; $4/5/1976,$ Personal Public Service Number $($PPSN$)$:

$876532A,$ started $\frac{5}{6}\frac{?}{2001},$ pay $7$ euros$/$hour

Dorothy Burke, DoB; $12/8/1979,$ Personal Public Service Number: $235149$C$,$

started $7/9/2001,$ pay $6\mathrm{.}50$ euros$/$hour

Noel Bourke DoB; $5/8/1969,$ Personal Public Service Number: $563420$Q$,$ started

$\frac{19}{8}\frac{?}{1998},$ pay $8\mathrm{.}50$ euro$/$hour

John Clark, DoB; $6/7/1957,$ Personal Public Service Number: $673401$A$,$ started

$\frac{2}{12}\frac{?}{1986},$ pay $15$ euros$/$hour

Noleen Conners, DoB; $12/5/1947,$ Personal Public Service Number: $543876$Z$,$

started $\frac{3}{2}\frac{?}{1985},$ pay $14\mathrm{.}50$ euros$/$hour

Mary Doyle, DoB; $27/3/1981,$ Personal Public Service Number: $543729$S$,$ started

$12/12/2001,$ pay $5$ euros$/$hour

a$)$ Draw the 'Personnel' Database Table Entity Relationship Diagram for the data provided.

Ensure that you identify the required data formats for storage.

$(8$ marks$)$

b Give two $(2)$ constraints on variables that are identified as the Primary Key in a DataBase.

$(4$ marks$)$

c What is the Primary Key for the 'Personnel' DataBase Table?

$(2$ marks$)$

d Explain the term derived data in relation to the Personnel table.

$(4$ marks$)$

e$)$ There is a claim that there's a Gender Pay Gap within the Ferris Company. Answer the

three following question in relation to the data claim.

a$)$ Identify which data from the 'Personnel' Table would be used to investigate the claim.

$(1$ marks$)$

b$)$ Identify which specific analysis would be required to test this claim.

$(3$ marks$)$

c$)$ Identify an error that is inherent in the analysis.

$(3$ marks$)$