吉林大学--DB2实验报告3.docVIP

吉林大学 DB2实验报告 班级： 14级9班 姓名：郭世鑫 学号 姓名 郭世鑫 学号 实验项目 3. Create objects 实验性质 □演示性实验 □验证性实验 (操作性实验 □综合性实验 实验地点 计算机楼A110 机器编号 C06 指导教师 康辉 实验时间 年 月 日 时 分 一、实验综述 1. 实验目的及要求 This exercise is an online lab which creates objects used in a database. At the end of the lab, students should be able to: ? Create tables ? Add referential integrity constraints to a table ? Create indexes ? Add check constraints to a table ? Create views ? Add triggers to a table ? Create an alias ? Access System Catalog information about objects ?Retrieve an XML document 2. 实验设备、软件 PC,?windows?XP Professional,?DB2?9?Express-c 二、实验过程（实验步骤、记录、数据、分析） Section 1 - Create Tables 1. Create your ARTISTS table. The table should have the following characteristics. ? Table schema of student ? Table Name of artists ? Regular data to go in table space dms01 ? Indexes to go in table space dms02 ? Long data to go in table space dms03 ? The column artno should be defined as a primary key ? Columns defined like the following: ( artno smallint not null, name varchar (50), classification char (1) not null, bio clob (100K) logged compact, picture blob (500k) not logged compact) Show your work below by printing screen. 2. Verify the creation of your ARTISTS table and the table description. Important: Ensure the definition of your table is correct. It could cause unexpected failures in later labs if your definitions are not done correctly. Show your work below by printing screen. 3. You will create the remainder of the tables required using a script file called crtables. For Windows, it is located in the C:\labfiles\cf23 directory. Examine the DB2 statements in the file and answer the following questions. In which table space will both the indexes and data for table STOCK be placed? For CONCERTS? For REORDER? The indexes and data for table STOCK will both be placed in table space dms06, for CON