Create The SQL Commands For Creating The Employer

Submitted By JoshLuster1
Words: 847
Pages: 4
Open Document
POS410 - WEEK 2 INDIVIDUAL ASSIGNMENT
STUDENT NAME Josh Luster
Folks, you need to show at least two portions for each requirement: 1) the SQL code used to satisfy the requirement and 2) a screenshot showing that the SQL Code executed properly in SQL Server. See the bottom of this document for an example of a SQL code followed by the screenshot.
ASSIGNMENT REQUIREMENTS
After each of the following requirements, please paste the appropriate material: 1) Show the SQL Commands for creating the EMPLOYEE table (1.5 points)

-- 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 NOT NULL,

Gender char(1) NOT NULL,

Race varchar(25) NOT NULL,

Age int NOT NULL

);

GO a. Show a screen shot showing the proper execution of the table (1 point)

Attached PNG

2) Show the SQL Commands for creating the JOBTITLE table(1.5 points)

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 b. Show a screen shot showing the proper execution of the table (1 point)

Attached PNG

3) Show all the SQL INSERT statements for the EMPLOYEE table(1.5 points)

INSERT INTO Employee VALUES

('Edelman', 'Glenn', '175 Bishops Lane', 'La Jolla', 'CA', '619', '555-0199',

'Cashier', '07-OCT-2003', 21500.00, 'M', 'Caucasian', 64);

INSERT INTO Employee VALUES

('McMullen', 'Eric', '763 Church St', 'Lemon Grove', 'CA', '619', '555-0133',

'Bagger', '1-NOV-2002', 13500.00, 'M', 'Caucasian', 20);

INSERT INTO Employee VALUES

('Slentz', 'Raj', '123 Torrey Dr.', 'North Clairmont', 'CA', '619', '555-0123',

'Assistant Manager', '1-JUN-2000', 48000.00, 'M', 'Asian', 34);

INSERT INTO Employee VALUES

('Broun', 'Erin', '2045 Parkway Apt.2B', 'Encinitas', 'CA', '760', '555-0100',

'Bagger', '12-MAR-2003', 10530.00, 'F', 'Caucasian', 24);

INSERT INTO Employee VALUES

('Carpenter', 'Donald', '927 Second ST.', 'Encinitas', 'CA', '619', '555-0154',

'Stocker', '1-NOV-2003', 15000.00, 'M', 'African American', 18);

INSERT INTO Employee VALUES

('Esquivez', 'David', '10983 N. Coast Hwy Apt 902', 'Encinitas', 'CA', '760', '555-0108',

'Retail Asst. Butchers & Seafood Specialists', '25-JUL-2003', 18500.00, 'M', 'Hispanic', 25);

INSERT INTO Employee VALUES

('Sharp', 'Nancy', '10793 Monteciono Rd', 'Ramona', 'CA', '858', '555-0135',

'Cashier', '12-JUL-2003', 21000.00, 'F', 'Caucasian', 24); c. Show a screen shot showing the proper execution of the INSERT (1 point)

Attached PNG

4) Show all the SQL INSERT statements for the JOBTITLE table(1.5 points)

-- Insert the Job_title records

INSERT INTO Job_title VALUES

