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