대학교
테이블 (9)
Copy Of Untitled (교수)
- Key (Id) — 기본 키 — NOT NULL
- Field (Name)
- Field (Contact_Information)
- Field2 (Gender)
- Field (Major)
- Field (Current_Courses_Taught)
- Field (Student_Advising)
Copy Of Untitled2 (성적관리)
- Key (Id) — 기본 키 — NOT NULL
- Key (Std_Id) — 외래 키 → Untitled.Key — NOT NULL
- Key (Class_Id) — 외래 키 → Untitled2.Key — NOT NULL
- Key (Std_Advisor) — 외래 키 → Untitled.Key — NOT NULL
- Field (Std_Name)
- Field (Grades)
- Field (Academic_Year)
Copy Of Untitled3 (학부)
- Key (Id) — 기본 키 — NOT NULL
- Field (Name)
- Field2 (Department_Head)
- Field (Affiliated_Department)
Untitled (학생)
- Key (Id) — 기본 키 — NOT NULL
- Key (Advisor) — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Field (Name)
- Field (Contact_Information)
- Field2 (Gender)
- Field3 (Grades)
- Field (Enrollment_Information)
Untitled (학과)
- Key (Id) — 기본 키 — NOT NULL
- Key (Undergraduate_Id) — 외래 키 → Copy Of Untitled3.Key — NOT NULL
- Field (Name)
- Field2 (Department_Head)
- Field (Faculty_Professor)
- Field (Class_List)
Untitled (이수 전공)
- Key (Id) — 기본 키 — NOT NULL
- Key (Major_Id) — 외래 키 → Untitled.Key — NOT NULL
- Key (Std_Id) — 외래 키 → Untitled.Key — NOT NULL
- Key (Std_Advisor) — 외래 키 → Untitled.Key — NOT NULL
- Key (Undergraduate_Id) — 외래 키 → Untitled.Key — NOT NULL
- Field (Major)
Untitled (장학금)
- Key (Id) — 기본 키 — NOT NULL
- Field (Name)
- Field2 (Scholarship_Amount)
- Field3 (Scholarship_Type)
- Field (Scholarship_Eligibility_Criteria)
Untitled (장학이력)
- Key (Id) — 기본 키 — NOT NULL
- Key (Std_Id) — 외래 키 → Untitled.Key — NOT NULL
- Key (Std_Advisor) — 외래 키 → Untitled.Key — NOT NULL
- Key (Scholarship_Id) — 외래 키 → Untitled.Key — NOT NULL
- Field (Amount_Received)
Untitled2 (수업)
- Key (Id) — 기본 키 — NOT NULL
- Field (Name)
- Field (Instructor)
- Field (Class_Schedule)
- Field (Class_Format)
- Field (Class_Evaluation)
- Field (Semester)