Assignment

Tables (7)

Course (Untitled2)

  • course_code (CSE_CODE) — not null — Primary key — NOT NULL
  • course_title (CSE_TITLE) — not null — Primary key — NOT NULL
  • student_id (STD_ID) — not null — Foreign key → Trainee.trainee_code — NOT NULL
  • instructor_surname (IST_SURNAME) — not null — Foreign key → Instructor.instructor_surname — NOT NULL
  • course_startdate (CSE_START) — not null
  • course_enddate (CSE_ENDDATE) — not null
  • course_participants (CSE_PARTICIPANTS) — not null

Courses (Untitled6)

  • trainee_courses (TRN_COURSE) — not null — Primary key — NOT NULL
  • Courses_finalassessment (CSES_FINAL) — not null
  • Field

Employer (Untitled4)

  • trainee_employername (TRN_EMPLOYER) — not null — Primary key — NOT NULL
  • employer_address (EMP_ADDRESS) — not null
  • employer_telephone (EMP_TELEPHONE) — not null

Instructor (Untitled3)

  • instructor_surname (IST_SURNAME) — not null — Primary key — NOT NULL
  • instructor_age (IST_AGE) — not null
  • instructor_placeofbirth (IST_BIRTH) — not null
  • instructor_edition (IST_EDITION) — not null
  • instructor_past (IST_PASTEDITION) — not null
  • instructor_teach (IST_QUALIFIED) — not null
  • instructor_telephone (IST_TELEPHONE) — not null

Previous (Untitled5)

  • trainee_previousemploys (TRN_PREVIOUS) — not null — Primary key — NOT NULL
  • previous_periodsemployed (PRE_PERIODS) — not null

Seminar (Untitled7)

  • trainee_seminars (TRN_SEMINAR) — not null — Primary key — NOT NULL
  • Seminar_placestimes (SEM_PLACEANDTIME) — not null
  • Field

Trainee (Untitled)

  • trainee_code (TRN_CODE) — not null — Primary key — NOT NULL
  • trainee_previousemploys (TRN_PREVIOUS2) — not null — Foreign key → Previous.trainee_previousemploys — NOT NULL
  • trainee_employername (TRN_EMPLOYER2) — not null — Foreign key → Employer.trainee_employername — NOT NULL
  • trainee_courses (TRN_COURSE2) — not null — Foreign key → Courses.trainee_courses — NOT NULL
  • trainee_seminars (TRN_SEMINAR2) — not null — Foreign key → Seminar.trainee_seminars — NOT NULL
  • trainee_socialsecuritynumber (TRN_NUMBER) — not null
  • trainee_surname (TRN_SURNAME) — not null
  • trainee_age (TRN_AGE) — not null
  • trainee_employername (TRN_EMPLOYER) — not null
  • trainee_placeofbirth (TRN_BIRTH) — not null
  • trainee_courses (TRN_COURSE) — not null
  • trainee_seminars (TRN_SEMINAR) — not null
  • trainee_previousemploys (TRN_PREVIOUS) — not null