数据库.doc

云南大学软件学院 实验报告课程： 数据库原理与实用技术实验 学期： 任课教师： 专业： 学号： 姓名： 成绩： Exercise 3_ Create ObjectsSection 1 Create Tables1. From your Control Center session, create your Artists table. _ _ _2. Verify the creation of your Artists table. 3. Now switch to your Command Center session where you will create the remainder of the tables required. In which table space will both the indexes and data for the table STOCK be placed? For CONCERTS? For REORDER? 4. Execute the CRTABLES script to create the tables.Section 2 Create IndexesIn this section you will be creating the indexes needed by several of the tables.1. Now that your tables are created, you can create the indexes. Use the Control Center to create an index called item on the itemno column in stock table. 2. Now create another index via the Control Center. Create a unique index calleditemno on the itemno column in albums table. 3. List the Indexes via the Control Center. Are your two new indexes shown? Note the index beginning with CC. listed at the top of the pane. Did you create this index? If not, how did it get created?_ _ _4. Information about indexes can also be found by accessing the SYSCAT.INDEXES view. Do you see your new indexes?_Section 3 Create ViewsIn this section, you will create two views that will be used in a later lab.1. From the Control Center, create a view called music that will 2. Now create another view called inventory by executing a script command file from the Command Center. The file named CRVIEW is located in the X:cf23 directory. 3. List the Views via the Control Center. Are your two new views shown?_Section 4 Create Alias1. Create an alias called singers for the ARTISTS table, and an alias called emptystock for the REORDER table. 2. List the Aliases via the Control Center. Are your two new aliases shown?_Section 7 Create a Trigger1. Create a trigger which has the fol