과제

테이블 (5)

Course(Edition) (강의정보)

  • Course_Code (Code) — NOT NULL — 기본 키 — NOT NULL
  • Place — NOT NULL
  • Time — NOT NULL
  • Title — NOT NULL
  • Start_date (SD) — NOT NULL
  • End_date (ED) — NOT NULL
  • Number_of_participants (NoP) — NOT NULL

Course_taught (교육자-강의정보)

  • Course_Code (Code) — NOT NULL — 외래 키 → Course(Edition).Course_Code — NOT NULL
  • Instructor_social_security_number (ISSN) — NOT NULL — 외래 키 → Instructor.Instructor_social_security_number — NOT NULL
  • Course_Taught (CT) — NOT NULL

Courses_attended (학생-강의정보)

  • Participant_social_security_number (PSSN) — NOT NULL — 외래 키 → Participant.Participant_social_security_number — NOT NULL
  • Course_Code (Code) — NOT NULL — 외래 키 → Course(Edition).Course_Code — NOT NULL
  • Attendence — NOT NULL
  • Final_assessment (FA) — NOT NULL

Instructor (교육자정보)

  • Instructor_social_security_number (ISSN) — NOT NULL — 기본 키 — NOT NULL
  • Surname (Sname) — NOT NULL
  • Age — NOT NULL
  • Place_of_birth (PoB) — NOT NULL
  • Qualified_to_teach (Q2T) — NOT NULL
  • Telephone_Number (TPN) — NOT NULL
  • Company_or_freelance (CoF) — NOT NULL

Participant (학생정보)

  • Participant_social_security_number (PSSN) — NOT NULL — 기본 키 — NOT NULL
  • Surname (SName) — NOT NULL
  • Age — NOT NULL
  • Sex — NOT NULL
  • Place_of_birth (PoB) — NOT NULL
  • Employer's_name (EName) — NULL
  • Address (Adress) — NOT NULL
  • Telephone_number (TPN) — NOT NULL
  • Previous_employers (PvE) — NULL
  • Preiods_employed (PdE) — NULL
  • Area_of_expertise (AoE) — NULL
  • Title — NULL