assignment1

Tables (7)

course (Untitled3)

  • course_code (CUR_CODE) — NOT NULL — Primary key — NOT NULL
  • course_title (CUR_TITLE) — NOT NULL — Primary key — NOT NULL
  • trainee_code (TRE_CODE) — NOT NLULL — Foreign key → trainee(course particioant).trainee_code — NOT NULL
  • train_area of expertise (SEL_EXPERTISE) — NOT NLULL — Foreign key → trainee(course particioant).train_area of expertise — NOT NULL
  • instructor_surname (INS_SURNAME) — NOT NULL — Foreign key → instructor.instructor_surname — NOT NULL

edition (Untitled4)

  • edition_startdate (EDI_START) — NOT NULL — Primary key — NOT NULL
  • trainee_code (TRE_CODE) — NOT NLULL — Foreign key → trainee(course particioant).trainee_code — NOT NULL
  • train_area of expertise (SEL_EXPERTISE) — NOT NLULL — Foreign key → trainee(course particioant).train_area of expertise — NOT NULL
  • edition_enddate (EDI_END) — NOT NULL
  • edition_number of participants (EDI_NUM) — NOT NULL

instructor (Untitled7)

  • instructor_surname (INS_SURNAME) — NOT NULL — Primary key — NOT NULL
  • instructor_age (INS_AGE) — NOT NULL
  • instructor_place of birth (INS_BIRTH) — NOT NULL
  • instructor_the edition of the course taught in the past (INS_TAUGHT) — NOT NULL
  • instructor_the courses that the tutor is qualified to teach (INS_QUALIFIED) — NOT NULL
  • instructor_telephone (INS_PHONE) — NOT NULL
  • instructor_empoyment type (INS_EMPLOYED) — NOT NULL

self-employed(train) (Untitled5)

  • train_area of expertise (SEL_EXPERTISE) — NOT NLULL — Primary key — NOT NULL
  • train_title (SEL_TITLE) — NOT NLULL

seminars (Untitled2)

  • seminar_day (SEN_DAY) — NOT NULL — Primary key — NOT NULL
  • trainee_code (TRE_CODE) — NOT NLULL — Foreign key → trainee(course particioant).trainee_code — NOT NULL
  • train_area of expertise (SEL_EXPERTISE) — NOT NLULL — Foreign key → trainee(course particioant).train_area of expertise — NOT NULL
  • seminar_place (SEN_PLACE) — NOT NULL
  • seminar_time (SEN_TIME) — NOT NULL

trainee(course particioant) (Untitled)

  • trainee_code (TRE_CODE) — NOT NLULL — Primary key — NOT NULL
  • train_area of expertise (SEL_EXPERTISE) — NOT NLULL — Foreign key → self-employed(train).train_area of expertise — NOT NULL
  • trainee_socialsecuritynumber (TRE_NUM) — NOT NLULL
  • trainee_surname (TRE_SURNAME) — NOT NLULL
  • trainee_age (TRE_AGE) — NOT NLULL
  • trainee_sex (TRE_SEX) — NOT NLULL
  • trainee_placeofbirth (TRE_BIRTH) — NOT NLULL
  • trainee_employer’s name (TRE_EMPLOYER) — NOT NLULL
  • trainee_address (TRE_ADD) — NOT NLULL
  • trainee_telephonenumber (TRE_TELEPHONE) — NOT NLULL
  • trainee_previous employers (TRE_PREVIOUS) — NOT NLULL
  • trainee_course (TRE_COURSE) — NOT NLULL
  • trainee_thefinalassessment (TRE_ASSESSMENT) — NOT NLULL

works for a company(train) (Untitled6)

  • train_the level (COM_LEVEL) — NOT NLULL — Primary key — NOT NULL
  • trainee_code (TRE_CODE) — NOT NLULL — Foreign key → trainee(course particioant).trainee_code — NOT NULL
  • train_area of expertise (SEL_EXPERTISE) — NOT NLULL — Foreign key → trainee(course particioant).train_area of expertise — NOT NULL
  • train_position (COM_POSITION) — NOT NLULL