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