数据库软件举例演示.doc

create table perso( 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_check2276 check (BirthdateDate_hired) create table custome( 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 constraint discount_n check (Discount BETWEEN 0.50 and 1.00) ) create table orderdetai( Order_no char(6) PRIMARY KEY, CONSTRAINT Order_no_constrain check (Order_no LIKE [A-Z][A-Z][0-9][0-9]), Cust_no char(6) not null, P_no char(6) not null, Order_total int not null, Order_date datetime not null, constraint person_cont foreign key (P_no) references perso(P_no) on delete cascade on update cascade, constraint customer_conct foreign key (Cust_no) references custome(Cust_no) on delete cascade on update cascade ) create table salar( P_no char(6) primary key constraint P_no_constrain foreign key (P_no) references perso(P_no) on delete cascade on update cascade, Base dec(5) null, Bonus dec(5) null, Fact AS Base+Bonus, ) 删除person中的数据 查询 create table perso( 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_check2276 check (BirthdateDate_hired) ) create table custome( 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 constraint discount_n check (Discount BETWEEN