Assignment 6 Questions - require table recreation Textbook...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 6 Course Material: 1. Read Chapter 6 Understanding the SQL Language, pages 184-192, 213-217 in textbook to get an overview of concepts and terminology. 2. (Overview) Review SQL Overview 3. (Resources) View SQL Tutorial (slides 1-6). Most slides contain additional notes and explanation. Project Manual: Complete Projects 5.3, 5.4, 5.5, 5.6. It is not necessary to submit answers to questions, but these projects will tell you how to complete the second part of this assignment and explain how you will create your database for the last part of the project. Note: 1) The instructions in the manual are for 2005 if you have 2008 installed : to change a table you will select design instead of modify the rest of the instructions will be the same. 2) Make sure the following option is unchecked in SQL Server when you start management studio : Select Tools , then options and designers and uncheck Prevent savings changes that
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online