sql server完成学生成绩管理系统,该系统具备如下功能: (1)对学生实体的信息进行增删改查; (2)对学生选课记录进行增删改查。里面需包含创建的数据库及相关表,以及对表进行操作的代码
时间: 2024-04-05 19:29:30 浏览: 19
好的,下面是一个简单的SQL Server学生成绩管理系统的示例,包括创建数据库、创建表和对表进行操作的代码:
1. 创建数据库:
```
CREATE DATABASE StudentDB
```
2. 创建学生信息表:
```
CREATE TABLE Student (
StudentID INT PRIMARY KEY,
StudentName VARCHAR(50) NOT NULL,
Gender CHAR(1),
Birthday DATE,
ContactNumber VARCHAR(20)
)
```
3. 创建选课记录表:
```
CREATE TABLE Course (
CourseID INT PRIMARY KEY,
CourseName VARCHAR(50) NOT NULL,
Credit INT,
TeacherName VARCHAR(50)
)
CREATE TABLE StudentCourse (
StudentID INT,
CourseID INT,
Score FLOAT,
CONSTRAINT PK_StudentCourse PRIMARY KEY (StudentID, CourseID),
CONSTRAINT FK_StudentCourse_Student FOREIGN KEY (StudentID) REFERENCES Student(StudentID),
CONSTRAINT FK_StudentCourse_Course FOREIGN KEY (CourseID) REFERENCES Course(CourseID)
)
```
4. 插入学生信息:
```
INSERT INTO Student (StudentID, StudentName, Gender, Birthday, ContactNumber)
VALUES (1001, '张三', 'M', '2000-01-01', '12345678901')
```
5. 插入选课记录:
```
INSERT INTO Course (CourseID, CourseName, Credit, TeacherName)
VALUES (2001, '高等数学', 5, '李老师')
INSERT INTO StudentCourse (StudentID, CourseID, Score)
VALUES (1001, 2001, 90)
```
6. 更新学生信息:
```
UPDATE Student
SET ContactNumber = '13912345678'
WHERE StudentID = 1001
```
7. 更新选课记录:
```
UPDATE StudentCourse
SET Score = 95
WHERE StudentID = 1001 AND CourseID = 2001
```
8. 删除学生信息:
```
DELETE FROM Student
WHERE StudentID = 1001
```
9. 删除选课记录:
```
DELETE FROM StudentCourse
WHERE StudentID = 1001 AND CourseID = 2001
```
希望这些代码能够帮助您更好地理解SQL Server学生成绩管理系统的实现过程。如果您有其他问题,请随时提出。