Question: Part II: Report on Logical Database Design Good DBAs must be able to prepare a full design report. You should hand in the full, legible report (hopefully typeset) with a cover page that gives your name, the title of the project, and its brief description. The final report should include sufficient detail to describe all steps of your design:
(1) Describe what you have chosen as your database.
(2) List at least 10 reasonable queries in English.
(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 forms the schema satisfies.
(8) (Up to 5 extra points) Perform the decomposition into 3NF or BCNF and give the final database schema 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 support them.
(11)In conclusion, describe what you have learned from the project, and include your observations about the power of relational systems and languages.