The purpose of this coursework is to create a database for managing the information about the research conducted in a university based on a given ER diagram and a set of requirements. Then, you will have to perform different data manipulation and retrieval operations on the database. This coursework is formally assessed and is worth 10% of your final mark. You will receive some feedback as part of the marking of the coursework. This coursework is broken down to 10 points distributed as follows:
(1) Create and implement a given design and specification in appropriate SQL table creation queries, including the implementation of keys and domain constraints (2 points)
(2) Insert the appropriate sample data using INSERT queries (1 point)
(3) Create the appropriate views (1 point)
(4) Create and output the appropriate SELECT queries (4 points)
(5) Update data using the appropriate queries (1 point)
(6) Remove data using the appropriate queries (1 point)
