The recover manager provides functions used by both crash recovery and concurrency control. For example, it is needed to perform roll-back of aborted transactions. Children indicates the name and birthday of all children. Birthday specifies a date type. Skills indicates the type and the set of all relevant exams of each skill.
Exams indicates when and where an exam is held.
Redesign the database into first normal form and forth normal form. List any functional or multivalued dependencies that you assume. Also list the referential-integrity constraints that should be present in the forth normal form schema. Note that by a first normal form schema, we mean a relational schema without set values. Thus, you shall first transform the database into one flat relational schema, i.e., a list of all relevant attributes, and then list all dependencies.