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)