Introduction to Databases ITCO231-01
Unit 4, Individual Project

I have indicated the changes that I had to make from the Unit 3 – IP in blue. In addition, I’ve added the foreign keys and the changes to the columns where appropriate, also in blue. One thing that baffled me until I figured it out was not being able to save my changes. I finally found the checkbox to turn off “Prevent Changes.”
Color Code:
Blue: Changes/Corrections From Unit 3 - IP
Locations Table: * CREATE TABLE locations ( location_id int not null primary key, street_address varchar(50) null, postal_code varchar(50) null, city varchar(50) null, state-province varchar(50) null, country_id varchar(50) not null
);
ALTER TABLE locations WITH CHECK
ADD FOREIGN KEY (country_id) REFERENCES countries (country_id)
ALTER TABLE locations
ALTER COLUMN location_id NOT NULL
ALTER TABLE locations
ALTER COLUMN country_id NOT NULL Regions Table: *
CREATE TABLE locations ( region_id int not null primary key, region_name varchar(50) not null );
ALTER TABLE regions
ALTER COLUMN region_id NOT NULL

Countries Table: *
CREATE TABLE locations ( country_id int not null primary key, country_name varchar(50) not null, region_id int not null );
ALTER TABLE countries WITH CHECK
ADD FOREIGN KEY (region_id) REFERENCES regions (region_id)
ALTER TABLE countries
ALTER COLUMN country_id NOT NULL

Departments Table: *
CREATE TABLE locations ( department_id int not null primary key, department_name varchar(50) not null, manager_id varchar(50) not null, location_id varchar(50) not null );
ALTER TABLE departments WITH CHECK
ADD FOREIGN KEY (manager_id) REFERENCES locations (location_id)
ALTER TABLE departments WITH CHECK
ADD FOREIGN KEY (department_id)