实验 11-2 表的创建
一、实验目的、内容、原理
参见《数据库原理与设计(第 2 版)》第 391 页。
二、实验代码、结果与问题
1. 实验代码
CREATE TABLE person20092586
(
P_no char(6) PRIMARY KEY,
P_name varchar(10) NOT NULL,
Sex char(2) NOT NULL,
Birthdate datetime NULL,
Date_hired datetime NOT NULL,
Deptname varchar(10) NOT NULL DEFAULT'培训部',
P_boss char(6) NULL,
CONSTRAINT birth_hire_check20092586
CHECK (Birthdate<Date_hired)
)
CREATE TABLE salary20092586
(
P_no char(6) PRIMARY KEY,
CONSTRAINT P_no_contr
FOREIGN KEY(P_no)
REFERENCES person20092586(P_no)
ON DELETE CASCADE
ON UPDATE CASCADE,
Base dec(5) NULL,
Bonus dec(5) NULL,
Fact AS Base+Bonus
)
CREATE TABLE customer20092586
(
Cust_no char(6) PRIMARY KEY,
Cust_name varchar(10) NOT NULL,
Sex char(2) NOT NULL,
Birthdate datetime NULL,
City varchar(10) NULL,
Discount dec(3,2) NOT NULL DEFAULT'1.00'
CHECK(Discount>=0.50 AND Discount<=1.00)
评论0