sql server create语句创建学生表,课程表,学生-课程表
时间: 2024-05-10 12:20:10 浏览: 15
创建学生表:
```
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(50) NOT NULL,
Age INT NOT NULL,
Gender CHAR(1) NOT NULL
);
```
创建课程表:
```
CREATE TABLE Courses (
CourseID INT PRIMARY KEY,
Name VARCHAR(50) NOT NULL,
CreditHours INT NOT NULL
);
```
创建学生-课程表:
```
CREATE TABLE StudentCourses (
StudentID INT,
CourseID INT,
Grade DECIMAL(5, 2),
PRIMARY KEY (StudentID, CourseID),
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);
```
相关问题
sql server create语句创建学生-课程表
CREATE TABLE student_course (
student_id INT NOT NULL,
course_id INT NOT NULL,
grade INT,
PRIMARY KEY (student_id, course_id),
FOREIGN KEY (student_id) REFERENCES students(id),
FOREIGN KEY (course_id) REFERENCES courses(id)
);
其中,students和courses为学生表和课程表的表名,id为主键。
用sqlServer语句创建课程表,完成排课管理操作,并输出学生和教师的课表
好的,以下是创建课程表的 SQL Server 语句:
首先,创建一个课程表的表格:
```
CREATE TABLE CourseSchedule (
CourseID INT NOT NULL,
TeacherID INT NOT NULL,
StudentID INT NOT NULL,
CourseName VARCHAR(50) NOT NULL,
CourseTime VARCHAR(20) NOT NULL,
CONSTRAINT PK_CourseSchedule PRIMARY KEY (CourseID)
);
```
然后,向表格中插入一些数据:
```
INSERT INTO CourseSchedule (CourseID, TeacherID, StudentID, CourseName, CourseTime)
VALUES (1, 101, 1001, '数学', '周一 10:00-12:00'),
(2, 102, 1002, '语文', '周一 14:00-16:00'),
(3, 103, 1003, '英语', '周二 8:00-10:00'),
(4, 104, 1004, '物理', '周二 10:00-12:00'),
(5, 105, 1005, '化学', '周三 10:00-12:00');
```
接下来,我们可以根据需要进行各种排课管理操作,例如:
1. 查询某个学生的课表:
```
SELECT CourseName, CourseTime
FROM CourseSchedule
WHERE StudentID = 1001;
```
2. 查询某个老师的课表:
```
SELECT CourseName, CourseTime
FROM CourseSchedule
WHERE TeacherID = 101;
```
3. 查询某个时间段内的所有课程:
```
SELECT CourseName, TeacherID, StudentID
FROM CourseSchedule
WHERE CourseTime LIKE '周二%';
```
希望这些 SQL 语句能够帮助你完成排课管理操作,并输出学生和教师的课表。