Purchase Solution

Creating Tables with SQL Server

Not what you're looking for?

Ask Custom Question

I tried posting this question once already and I paid pretty much for nothing! This has to be done in MS SQL.
Using SQL coding, create two tables using the following fields:

(Note: Supply the SQL Server data types when creating the tables. Apply the primary keys to the tables.)Create database and two tables (Employee & Job_Title). Both of these tables should have primary and/or foreign keys in them.

§ Employee Table

· Social_security_number (you will need to create your own SS#s)

· Last_name

· First_name

· Address

· City

· State_Code

· Zip_code

· Telephone_area_code

· Telephone_number

· Email_address

· Job_ID

· Hire_date

DateOfBirth

· Salary

§ Job_title Table

· Job_classification

· Job_title

· Exempt_status

· Salary_Low

· Salary_High

· JobID

Purchase this Solution
Solution Summary

This solution consists of a set of SQL queries to create two tables using SQL Server.

Purchase this Solution
Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

  • Creating an SQL Server Database

    511576 Creating an SQL Server Database Suppy SQL server data types when creating tables for the employees table, create an employee ID file that generates a unique number for each employee and designates the field as a primary key in the job title table

  • Maintenance Tools in MS SQL 2005

    , creating SQL Server Agent jobs, and scheduling backups.

  • Data Transformation Services

    Using the DTS Wizards SQL Server provides two wizards that automate the process of creating a DTS package. a) The Import/Export Wizard b) The Copy Database Wizard.

  • Creating a databse using Microsoft SQL Server

    247889 Creating a databse using Microsoft SQL Server Using Microsoft SQL Server CREATE DATABASE, CREATE TABLE, and SQL INSERT statements. Use the CREATE DATABASE statement to create a SQL Server database for Kudler Fine Foods.

  • Creating Tables Using SQL Server

    The expert creates tables using SQL server.

  • SQL Server 2000

    Individual Learning Event Start the SQL Server 2000 Enterprise Manager and use the navigation tree structure. Include a screen shot of the Enterprise Manager with the SQL Server service stopped.

  • Creating Kudler Fine Foods tables

    Create an SQL server database for the Kudler Fine Foods Virtual Organization. ? Create the following tables using fields listed below. ? Note. Use SQL server data types when creating the columns.

  • Working with tables in MS SQL server 2005

    193816 Working with tables in MS SQL server 2005 Need to know how to create a table with specified columns in SQL Server 2005. How can we add Foreign Key constraints ? How can we add Check constraints on particular columns ?

  • Microsoft SQL Server 2000 Problem

    29077 Microsoft SQL Server 2000 Problem Please help with the following problem involving programming languages. I am using Microsoft SQL Server 2000 1.

View More Related Solutions