This is the database I am currently trying to create. I have the create statements done but it cannot create the tables or insert (insert statements off screen) the data from the table on the left because every column has nulls. I might be importing the excel sheet wrong but I'm pretty sure thats not it. The only thing I can think of is to create the exact same tables without primary and foreign keys, but I dont think I'm supposed to do that. Is there any way to to convert tables with nulls into tables with primary keys?

SQLQuery 5sql-LEX. EXNChristina (51)) groupprojecttablecr LEXnChristina (53)) CREATE TABLE Department dept_no nvarchar (255) PRIMARY KEY dept_name nvarchar (255), dept_location nvarchar (255) 100% Results E Messages emp.hame dept-no dept_aame R&D R&D job dept-location Dallas. TX Dallas. TX jobjtle Engineer 201 NULL NUL au Pr emp-no empfname CREATE TABLE Project 3 28559 Sybill 4 33355 5 2581 keHanse d2Accounting Tampa, FL Analyst 201 6 9031 Bsa 7 9031 sa Bertoni d2 Accounting Tampa, FL Engineer 20 8 29346 James James d2 Accounting Tampa, FL Eng 201 9 29346 James James2 Accounting Tampa, FL NULL20EEployee 10 30606 KathieWilson d2 Accounting Tampa, FL Analyst 201 Peter Fiaher d1 proj_no nvarchar(255) PRIMARY KEY, proj_name nvarchar (255), proj_budget float(53) Bertoni d2 Accounting Tampa, FL Manager 201 CREATE TABLE emp-no float (53) PRIMARY KEY, emp_fname nvarchar (255), empIname nvarchar (255), dept_no nvarchar (255), FOREIGN KEY (dept no) REFERENCES Department (dept_no) ON DELETE NO ACTION 30606 Kathie Wilson d2Accounting Tampa, FL Programmer NUL 12 10102 AnnJones d3Marketing Miami, FL alys 201 13 10102 Ann Jones d3Marketing Miai, FLManager 201 14 25348thew Smith 3 Marketing Miami, FL Engineer 201 5 NULL NULL NULL d4ShippingAtlanta, GA NULL NUL 16 31189 Julia 17 NULL NULL NULL d Custome.. St. Louis, MO NULL NUL 18 5500 Paul 19 5500 Paul 20 5500 Paul 21 5500 Paul 22 34427 Matthe Ao NULL NULL NULL 23 NULL NULL NULL NULL NULL NULL Whited5 SalesTampa, FL NULL NUL CREATE TABLE Jobs emp_no float (53), proj_no nvarchar (255), job title nvarchar (255), job_begin nvarchar (255 PRIMARY KEY CLUSTERED (emp_no, proj no), FOREIGN KEY (emp_no) REFERENCES Employee(emp_no) ON UPDATE NO ACTION ON D FOREIGN KEY (proj_no) REFERENCES Project proj_no) ON UPDATE NO ACTION ON Fisher NULL NULL NULL NULL NULL NULLProgrammer 201 Fisher NULL NULL NULL FisherNULL NULL NULL QA Manager 201 NULL NULL NUL NUL 100 % Query LEXnSQLE PRESS 11.0RTM) LEX Christina (51) Our Company 0:00 01 23 os %Connecte. LErSQLEXPRESS IORTM LEn Ch na 53 0 Company 00:00 000 w s