Unformatted text preview: require table recreation Textbook: Using the examples on pages 156 and 172 in your textbook and Project Manual pages 97 and 98 as a guide for this assignment , write a DDL to create the Employee table (use your Employee data structure from Course Project, Part 1) . The Resources section of this module contains a document with sample SQL Server data types. Note: This assignment does not have to be created in SQL Server. You may write the Create Table SQL statements in a text editor. If you used SQL Server to create table copy and paste statements in Word and submit. • Use an Identity column for the Primary key • Break down composite attributes e.g. Name is Last Name and First Name • Use correct data types (ASCII | Unicode, Fixed | Variable length) • Use NOT NULL | NULL, DEFAULT where needed. • Create Foreign key constraints and primary key constraints where required ....
View Full Document
This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.
- Summer '10