CIST 1220 SQL Assign 7 (40 Points) Creating Tables Chap 11 Using the design that you created in Assign 2(or see my correct answers under Week 7), we are now going to build the tables using SQL You must use SQL in this assignment DO NOT CREATE THESE TABLES WITH MS ACCESS DATABASE DESIGN VIEW Part I Determine Columns and Data Types for each table, decide what data types you will use for each column This info should come from the Assign 1 or my Designs Part II Using MSAccess and SQL, create the tables from your design Make sure to assign the Primary Key Type in your SQL code and Execute If you get no errors, the table was created To hand in this assignment, all I want is the SQL code That is all the create Table statements Check out the examples I posted under Week 7 Create Table Examples for help Using SQL Create Table statements, create the 3 tables displayed below PK Employees empID firstName lastName address deptCode salary email 156 Tony Jenkins Dallas ACCT tj pacbell com 207 Betty Jones Nashville MKTG $31,000 00 bjones yahoo com 302 John Carver Miami ACCT $29,000 00 jc hotmail com 457 Susan Collins Houstons IT $29,000 00 PK Depts DeptId DeptName DeptLocation ACCT Accounting Dallas MKTG Marketing Atlanta IT Information Tech Houston HR Human Resources Charlotte PK Accounts acctNo owner address type balance 44421 David Smith Atlanta SAV $225 00 77791 David Smith Atlanta MMA $4,560 00 32145 Karen Wilson Duluth CHK $231 12 14566 Karen Wilson Duluth MMA $3,125 00 78777 Kyle Miles Marietta SAV $2,000 00 78900 Kyle Miles Marietta CHK $314 90 75412 Ben Cole Acworth CHK $566 87 75413 Ben Cole Acworth SAV $5,000 00 75414 Ben Cole Acworth MMA $2,900 00 When you turn in this Assignment, you should have different Create Table Commands 2 ) Using SQL 'Create Table' statements, create the 3 tables displayed below Employees empID firstName lastName address detCodel salar email Jenkins Dallas ACCT tj pacbell com 156 Tony 207 Betty Jones Nashville MKTG $31,000 bjones yahoo co 00m 302 John Mia mi ACC$29,000 jc hotmail com Carver 457 Susan Collins Houston IT $29,000 PK Depts Deptld DeptName Deptlocation ACCT Accounting MKTG Marketing IT HR Human Resources Charlotte Dallas Atlanta Information Tech Houston

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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 30, 2024

CIST 1220: SQL Assign #7 (40 Points) [Creating Tables Chap 11] Using the design that you created in Assign #2(or see my correct answers under

CIST 1220: SQL Assign #7

(40 Points)

[Creating Tables Chap 11]

Using the design that you created in Assign #2(or see my correct answers under Week #7), we are now going to build the tables using SQL.

You must use SQL in this assignment. DO NOT CREATE THESE TABLES WITH MS ACCESS DATABASE DESIGN VIEW!!!

Part I: Determine Columns and Data Types for each table, decide what data types you will use for each column. This info should come from the Assign #1 or my Designs.

Part II: Using MSAccess and SQL, create the tables from your design. Make sure to assign the Primary Key. Type in your SQL code and Execute. If you get no errors, the table was created.

To hand in this assignment, all I want is the SQL code. That is all the create Table statements.

Check out the examples I posted under Week #7 Create Table Examples for help.

Using SQL Create Table statements, create the 3 tables displayed below.

Employees
empID	firstName	lastName	address	deptCode	salary	email
156	Tony	Jenkins	Dallas	ACCT		tj@pacbell.com
207	Betty	Jones	Nashville	MKTG	$31,000.00	bjones@yahoo.com
302	John	Carver	Miami	ACCT	$29,000.00	jc@hotmail.com
457	Susan	Collins	Houstons	IT	$29,000.00

Depts
DeptId	DeptName	DeptLocation
ACCT	Accounting	Dallas
MKTG	Marketing	Atlanta
IT	Information Tech	Houston
HR	Human Resources	Charlotte

Accounts
acctNo	owner	address	type	balance
44421	David Smith	Atlanta	SAV	$225.00
77791	David Smith	Atlanta	MMA	$4,560.00
32145	Karen Wilson	Duluth	CHK	$231.12
14566	Karen Wilson	Duluth	MMA	$3,125.00
78777	Kyle Miles	Marietta	SAV	$2,000.00
78900	Kyle Miles	Marietta	CHK	$314.90
75412	Ben Cole	Acworth	CHK	$566.87
75413	Ben Cole	Acworth	SAV	$5,000.00
75414	Ben Cole	Acworth	MMA	$2,900.00

When you turn in this Assignment, you should have different Create Table Commands!!!

2.) Using SQL 'Create Table' statements, create the 3 tables displayed below Employees empID firstName lastName address detCodel salar email Jenkins Dallas ACCT tj@pacbell.com 156 Tony 207 Betty Jones Nashville MKTG $31,000. bjones@yahoo.co 00m 302 John Mia mi ACC$29,000. jc@hotmail.com Carver 457 Susan Collins Houston IT $29,000 PK Depts Deptld DeptName Deptlocation ACCT Accounting MKTG Marketing IT HR Human Resources Charlotte Dallas Atlanta Information Tech Houston