ENTITY RELATIONSHIP DIAGRAM $($Conceptual$,$ Logical $\backslash$& Physical Data Modeling$)$:

PROBLEM $1$

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.

$1.$ Identify the main entity types for the company and their attributes $($logical ER Diagram$)$

$2.$ Identify the main relationship types. State any assumptions you make about the data $($this means explain the relationships IN PLAIN WORDS, NOT by drawings$).$

$3.$ Create the physical Data Model including the attributes and Primary Keys.