Charming

Tables (5)

Copy Of Order2 (CopyOfOrder2)

  • OrderID — Integer — Primary key — NOT NULL
  • CustomerName — varchar(20)
  • OrderID (OrderID2) — Integer — Foreign key → Order.OrderID — NOT NULL

Dept. (Department)

  • dept.no — integer — Primary key — NOT NULL
  • Student no — integer — Foreign key → Student.Student no — NOT NULL
  • Dept.name — varchar(20)

Order

  • OrderID — Integer — Primary key — NOT NULL
  • CustomerName — varchar(20)

Publisher (Newpublisher)

  • publisher.name — Primary key — NOT NULL
  • contact.name
  • contact.no

Student (Untitled 2)

  • Student no — integer — Primary key — NOT NULL
  • Student name — varchar(25)
  • Address — varchar(40)
  • Phone — integer