#### 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.