數(shù)據(jù)庫應(yīng)用--數(shù)據(jù)完整性實(shí)驗(yàn)答案-文庫吧資料
2024-08-18 08:52本頁面
【正文】 har(6) not null primary key,InCome float not null,OutCome float(8) not null,foreign key(EmployeeID) references Salary(EmployeeID) on update cascade on delete cascade) 實(shí)驗(yàn)名稱數(shù)據(jù)完整性實(shí)驗(yàn)日期實(shí)驗(yàn)?zāi)康恼莆誘ransactSQL語句（CREATE RULE、DROP RULE）創(chuàng)建和刪除規(guī)則的方法。,39。對EmployeeID列進(jìn)行unique約束，并作為表的約束create table Employees5(EmployeeID char(6) not null,Name char(10)not null primary key,Sex tinyint,Education char(4),constraint UK_id unique(EmployeeID))②. 刪除上題中的創(chuàng)建unique約束alter table Employees5drop constraint UK_id ③. 創(chuàng)建新表student，只考慮“號碼”和“性別”兩列，性別只能包含男或女 create table student (號碼 char(6) not null, 性
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號-1