Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer

Exercise 4

Write a CREATE TABLE statement to create the table SLIDE_SHOW (ShowID, Name, Description, Purpose). Assume that ShowID is a surrogate key. Set the data type of Name and Description however you deem appropriate. Set the data type of Purpose to char (15) and limit it to the set of values ('Home', 'Office', 'Family', 'Recreation', 'Sports', 'Pets'). Execute your CREATE TABLE statement using Query Analyzer.