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