a$)$ Write SQL statements to create the corresponding relations and capture as many

of the participation and cardinality constraints as possible. Make sure that the data

type and size for each attribute are appropriate.

b$)$ If some constraints in the diagram cannot be captured, explain why.

c$)$ Write SQL statements to insert at least two tuples for each table

$/**********************************************************************************$

$*$ Name: YourNameGoesHere $*$

$*$ Class: CST $235*$

$*$ Date: $*$

$*$ I have not received or given help on this assignment: YourName $*$

$************************************************************************************/$

DROP DATABASE IF EXISTS Lab$3$YourLastName;

CREATE DATABASE Lab$3$YourLastName;

USE Lab$3$YourLastName;

$/*****$

Task $1$: create tables

$*******/$

CREATE TABLE

$....$

$/*****$

Task $2$: uncaptured constraints

put your response here

$....$

$******/$

$/*****$

Task $3$: Add records

$*******/$

INSERT INTO $...$

Fix all errors and show the outcome of the code.