대학교

테이블 (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)