用SQL创建一个研究生招生管理系统
时间: 2024-07-17 11:00:44 浏览: 44
创建一个研究生招生管理系统的SQL数据库涉及到设计多个表,以存储不同的数据实体,如学生信息、课程信息、申请信息等。这里我会提供一个基本的架构和几个关键表的例子:
1. **学生表(Student)**:
```sql
CREATE TABLE Students (
StudentID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
GPA FLOAT,
Degree VARCHAR(50),
DepartmentID INT,
FOREIGN KEY (DepartmentID) REFERENCES Departments(DepartmentID)
);
```
2. **课程表(Courses)**:
```sql
CREATE TABLE Courses (
CourseID INT PRIMARY KEY,
CourseName VARCHAR(100),
Instructor VARCHAR(50),
Credits INT
);
```
3. **部门表(Departments)**:
```sql
CREATE TABLE Departments (
DepartmentID INT PRIMARY KEY,
DepartmentName VARCHAR(50)
);
```
4. **申请表(Applications)**:
```sql
CREATE TABLE Applications (
ApplicationID INT PRIMARY KEY,
StudentID INT,
CourseID INT,
ApplicationDate DATE,
Status ENUM('Pending', 'Accepted', 'Rejected'),
FOREIGN KEY (StudentID) REFERENCES Students(StudentID),
FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);
```
5. **成绩表(Grades)**:
```sql
CREATE TABLE Grades (
GradeID INT PRIMARY KEY,
ApplicationID INT,
CourseGrade FLOAT,
FOREIGN KEY (ApplicationID) REFERENCES Applications(ApplicationID)
);
```