Business Requirments
Tables (7)
Course (Co)
- Course code (Co_code) — NOT NULL — Primary key — NOT NULL
- Edition (ED_num) — NOT NULL — Foreign key → Edition.Edition — NOT NULL
- Instructor ID (INS_social_security_number) — NOT NULL — Foreign key → Instructor.Instructor ID — NOT NULL
- Title (Co_title) — NOT NULL
Edition (ED)
- Edition (ED_num) — NOT NULL — Primary key — NOT NULL
- start date (ED_start_date) — NOT NULL
- end date (ED_end_date) — NOT NULL
- number of participant (ED_num_participant) — NOT NULL
Instructor (INS)
- Instructor ID (INS_social_security_number) — NOT NULL — Primary key — NOT NULL
- NAME (INS_surname) — NOT NULL
- age (INS_age) — NOT NULL
- place of birth (INS_place) — NOT NULL
- Telephone (INS_telephone_number) — NOT NULL
- Course name (INS_the couse name and eidition) — NOT NULL
- Career (INS_name_of_class_those_taught_in_the_past) — NOT NULL
- Qulified (INS_Qulified_teaching_in_hers_class) — NOT NULL
Not Self-employed trainee (NONSELF)
- Not self-employed trainee's ID (NONSELF_paritcipant_ID) — NOT NULL — Primary key — NOT NULL
- participant ID (PARTI_SOCIAL_SECURITY_NUMBER) — NOT NULL — Foreign key → Participant.participant ID — NOT NULL
- Course code (Co_code) — NOT NULL — Foreign key → Course.Course code — NOT NULL
- Level (NONSEFL_level_in_job) — NOT NULL
- Position (NONSELF_postion_in_job) — NOT NULL
Participant (PARTI)
- participant ID (PARTI_SOCIAL_SECURITY_NUMBER) — NOT NULL — Primary key — NOT NULL
- Surname (PARTI_NAME) — NOT NULL
- Age (PARTI_Age) — NOT NULL
- SEX (PARTI_SEX) — NOT NULL
- place of birth (PARTI_place) — NOT NULL
- employer's name (PARTI_employer's_name) — NOT NULL
- address (PARTI_address) — NOT NULL
- telephone (PARTI_telephone_num) — NOT NULL
- previous employer (PARTI_pre_employer_name) — NOT NULL
- The course attended (PARTI_attended_course_name) — NOT NULL
- final assessment each course (PARTI_ assessment) — NOT NULL
Self-employed trainee (SELF)
- Self-employed trainee's ID (SELF_participant_ID) — NOT NULL — Primary key — NOT NULL
- participant ID (PARTI_SOCIAL_SECURITY_NUMBER) — NOT NULL — Foreign key → Participant.participant ID — NOT NULL
- Course code (Co_code) — NOT NULL — Foreign key → Course.Course code — NOT NULL
- area of expertise (SELF_name_of_area_of_expertise) — NOT NULL
- title(직함) (SELF_title_in_job) — NOT NULL
Seminar (SE)
- Course code (Co_code) — NOT NULL — Foreign key → Course.Course code — NOT NULL
- Instructor ID (INS_social_security_number) — NOT NULL — Foreign key → Course.Instructor ID — NOT NULL
- attendant trainee (SE_name_of_attendence_trainee) — NOT NULL
- Place (SE_Place_of_seminar) — NOT NULL
- time (SE_time_of_seminar) — NOTNULL