Relational representation of <examinations> documents

Preparation

If you already started the first task just continue working on your project using IntelliJ. Otherwise read the first task regarding the skeleton project import.

Hint: A global database connection is configured on IDEA level.

Description / tasks

Extend the relational schema skeleton Schema/schema.sql preparing your RDBMS to import <examinations> instances.

Note the pre-existing table Student: Add required tables reflecting XML instances and their integrity constraints so that marking data references the respective entries in table Student by a foreign key to Student.matriculation.

Use CHECK(...) constraints where appropriate.

Solution upload

Upload your project using the previous task. Then enter «I'm expecting points for my work on the current task» into the text field below on this page.