('Accounting Clerk', 'Office/Clerical', 'Computes, classifies, records,

and verifies numerical data for use in maintaining accounting records.', 0);

INSERT INTO Job_title VALUES

('Assistant Manager', 'Officials & Managers', 'Supervises and coordinates activities

of workers in department of food store. Assists store manager in daily operations of store.', 1);

INSERT INTO Job_title VALUES
Show More

Related Documents: Create The SQL Commands For Creating The Employer

Essay on Bsa 310 Week 4, Individual Assignment - Mcbride Marketing Plan

BSA 310 McBride Financial Marketing Plan University of Phoenix Name: xxxxxxxx Date: xxxxxxx McBride Financial McBride Financial is a fast growing organization with plans to open a total eight offices located in Idaho, Montana, Wyoming, South and North Dakota. Services will specialize in providing financial mortgage assistance to first time buyers, retirees, professionals, families and individuals with credit problems. McBride Financial provides customers with informative information…

Words 888 - Pages 4

Essay on Virtual Organization System Inventory: Huffman Trucking Company

Virtual Organization System Inventory Alicia Aaron BSA/310 November 10, 2014 Michele Petrone Huffman Trucking Company Finance and Accounting 1. Description: This system keeps track of the company's financial transactions. These transaction are summarized, recorded,, and presented in a financial report or statement such as an income statement or balance sheet. 2. Department to use: Accounting 3. Purpose: This system records all accounts payable and receivable, inventory, payroll and…

Words 335 - Pages 2

Business Analytics Research Essay

Business Analytics Research Christina Noll BSA/310 November 10, 2014 Instructor: Marsha Devine Business Analytics Research What is business analytics? Business analytics is the practice of interactive, methodical exploration of an organization’s data with emphasis on statistical analysis. Business analytics is used by companies committed to data-driven decision making. (Rouse, n.d.) Many businesses use business analytics to make more informed business decisions, as well as to optimize…

Words 330 - Pages 2

Essay on Cost-benefit Analysis

Cost benefit analysis Justin Paulus Bsa/310 9/8/2014 Neal Sergeant Cost benefit analysis Cost benefit analysis is how a project is compared to see what can be gained or loss. This process includes weighing the total predicted cost of each option versus the total predicted outcomes. This comparison will show how much the benefits outweigh the cost and if it is actually worth it. Understanding this I would have to say the relevance to this week’s team progression would be us weighing the…

Words 326 - Pages 2

Jenna Lee week 5 assignment 1 Essay

Famous Footwear Jenna Lee BSA/310 JULY 16, 2015 Deborah Ray-Sims Famous Footwear So many retails business's should have various ways in reducing costs. Famous Footwear is definitely one of those among other retail companies, who look for a wide variety of ways to do so. One of the most powerful tools available to Famous Footwear is analytics and this tool is used for a broad variety of purposes to the retail business. Retails like Famous Footwear who are organized typically use analytics to optimize…

Words 315 - Pages 2

System Inventory

System Inventory Scott Finley BSA/310 August 26, 2013 Jennifer Streker System Inventory Systems are important for an organization’s systems as a whole because of how the individual systems work in conjunction with one another to accomplish the goals and tasks of the company so that the company and grow, survive, and make money. The systems of the company can be best summed up by illustrating and defining what the systems do in order to complete the functionality cycle of the business…

Words 344 - Pages 2

Business System Proposal

* Riordan Business Systems Proposal Team C Carl Ruf David Mack Benjamin Rodriguez Jr. BSA/310 March 13, 2014 Daniel Wojnowski * Business System Definition “A methodical procedure or process that is used as a delivery method mechanism for providing specific goods or services to customers” Decision support systems are used by upper management and key executives to make long-term strategic decisions on the future of the company. *Decision Support Systems *designed to assist middle and lower…

Words 373 - Pages 2

Essay about Kudler Accounting

 Key features  Core technology  Benefits  Costs Keep your paper at a high level, but provide enough details so the executives at Kudler Fine Foods can decide whether to pursue the project based on your paper. Kudler Accounting BSA/310 2/07/2014 Professor Introduction Whether it is a service, manufacturing or merchandising business the primary goal of any business is to make a profit. Kudler Fine Foods would fall into the merchandising retail group. First and foremost…

Words 551 - Pages 3

It And Marketing Paper

IT and Marketing Ray Ruiz BSA/310 May 3, 2013 Fred Bennett IT and Marketing The goal of marketing for every business is to identify a product or service to specific segment of people that can produce a profit. With the advancement in information technology, new methods of marketing are available to companies. Social marketing tools such as social networking sites, blogs, email, and online forums have made it possible to reach various consumers in real time. IT systems proved many benefits…

Words 527 - Pages 3

Career Analytics Paper

Francisco Acevedo December 22, 2014 BSA 310 Instructor Ivon Young Career Analytics Manheim Auto Auction is “transforming the wholesale vehicle buying and selling through investments in technology and innovative products and services. Manheim markets Simulcast, Simulcast Everywhere, OVE.com, and Manheim Consulting. Manheim has set the industry standard for buying and selling used vehicles at live auctions and online. It brings together qualified sellers and volume buyers of used vehicles that…

Words 516 - Pages 3