(1)
CREATE TABLE Staff
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Sage SMALLINT,
SJob CHAR(10),
Sal INT,
Dno CHAR(20)
)
CREATE TABLE Department
(Dno CHAR(20) PRIMARY KEY,
Dname CHAR(20),
Manager CHAR(20),
Tel CHAR(10)
)
(2)
CREATE TABLE Department
(Dno CHAR(20) PRIMARY KEY,
Dname CHAR(20),
Manager CHAR(20),
Tel CHAR(10)
)
CREATE TABLE Staff
(Sno CHAR(9) PRIMARY KEY,
Sname CHAR(20),
Sage SMALLINT,
SJob CHAR(10),
Sal INT,
Dno CHAR(20),
FOREIGN KEY(Dno) REFERENCES Department(Dno)
)
(3)
CREATE TAB