Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a ) Write SQL statements to create the corresponding relations and capture as many of the participation and cardinality constraints as possible. Make sure that
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
Date:
I have not received or given help on this assignment: YourName
DROP DATABASE IF EXISTS LabYourLastName;
CREATE DATABASE LabYourLastName;
USE LabYourLastName;
Task : create tables
CREATE TABLE
Task : uncaptured constraints
put your response here
Task : Add records
INSERT INTO
Fix all errors and show the outcome of the code.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started