Question 1

1. One of the components of a DBMS is the Query Processor. What is the purpose of the Query Processor?
2. Explain what is meant by the file-based approach to data storage and discuss its limitations?
3. Another critical component of a DBMS is the Database Manager. What are the key components of the Database Manager?

Question 2

1. Explain what is meant by the term determinant in the context of a functional dependency and give a suitable example to illustrate your explanation.
2. The following form shows all the modules for a particular course. Each module is taught by a lecturer and each module may be declared 'Core' or 'Optional' for a course. Normalise the form on the following page to third normal form, stating any assumptions that you are making.

3. Convert your answer to question 2b into relational schemas.