Database assignment-Training courses

Tables (8)

Attendance (Untitled4)

  • course_code (CSE_code) — NOT NULL — Foreign key → Courses.course_code — NOT NULL
  • trainee_code (TRN_code) — NOT NULL — Foreign key → Trainees.trainee_code — NOT NULL
  • instructor_code (IST_code) — NOT NULL — Foreign key → Courses.instructor_code — NOT NULL
  • date (Field)
  • period (Field2)

Courses (Untitled3)

  • course_code (CSE_code) — NOT NULL — Primary key — NOT NULL
  • instructor_code (IST_code) — NOT NULL — Foreign key → Instructors.instructor_code — NOT NULL
  • title (Field)
  • places (Field5)
  • times (Field6)

Edition (Untitled7)

  • course_code (CSE_code) — NOT NULL — Foreign key → Courses.course_code — NOT NULL
  • instructor_code (IST_code) — NOT NULL — Foreign key → Courses.instructor_code — NOT NULL
  • start date (Field)
  • end date (Field2)
  • number of participants (Field3)

Instructors (Untitled2)

  • instructor_code (IST_code) — NOT NULL — Primary key — NOT NULL
  • surname (Field)
  • age (Field2)
  • place of birth (Field3)
  • telephone number (Field5)
  • courses taught in the past (Field6)
  • courses that the tutor is qualified to teach (Field7)
  • employment type(by the training company or freelance) (Field8)

Score (Untitled10)

  • trainee_code (TRN_code) — NOT NULL — Foreign key → Trainees.trainee_code — NOT NULL
  • course_code (CSE_code) — NOT NULL — Foreign key → Courses.course_code — NOT NULL
  • instructor_code (IST_code) — NOT NULL — Foreign key → Courses.instructor_code — NOT NULL
  • final assessment (Field)

Trainee who is self-employed (Untitled5)

  • trainee_code (TRN_code) — NOT NULL — Foreign key → Trainees.trainee_code — NOT NULL
  • area of expertise (Field)
  • trainee's title (Field2)

Trainee who works for a company (Untitled6)

  • trainee_code (TRN_code) — NOT NULL — Foreign key → Trainees.trainee_code — NOT NULL
  • level (Field)
  • position (Field2)

Trainees (Untitled)

  • trainee_code (TRN_code) — NOT NULL — Primary key — NOT NULL
  • surname (Field2)
  • age (Field3)
  • sex (Field4)
  • place of birth (Field5)
  • employer's name (Field6)
  • address (Field7)
  • telephone number (Field8)
  • previous employer's name (Field)
  • periods employed (Field9)
  • social security number (Field10)