$($a$)$ You are required to create a conceptual data model of the data requirements

for a company that specializes in IT training. The Company has $30$ instructors

and can handle up to $100$ trainees per training session. The Company offers

five advanced technology courses, each of which is taught by a teaching team

of two or more instructors. Each instructor is assigned to a maximum of two

teaching teams or may be assigned to do research. Each trainee undertakes one

advanced technology course per training session.

Produce a conceptual data model for the above discourse. Your model should

represent:

$($i$)$ The entities.

$(6$ marks$)$

$($ii$)$ The relationships.

$(5$ marks$)$

$($iii$)$ Multiplicity of the relationships, ie cardinality and optionality.

$(5$ marks$)$

$($b$)$ Relational Database are some of the oldest data model used for database

management. However with current trend of applications, relational database

model have some limitations$.$ Identify and describe THREE $(3)$ limitations of

relational database model for business application today.

$(9$ marks$)$