bui cong bang

Tables (4)

Copy Of Order (CopyOfOrder)

  • orderID — integer — Primary key — NOT NULL
  • CustomerName — vachar(20)
  • orderID (orderID2) — integer — Foreign key → Order.orderID — NOT NULL

Dept. (Untitled2)

  • dept_no — integer — Primary key — NOT NULL
  • Dept Name (DeptName) — varchar(25)
  • Student No (StudentNo) — integer — Foreign key → Student.Student No — NOT NULL

Order

  • orderID — integer — Primary key — NOT NULL
  • CustomerName — vachar(20)

Student (Untitled)

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