Archive
Sql Project 1 Of 5
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.
Week 2 Ia
Kudler Fine Foods is a
Sql Project
Kudler Fine Foods is a
Employee Database Sql
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.)


