3. NoSQL databases, Normalisation, and Triggers [5 marks] (b) Explain a scenario where a graph database is more appropriate to use [5 marks] (c) Relational databases are often normalised. Explain what it means for a [5 marks] (d) Let the relation schema R(a, b, c, d, e, f,g) have the set of full functional (a) What is a NoSQL database? than a relational database schema to be in 3rd Normal Form dependencies listed below (a,b) e (a,b) g {a,b,c) f i. Explain why fa, b) is not a key for this schema R. [4 marks] ii. Bring relational schema R into Third Normal Form. Explain all steps and make sure you declare primary and foreign keys for each [13 marks] (e) When converting a one-to-many relationship of an Entity-Relationship model into a logical (relational) model, only one of its participation constraints can be naturally translated. Which one is that and how will this constraint be represented in the relational schema?[5 marks (f) Assume a MySQL database has been implemented according to the schema that you introduce during normalisation following relational database schema Staff (staffNo,fname, lname, branchNo) primary key stafINo foreign key branchNo references Branch(branchNo) Branch(branchNo, name, address,number0fStaff) primary key branchNo Write one or several triggers (as appropriate) that automatically update and maintain numberOfStaff in Branch as a derived attribute of type INT. This means the value of numberOfStaff in a branch record must always be the number of staff currently assigned to this branch according to the Staff table Make sure your code is MySQL 5 compliant. [13 marks]