sampledb

Tables (5)

branch_master (Untitled)

  • branch (Key) — VARCHAR(255) — Primary key — NOT NULL

course_master (Untitled3)

  • course (Key) — VARCHAR(255) — Primary key — NOT NULL

courses (Untitled4)

  • course (Key) — VARCHAR(255) — Foreign key → course_master.course — NOT NULL
  • student_id (Key2) — CHAR(5) — Foreign key → students.student_id — NOT NULL

exams (Untitled5)

  • exam_no (Key2) — INT — Primary key — NOT NULL
  • subject (Key3) — VARCHAR(255) — Primary key — NOT NULL
  • student_id (Key) — CHAR(5) — Foreign key → students.student_id — NOT NULL
  • score (Field) — INT

students (Untitled2)

  • student_id (Key) — CHAR(5) — Primary key — NOT NULL
  • student_name (Field) — VARCHAR(255)
  • mobile_phone (Field2) — VARCHAR(255)
  • school (Field3) — VARCHAR(255)
  • branch (Key2) — VARCHAR(255) — Foreign key → branch_master.branch — NOT NULL