用sql建立四张数据表并输入数据:教师表: 教师编号,姓名,性别,职称,工资学生表: 学号, 姓名, 性别, 生源课程表: 课程号, 课程名, 课程类型选课表: 学号, 课程号, 成绩
时间: 2024-09-28 11:14:25 浏览: 483
首先,我们需要创建这四张表格,然后分别输入数据。以下是SQL语句示例:
### 教师表 (Teacher)
```sql
CREATE TABLE Teachers (
TeacherID INT PRIMARY KEY,
Name VARCHAR(50),
Gender CHAR(1),
Title VARCHAR(50),
Salary DECIMAL(10, 2)
);
```
### 学生表 (Students)
```sql
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
Name VARCHAR(50),
Gender CHAR(1),
Hometown VARCHAR(100),
FOREIGN KEY (StudentID) REFERENCES Students(StudentID)
);
```
### 课程表 (Courses)
```sql
CREATE TABLE Courses (
CourseID INT PRIMARY KEY,
CourseName VARCHAR(100),
CourseType VARCHAR(50)
);
```
### 选课表 (Enrollments)
```sql
CREATE TABLE Enrollments (
StudentID INT,
CourseID INT,
Grade INT,
PRIMARY KEY (StudentID, CourseID),
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);
```
接下来,我们假设已经有了初始的数据,可以分别插入:
```sql
-- 插入教师数据
INSERT INTO Teachers (TeacherID, Name, Gender, Title, Salary) VALUES (1, '张三', 'M', '教授', 8000.00);
-- ... (插入其他教师数据)
-- 插入学生数据
INSERT INTO Students (StudentID, Name, Gender, Hometown) VALUES (1001, '李四', 'F', '北京');
-- ... (插入其他学生数据)
-- 插入课程数据
INSERT INTO Courses (CourseID, CourseName, CourseType) VALUES (101, '数学', '必修');
-- ... (插入其他课程数据)
-- 插入选课数据
INSERT INTO Enrollments (StudentID, CourseID, Grade) VALUES (1001, 101, 90);
-- ... (插入其他选课数据)
```
阅读全文
相关推荐



















