POS 410 Week 3 Individual Assignment Data Changes and SQL Statements

Content type

User Generated

Type

Study Guide

Uploaded By

wnzrfxbegu

Pages

Rating













 







!"#$%&'((

&





))$$*++ ,+

$*++ ,+'((-

))0'((

0+'((-

))$123"

$*++,+123

123%4567/08*9*:'+:;

++/2#2$<3%4=67/0;

123%4!567/0;

+>22+>2/0

))$+?$*++,+

$*++,++?

+2/0 +:4#;#78*9*:'+:;

2%4!57/0;

(2%4!57/0;

%4@67/0;

$?%4#57/0;

4!7/0;

22%4=7/0;

2%4A7/0;

123%4567/0

(/*+.'+:*+(+*+$+12341237;

B23/0;

?/0;

.4#7/0;

*%4!57/0;

/0

End of Preview - Want to read all 6 pages?

Access Now

Unformatted Attachment Preview

/**************************************************************** * Week Two IA * Set up a working database that will be used in the coming * weeks to build and test SQL statements * * Author: Name * Date: ****************************************************************/ /* * 2.1 Create a SQL Server database for Kudler Fine Foods * and create the following two tables */ -- Create the database using CREATE DATABASE CREATE DATABASE KulderFineFood; GO -- Use KulderFineFood as the current database USE KulderFineFood; -- Create the Job_title table. CREATE TABLE Job_title ( Job_title varchar(50) NOT NULL PRIMARY KEY, EEO_1_Classification varchar(30) NOT NULL, Job_description varchar(250) NOT NULL, Exempt_Non_Exempt_Status bit NOT NULL ); GO -- Create the Employee using CREATE TABLE CREATE TABLE Employee ( Emp_id int NOT NULL IDENTITY(1,1) PRIMARY KEY, Last_name varchar(25) NOT NULL, First_name varchar(25) NOT NULL, Address varchar(40) NOT NULL, City varchar(15) NOT NULL, State char(2) NOT NULL, Telephone_area_code varchar(3) NOT NULL, Telephone_number varchar(8) NOT NULL, Job_title varchar(50) NOT NULL FOREIGN KEY REFERENCES Job_title(Job_title), Hire_date smalldatetime NOT NULL, Wage money ...
Purchase document to see full attachment