实验2：使用向导创建并管理数据库 (2)

云南大学软件学院实验报告
课程：数据库原理与实用技术实验学期：2011-2012学年第二学期任课教师：专业：软件工程学号：20101120204 姓名：成绩：
实验2使用向导创建并管理数据库
一、实验目的
二、实验内容
SQL Server 2000数据库平台
1.使用企业管理器创建如下数据库：（截图）
2.使用企业管理器创建Employee数据库表：（截图）
3. 练习生成Employee 数据库脚本“employee.sql ”，并分析和记录下脚本信息。

USE [master] GO
/****** Object: Database [Employee] Script Date: 04/05/2012 15:02:23 ******/
CREATE DATABASE [Employee] ON PRIMARY
( NAME = N'employee_data', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DA TA\Employee.mdf' , SIZE = 13696KB , MAXSIZE = 51200KB , FILEGROWTH = 10%)
LOG ON
( NAME = N'employee_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DA TA\Employee.ldf' , SIZE = 5120KB , MAXSIZE = 25600KB , FILEGROWTH = 1024KB )
GO
ALTER DATABASE [Employee] SET COMPA TIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Employee].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Employee] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Employee] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Employee] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Employee] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Employee] SET ARITHABORT OFF
GO
ALTER DATABASE [Employee] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Employee] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Employee] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Employee] SET AUTO_UPDA TE_STATISTICS ON
GO
ALTER DATABASE [Employee] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Employee] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [Employee] SET CONCA T_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Employee] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Employee] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Employee] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Employee] SET DISABLE_BROKER
GO
ALTER DATABASE [Employee] SET AUTO_UPDA TE_STATISTICS_ASYNC OFF GO
ALTER DATABASE [Employee] SET DA TE_CORRELATION_OPTIMIZATION OFF GO
ALTER DATABASE [Employee] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Employee] SET ALLOW_SNAPSHOT_ISOLATION OFF GO
ALTER DATABASE [Employee] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Employee] SET READ_COMMITTED_SNAPSHOT OFF GO
ALTER DATABASE [Employee] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Employee] SET READ_WRITE
GO
ALTER DATABASE [Employee] SET RECOVERY FULL
GO
ALTER DATABASE [Employee] SET MULTI_USER
GO
ALTER DATABASE [Employee] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Employee] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'Employee', N'ON'
GO
USE [Employee]
GO
/****** Object: Table [dbo].[salary] Script Date: 04/05/2012 15:02:23 ******/ SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[salary](
[字段名] [nvarchar](255) NULL,
[数据类型] [nvarchar](255) NULL,
[字段长度] [float] NULL,
[是否允许为空] [nvarchar](255) NULL,
[说明] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[person] Script Date: 04/05/2012 15:02:23 ******/ SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[person](
[字段名] [nvarchar](255) NULL,
[数据类型] [nvarchar](255) NULL,
[字段长度] [float] NULL,
[是否允许为空] [nvarchar](255) NULL,
[说明] [nvarchar](255) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[department] Script Date: 04/05/2012 15:02:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[department](
[字段名] [nvarchar](255) NULL,
[数据类型] [nvarchar](255) NULL,
[字段长度] [float] NULL,
[是否允许为空] [nvarchar](255) NULL,
[说明] [nvarchar](255) NULL
) ON [PRIMARY]
GO
4.使用企业管理器生成Employee数据库表的关系图，并记录。

5.在企业管理其中，直接执行删除表月薪表salary中的Fact列的操作，看是否能执行这一操作。

三．思考题
1、在数据库salary表中要求base不小于300，bonus不小于50如何实现。

2、在数据库雇员信息表person中要求SEX列值只能为“男”或者“女”，如何实现。