Figure $1$ shows an ERD that is used to develop an information system for

contractors. Many$-$to$-$many relationships cannot be used directly by most of the

database management software.

i$)$ Redraw and complete the ERD with suitable attributes $($including primary

key and secondary key$)$ so that it can be applied in database management

software. You may add new entities $($if needed$)$ to support your answer.

ii$)$ Convert your ERD into tables and insert a few samples of records to show

that the database design is applicable.

Figure $1$

$(25$marks$)$

$(35$ marks$)$

for

REGISTRATION

INFORMATION

STAFF

have

hire

hired by

CONTRACTOR ADDRESS

have

PROJE