Relational Schema

[SW1F7YY]

Design relational database schema for all relational mapping in Task 3 in the for of both:

1. Visual Diagram
2. SQL statements targeted towards MariaDB

Include where applicable:

• Primary, Secondary and Foreign keys
• Constraints
• Types and constraints(nullable, length,...) if applicable
• Checks on applicable fields