wqe

Tables (9)

Club

  • club_id — INT
  • club_name — VARCHAR2(255)
  • club_code — VARCHAR2(10)

Department

  • DepartmentID — varchar2(20) — Primary key — NOT NULL
  • Office — varchar2(20)
  • Phone — int
  • manager_id — int — NOT NULL

Dependent

  • Relationship — varchar2(10)
  • Name — varchar2(50)
  • Birthdate — varchar2(50)
  • DependentID — int — NOT NULL

Education

  • ProgramCode — int
  • ProgramName — varchar2(100)
  • ProgramDate — varchar2(50)
  • Topic — varchar2(50)

Employee

  • EmployeeID — int — Primary key — NOT NULL
  • Name — varchar2(15)
  • Age — int
  • Address — varchar2(200)
  • ClubID — int
  • ProgramCode — int
  • DepartmentName — varchar2(20) — NOT NULL

EmployeeClub

  • employee_id — INT
  • club_id — INT

EmployeeTraining

  • employee_id — INT
  • program_id — INT

TrainingProgram

  • program_id — INT
  • program_name — VARCHAR2(255)
  • duration — INT
  • topic — VARCHAR2(50)

club

  • ClubID — int
  • ClubName — varchar2(20) — NOT NULL