I need to create an SQL query to create the following table with a primary key and a foreign key, but Access is not accepting my SQL query Can you tell me what is wrong with it CUSTOMER EMPLOYEE table CUSTNUM EMPNUM EMPNAME TITLE 0121 27498 Smith Co Owner 0121 30441 Garcia Co Owner 0933 25270 Chen VP Sales 0933 30442 Levy Sales Manager 0933 48285 Morton President 1525 33779 Baker Sales Manager 2198 27470 Smith President 2198 30443 Jones VP Sales 2198 33780 Garcia VP Personnel 2198 35268 Kaplan Senior Accountant CREATE TABLE Customer Employee (CUSTNUM CHAR(4) PRIMARY KEY, EMPNUM CHAR(5) FOREIGN KEY, EMPNAME CHAR(12), TITLE CHAR(25) ) Thank you

The Answer is in the image, click to view ...

Question: I need to create an SQL query to create the following table with a primary key and a foreign key, but Access is not accepting

I need to create an SQL query to create the following table with a primary key and a foreign key, but Access is not accepting my SQL query. Can you tell me what is wrong with it?

CUSTOMER EMPLOYEE table
CUSTNUM	EMPNUM	EMPNAME	TITLE
0121	27498	Smith	Co-Owner
0121	30441	Garcia	Co-Owner
0933	25270	Chen	VP Sales
0933	30442	Levy	Sales Manager
0933	48285	Morton	President
1525	33779	Baker	Sales Manager
2198	27470	Smith	President
2198	30443	Jones	VP Sales
2198	33780	Garcia	VP Personnel
2198	35268	Kaplan	Senior Accountant

CREATE TABLE Customer Employee

(CUSTNUM CHAR(4) PRIMARY KEY,

EMPNUM CHAR(5) FOREIGN KEY,

EMPNAME CHAR(12),

TITLE CHAR(25)

)

Thank you!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1) Create a SQL query to create the following table of personal information called StudentInfo. Use you knowledge to determine what columns, datatype, size and constraints (i.e. primary key) is...

The Global Trading company sells various building and gardening tools. It has sales offices and Write SQL query to create the "SaleFacts" table declaring the primary and foreign keys. The table has...

Draw an ERD to reflect the requirements of the following scenario. You should copy and paste the image of your diagram into the box below. Scenario: "A motor vehicle has a make, a model, and a...

SQL Primary and Foreign Key Tables already created and data in them. Unable to use the alter SQL because of null values: Alter table returns add primary key (return_id) I was able to add primary key...

Consider the following table: Movies with primary key id: BoxOffice with primary key Movie_id, and foreign key also Movie_id (referencing Movies of question 1 given before). BoxOffice Movie_id Rating...

SQL 1) Using a view for a SELECT statement Using YOUR adventureWorks DBs view [ Sales].[vSalePerson], create a SQL query that returns the following columns for the sales people who have a [salesYTD]...

SQL 1) Using a view for a SELECT statement 3 Marks Using YOUR adventureWorks DBs view [ Sales].[vSalePerson], create a SQL query that returns the following columns for the sales people who have a...

SQL please help ASAP Consider the following table: Movies with primary key Id: Movies Year Length_minutes 1995 81 1998 95 Id Title 1 Toy Story 2 A Bug's Life 3 Toy Story 2 4 Monsters, Inc. 5 Finding...

Using either the command line or MySql Workbench, create a schema/database. Name the database Relational_Database. Use the .sql scripts to create the tables and insert all the data. There are tables...

Generate TWO datasets with 500 data each from a random function with an arrangement from 1-10 using RStudio. You need to assign these two 500 datasets as the population in Plant A and population in...

E-Eyes.com has a new issue of preferred stock it calls 20/20 preferred. The stock will pay a $20 dividend per year, but the first dividend will not be paid until 20 years from today. If you require...

Question 2 1 pts Last year, Cayman Corporation had sales of $ 2 8 million, total variable costs of $ 1 5 million, and total fixed costs of $ 5 , 0 0 0 , 0 0 0 I In addition, they paid $ 4 million in...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...