Question

The Shoe store’s database schema is as follows:

Shoes(id, name, description, color1, color2, d_id)

CK: name

FK: d_id references Department(id)

Department(id, name, description)

CK: name

Orders(id, shoe, size, quantity, has_arrived)

FK: shoe references Shoes(id)

Step 1 (30 points): Write create statements for each of the above tables, making sure to have appropriate data types and with all keys declared. To receive full credit, you must have both your exact SQL statement and a screenshot showing the successful executing of your create statements.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

This demonstration is using SQL Server 2014.Database and Tables are created using SQL Server Management Studio (SSMS).

Database :

/*create database ShoeStoreDB*/
create database ShoeStoreDB;

/*use ShoeStoreDB database to create tables*/
use ShoeStoreDB;

Tables :

1.Table Name :Department

/*1.Table Name :Department*/
create table Department (
id int primary key,
name varchar(100) not null,
description text not null
);

Screen in SSMS :

2.Table Name :Shoes

/*2.Table Name :Shoes*/
create table Shoes(
id int primary key,
name varchar(100) not null unique ,
color1 varchar(20) not null,
color2 varchar(20) not null,
d_id int foreign key references Department(id)
);

Screen in SSMS :

3.Table Name : Orders

/*3.Table Name :Orders*/
create table Orders(
id int primary key,
shoe int ,
size int not null,
quantity int not null,
has_arrived varchar(20) not null,
foreign key (shoe) references Shoes(id)
);

Screen in SSMS :

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.