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