10

Tables (5)

Department

  • dept_no — integer — Primary key — NOT NULL
  • Student No. — integer — Foreign key → Untitled2.Student No. — NOT NULL
  • Dept_Name (DeptName) — varchar(20)

Oder

  • oderID — integer — Primary key — NOT NULL
  • Customer Name (CustomeName) — varchar(20)

Untitled

  • userID — integer — Primary key — NOT NULL
  • Customer Name (CustomerName) — varchar(20)
  • oderID — integer — Foreign key → Oder.oderID — NOT NULL

Untitled2

  • Student No. — integer — Primary key — NOT NULL
  • Student Name — varchar(25)
  • Address — varchar(40)
  • Phone — integer

Untitled3

  • pubisher_name (NewPubisher) — bookid — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4