Submit a series of SQL statements that when executed in sequence yields a functional database with tables constraints and relationships. Create Database Exercise Part 1:
Please include the following information in your tables:
Ensure you use the proper data type and constraint for each attribute
This exercise will help you identify the sequence a website must present to the user, given the dependencies you are embedding into the database structure.
All of the symbols you created in the EERD must be transferred to the CREATE statement. Primary Keys, Foreign Keys, UNIQUE constraints, NOT NULL constraints, dependencies, etc.
Write the CREATE statements for the database and ALL the tables in the EERD.
This file should be able to run without errors. Also, I should be able to re-run the file without errors.
DROP the database before starting. For example:
DROP DATABASE IF EXISTS abc1234 ;
CREATE DATABASE IF NOT EXISTS abc1234 ;
USE abc1234 ;
DROP TABLE IF EXISTS abc1234.side ;
CREATE TABLE IF NOT EXISTS abc1234.side (
side_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
side_name VARCHAR(50) NOT NULL UNIQUE KEY,
side_description TEXT NOT NULL,
is_sweet BOOLEAN NOT NULL DEFAULT 1
side_cost_ingredients DECIMAL(7,2) NOT NULL,
side_cost_prep DECIMAL(7,2) NOT NULL,
) ENGINE=InnoDB AUTO_INCREMENT=1001 ;
Every time you create a table with AUTO_INCREMENT you should increment the sequence by a base sequencing number, 1000 for instance. Therefore, the Entree table for example, you should start at 2001.