(3) Add one or more atomic transactions to your query set.(4

(3) Add one or more atomic transactions to your query set.(4) State assumptions about the database as briefly as possible.(5) Give the ER diagram of the database.(6) Give the relational database schema.(7) (Up to 5 extra points) For each relation schema, give the associated FDs and specify the normal formsthe schema satisfies.(8) (Up to 5 extra points) Perform the decomposition into 3NF or BCNF and give the final databaseschema along with the FDs.(9) Give the relational algebra expressions for the queries formulated in step 2.(10)Give at least two reasonable, but unanswerable queries, and explain why the database cannot supportthem.(11)In conclusion, describe what you have learned from the project, and include your observations aboutthe power of relational systems and languages.