Exercise Entity Consider a system concerning the management of people (professors and graduate students) who work on scientific projects in the engineering faculty of university. A project has a project number, a start date, an end date and a budget. It is managed by a professor (Known as project manager). A professor has an NSS, a name, an age, and a research specialty. He can manage and/or work on several projects. One or more teachers work on each project. Graduate students have an NSS, name, age, and program degree. A professor can work on several projects; for each project, the work of a graduate student is supervised by a single professor. One or more graduate students work on each project. Professors work in one or more departments, and in each department, they work in, a percentage of time is associated with their work. Each graduate student belongs to a department. Question asked: Elaborate the Entity-Association diagram of this system. Indicate for each entity its identifier and its attributes and for each association its cardinalities and its attributes and the possible constraints of this system. Add any attributes you find necessary for this system Elaborate the MLDR (Logical Relational Data Model) which corresponds to the following Entity Association diagram We consider the relational scheme R=(C,T,H,R,S,G) With the set of functional dependencies: Questions asked: a) Draw the functional dependency graph and determine the key(s) of this relationship. b) Decompose the relation R to obtain a set of relations in 3FN