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.”
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, ...view middle of the document...
(2008). Murach's sql server 2008 for developers....