First Project

Tables (6)

Book (NewBook)

  • bookid — Primary key — NOT NULL
  • bookname
  • price
  • publisher_name (publisher_ name) — Foreign key → publisher.publisher_name — NOT NULL

Copy Of Order (CopyOfOrder)

  • orderID — integer — Primary key — NOT NULL
  • CustomerName — varchar(20)
  • Key — NOT NULL
  • orderID (orderID2) — integer — Foreign key → L-Order.orderID — NOT NULL

Dept. (Department)

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

L-Order (P-Order)

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

Student (Untitled)

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

publisher (NewPublisher)

  • publisher_name (publisher_ name) — Primary key — NOT NULL
  • contact_name
  • contact_no