School-System

Tables (5)

Lecture (Untitled4)

  • L_id (Key) — int — Primary key — NOT NULL
  • P_id (PK2) — int — Foreign key → Professor.P_id — NOT NULL
  • M_id (PK) — int — Foreign key → Major.M_id — NOT NULL
  • name (Field) — varchar(20) — NOT NULL
  • L_info (Field2) — varchar(50)
  • date (Field3) — date

List (Untitled5)

  • L_id (Key) — int — Foreign key → Lecture.L_id — NOT NULL
  • P_id (PK2) — int — Foreign key → Lecture.P_id — NOT NULL
  • S_id (PK) — int — Foreign key → Student.S_id — NOT NULL
  • attendance (Field) — int — NOT NULL
  • First_point (Field2) — int — NOT NULL
  • Last_point (Field3) — int — NOT NULL
  • etc_point (Field4) — int
  • sum_point (Field5) — int — NOT NULL
  • avg_point (Field6) — int — NOT NULL

Major (학과)

  • M_id (PK) — int — Primary key — NOT NULL
  • M_name (Field) — varchar(20) — NOT NULL
  • M_phone (Field2) — varchar(20)

Professor (교수)

  • P_id (PK) — int — Primary key — NOT NULL
  • name (Field) — varchar(10) — NOT NULL
  • ID_CARD (Field2) — varchar(20)
  • P_address (Field3) — varchar(40)
  • P_phone (Field4) — varchar(20) — NOT NULL
  • P_e_mail (Field5) — varchar(40)
  • P_photo (Field6) — block
  • M_id (PK2) — int — Foreign key → Major.M_id — NOT NULL

Student (Untitled)

  • S_id (PK) — int — Primary key — NOT NULL
  • S_name (Field) — varchar(10) — NOT NULL
  • ID_CARD (Field2) — varchar(20) — NOT NULL
  • S_address (Field3) — varchar(40) — NOT NULL
  • S_phone (Field4) — varchar(20) — NOT NULL
  • S_e_mail (Field5) — varchar(40)
  • S_photo (Field6) — block
  • M_id (PK2) — int — Foreign key → Major.M_id — NOT NULL
  • P_id (PK3) — int — Foreign key → Professor.P_id — NOT NULL