picture

Tables (4)

Untitled

  • student no. (StudentNo.) — inerger — Primary key — NOT NULL
  • student name (Student Name) — varchar(25)
  • Address — varchar(40)
  • Phone — interger

Untitled2

  • dept_no — inerger — Primary key
  • Dept_Name (Dept_name) — Varchar(20)
  • student no. (Key) — Foreign key → Untitled.student no. — NOT NULL

Untitled3

  • Key — Primary key — NOT NULL
  • Field
  • Field2

Untitled4