这是考试题要求创建下面的表。
Student(student number, surname, forename, gender, title, date of birth, department number, course number);
Staff(staff number, surname, forename, gender, title, date of birth, salary, department number);
Department(department number, department name);
Course( course number, course name, department number);
Unit(unit number, unit name, course number);
Result(student number, unit name, course number);
Attendance(student number, unit number, date, attended);
------解决方案--------------------
这是第一个表,其他表类似
CREATE TABLE Student
(
[student number] INT ,
surname VARCHAR(20) ,
forename VARCHAR(20) ,
gender BIT ,
title VARCHAR(20) ,
[date of birth] DATETIME ,
[department number] INT ,
[course number] INT
)