Relational representation of <catalog> 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

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

Tasks

Extend your project's incomplete Schema/schema.sql file yet containing only INSERT but no CREATE TABLE statements. Try to map the given <catalog> integrity constraints as closely as possible. Use CHECK(...) constraints where appropriate.

Tip

  • In presence of an image both its name and type must not be NULL.

  • In absence of an image both its name and type must be NULL.

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.