it can be any sql

Roman 14 pt > BIUS X2 X, A A # # CIST 1220: SQL - Assign #7 (40 Points) [Creating Tables - Chap 7] 1.) 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: Detemine 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 732 characters Default Page Style English (USA) o JW 2.) Using SQL "Create Table' statements, create the 3 tables displayed below. PK Employees emplo firstName lastName address deptCode salary email 156 Tony Jenkins Dallas ACCT p@pacbell.com 207 Betty Jones Nashville MKTG $31,000.bjones@yahoo.com 00 302 John Carver Miami ACCT $29,000.jc@hotmail.com 00 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 32 characters Default Page Style English (USA) OT JW