Archive

Posts Tagged ‘title table’

Sql 1: Table Queries

August 25th, 2009 Comments off

Sql Project 1 Of 5

July 12th, 2009 Comments off

Using the SQL CREATE statement, create the following two tables using the following fields:

Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table’s primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.

Employee Database Sql

April 23rd, 2009 Comments off

I need a SQL database completed in Express 2008. The details are as follows and it must be completed by Saturday the 25th:

Create an SQL server database for the Kudler Fine Foods Virtual Organization.

–Comment goes here
CREATE DATABASE CASEKudlerFineFoods
ON PRIMARY
(NAME = Case_KudlerDB_dat,
FILENAME = “C:POS410MyStuffCase_KudlerDB_dat.mdf”,
SIZE = 10MB,
MAXSIZE = 100MB
FILEGROWTH = 10%)

–Comment goes here
LOG ON
(NAME=”Case_KudlerDB_log”,
FILENAME=”C:POS410MyStuffCase_KudlerDB_log.ldf”,
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 20%)

(Note: Table connected by key means that if you have a primary key of Employee ID in the EMPLOYEE table, and Employee ID as a foreign key in the Job Title table, indicate the join in the data dictionary.)

Bear