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