Lab Instructions: 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;

$\frac{?}{?}**********$

Task $1$: create tables

$*************\frac{*}{?}$

CREATE TABLE

$....$

$\frac{?}{?}**********$

Task $2$: uncaptured constraints

put your response here

$***********\frac{*}{?}$

$\frac{?}{?}**********$

Task $3$: Add records

$**************$

INSERT INTO $..$

You should work individually on this assignment. Create a new SQL script file$($ using Notepad or Notepad$++)$ and save it as Lab$3$xxxx$.$sql $($where $$ is your last name$).$ Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file.

Your script file will be graded only if it executes as one MySQL script file without syntax errors or other similar problems. Make sure your script runs without errors. Otherwise, you will not receive any credit for this assignment.

Tasks: Considering the following E$-$R diagram, you need to translate it into a relational database and add some data to the tables.

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