数据查询与表的创建作业.docVIP

图1 用两种方法建立一个新数据库HRM（也可任意取名）,如上图所示(图1); 鼠标右击数据库HRM- 数据查询,然后输入如下SQLServer语句: DepartmentID CHAR(3) NOT NULL PRIMARY KEY, DepartmentName CHAR(20) NOT NULL, Note TEXT) CREATE TABLE Employee ( EmployeeID CHAR(6) NOT NULL PRIMARY KEY, NAME CHAR(10) NOT NULL, Birthday Datetime NOT NULL, SEX char(2) NOT NULL, Address CHAR(20), Zip CHAR(6), PhoneNumber CHAR(12), EmailAddress CHAR(30), DepartmentID CHAR(3) NOT NULL REFERENCES Departments(DepartmentID)ON DELETE NO ACTION ) CREATE TABLE Salary (EmployeeID CHAR(6) NOT NULL REFERENCES Employee(EmployeeID)ON DELETE NO ACTION, Income FLO