ER Design
Tables (12)
Class
- time (Cl_time) — NOT NULL — Primary key — NOT NULL
- place (Cl_place) — NOT NULL — Primary key — NOT NULL
- date (Cl_date) — NOT NULL — Primary key — NOT NULL
Company_employed
- level (Co_level) — NOT NULL
- position (Co_position) — NOT NULL
- code (Tr_code) — NOT NULL — Foreign key → Trainee.code — NOT NULL
- social security number (Tr_ssn) — NOT NULL — Foreign key → Trainee.social security number — NOT NULL
Course
- code (Cs_code) — NOT NULL — Primary key — NOT NULL
- title (Cs_title) — NOT NULL
Course Edition
- code (Cs_code) — NOT NULL — Foreign key → Course.code — NOT NULL
- start date (CE_sd) — NOT NULL — NOT NULL
- end date (CE_ed) — NOT NULL — NOT NULL
- number of participants (CE_nop) — NOTNULL
- time (Cl_time) — NOT NULL — Foreign key → Class.time — NOT NULL
- place (Cl_place) — NOT NULL — Foreign key → Class.place — NOT NULL
- date (Cl_date) — NOT NULL — Foreign key → Class.date — NOT NULL
Employer
- name (Em_name) — NOT NULL — Primary key — NOT NULL
- address (Em_add) — NOT NULL
- telephone number (Em_tn) — NOT NULL
- period (Em_period) — NOTNULL
Final (final assessment)
- final assessment (Fin_ass) — NOT NULL — Primary key — NOT NULL
- code (Cs_code) — NOT NULL — Foreign key → Course Edition.code — NOT NULL
Freelence
- social security number (Ins_ssn) — NOT NULL — Foreign key → Instructor.social security number — NOT NULL
Instructor
- social security number (Ins_ssn) — NOT NULL — Primary key — NOT NULL
- surname (Ins_sn) — NOT NULL
- age (Ins_Age) — NOT NULL
- place of birth (Ins_pob) — NOT NULL
- telephone number (Ins_num) — NOT NULL
- code (Cs_code) — NOT NULL — Foreign key → Course Edition.code — NOT NULL
- past experience (Ins_exp) — NOT NULL
- Qualification (Cs_qua) — NOT NULL — Foreign key → Qualification.qualification — NOT NULL
Permanently Employed
- social security number (Ins_ssn) — NOT NULL — Foreign key → Instructor.social security number — NOT NULL
Qualification
- qualification (Cs_qua) — NOT NULL — Primary key — NOT NULL
- code (Cs_code) — NOT NULL — Foreign key → Course.code — NOT NULL
Self-employed
- expertise (Se-exp) — NOT NULL
- title (Se_title) — NOT NULL
- code (Tr_code) — NOT NULL — Foreign key → Trainee.code — NOT NULL
- social security number (Tr_ssn) — NOT NULL — Foreign key → Trainee.social security number — NOT NULL
Trainee
- code (Tr_code) — NOT NULL — Primary key — NOT NULL
- social security number (Tr_ssn) — NOT NULL — Primary key — NOT NULL
- surname (Tr_sname) — NOT NULL
- age (Tr_age) — NOT NULL
- sex (Tr_sex) — NOT NULL
- place of birth (Tr_pob) — NOT NULL
- name (Em_name) — NOT NULL — Foreign key → Employer.name — NOT NULL
- code (Cs_code) — NOT NULL — Foreign key → Course Edition.code — NOT NULL
- final assessment (Fin_ass) — NOT NULL — Foreign key → Final.final assessment — NOT NULL