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