This is a test document of the assignment I'm working on. This is a SQL DB project, and I'm trying to create a table and define constraints to my primary and foreign keys. However, when I'm testing the file, I get an error stating, "

ERROR 1072 (42000) at line 23: Key column 'Customer_ID' doesn't exist in table"

I've tried determining if it was how I declared the Primary Key, but I can't figure where I went wrong with the defining. Any help in getting this resolved will be great.

 

DROP TABLE IF EXISTS Customers;DROP TABLE IF EXISTS Employees;DROP TABLE IF EXISTS Technician;DROP TABLE IF EXISTS Services;CREATE TABLE Customers(Customer_ID INT,First_Name VARCHAR (25) NOT NULL,Last_Name VARCHAR (25) NOT NULL,Street_Address VARCHAR (50) NOT NULL,City VARCHAR(25) NOT NULL,State VARCHAR(2) NOT NULL,Zip INT NOT NULL,Phone_Number INT NOT NULL,CONSTRAINT Customers_pkPRIMARY KEY(Customer_ID));CREATE TABLE Employees(Employee_ID INT,First_Name VARCHAR(25) NOT NULL,Last_Name VARCHAR(25) NOT NULL,Street_Address VARCHAR(50) NOT NULL,City VARCHAR(25) NOT NULL,State VARCHAR(2) NOT NULL,Zip INT NOT NULL,Wage DECIMAL(10,2) NOT NULL,CONSTRAINT Employees_pkPRIMARY KEY(Employee_ID),CONSTRAINT Employees_fk_CustomersFOREIGN KEY (Customer_ID) REFERENCES Customers (Customer_ID),--FOREIGN KEY (Service_ID_fk) REFERENCES Services (Service_ID));

• 1495514609-TestCP.txt

ComputerScienceExpert

(11)

Status NEW Posted 23 May 2017 04:05 AM My Price 8.00

-----------

Attachments

file 1495514611-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer