1) Kim (hypothetical person!) works in the Graduate School at Tree Top University and keeps track
of the following:
a. PROFESSORs
b. Graduate STUDENTs, their major professor, and two other committee members (both
professors)
c. THESIS students have written and which professors were on the committee
d. FORMs that have to be completed by students and who has / has not completed them
(students generally have to complete multiple forms)
e. COLLEGEs & DEPARTMENTs students are in (you may have two entities if you wish)
Your task is to create a data model (the first version) for an application that will track all of the
above. Use appropriate attributes (identifier, etc.) for each entity. Here, I will be looking more
at your thought process rather than the most correct diagram, so write down every thought you
have, every step you can think of, every idea you have, why / why not, and describe them all. In
a nutshell, tell me how you approached this situation and what made you draw the data model
as you drew it.
2) Explain in laymanàterms what Functional Dependency is. Provide the explanation of vocabulary
used (i.e., define each term like determinant, etc.).
3) a. Why is a ternary relationship necessary in this situation?
b. What is QUOTE and why is it shown the way it is shown? Why does it have its own identifier

Purchase answer to see full
attachment