按如下表数据结构完成数据表的创建。 1)院系表tbDepartment 2)专业表tbMajor 3)教师表tbTeacher 4)班级表tbClass 5)学生表tbStudent 6)课程信息表tbCourse 7)课程教学任务表tbTeachingTasks 8)成绩表tbScore
时间: 2024-03-26 16:38:17 浏览: 54
以下是创建这些表的SQL语句:
1)院系表tbDepartment
```SQL
CREATE TABLE tbDepartment (
DepartmentID INT PRIMARY KEY,
DepartmentName VARCHAR(50),
DeanName VARCHAR(50)
);
```
2)专业表tbMajor
```SQL
CREATE TABLE tbMajor (
MajorID INT PRIMARY KEY,
MajorName VARCHAR(50),
DepartmentID INT,
FOREIGN KEY (DepartmentID) REFERENCES tbDepartment(DepartmentID)
);
```
3)教师表tbTeacher
```SQL
CREATE TABLE tbTeacher (
TeacherID INT PRIMARY KEY,
TeacherName VARCHAR(50),
DepartmentID INT,
FOREIGN KEY (DepartmentID) REFERENCES tbDepartment(DepartmentID)
);
```
4)班级表tbClass
```SQL
CREATE TABLE tbClass (
ClassID INT PRIMARY KEY,
ClassName VARCHAR(50),
MajorID INT,
FOREIGN KEY (MajorID) REFERENCES tbMajor(MajorID)
);
```
5)学生表tbStudent
```SQL
CREATE TABLE tbStudent (
StudentID INT PRIMARY KEY,
StudentName VARCHAR(50),
ClassID INT,
FOREIGN KEY (ClassID) REFERENCES tbClass(ClassID)
);
```
6)课程信息表tbCourse
```SQL
CREATE TABLE tbCourse (
CourseID INT PRIMARY KEY,
CourseName VARCHAR(50),
Credit FLOAT,
DepartmentID INT,
FOREIGN KEY (DepartmentID) REFERENCES tbDepartment(DepartmentID)
);
```
7)课程教学任务表tbTeachingTasks
```SQL
CREATE TABLE tbTeachingTasks (
TaskID INT PRIMARY KEY,
CourseID INT,
TeacherID INT,
ClassID INT,
FOREIGN KEY (CourseID) REFERENCES tbCourse(CourseID),
FOREIGN KEY (TeacherID) REFERENCES tbTeacher(TeacherID),
FOREIGN KEY (ClassID) REFERENCES tbClass(ClassID)
);
```
8)成绩表tbScore
```SQL
CREATE TABLE tbScore (
ScoreID INT PRIMARY KEY,
TaskID INT,
StudentID INT,
Score FLOAT,
FOREIGN KEY (TaskID) REFERENCES tbTeachingTasks(TaskID),
FOREIGN KEY (StudentID) REFERENCES tbStudent(StudentID)
);
```