Database

Tables (8)

Book (NewBook)

  • bookid — Primary key — NOT NULL
  • bookname
  • price
  • pubisher_name (NewPublisher) — Foreign key → Untitled.pubisher_name — NOT NULL

Copy Of Order (CopyOfOrder)

  • user ID (userID) — interger — Primary key — NOT NULL
  • Customer Name (CustomerName) — varchar(20)

Dept (Department)

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

Order 1 (Order)

  • orderID — interger — Primary key — NOT NULL
  • Customer Name (CustomerName) — varchar(20)

Student (Untitled2)

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

Untitled

  • pubisher_name (NewPublisher) — Primary key — NOT NULL
  • contac_name (publisher_name)
  • contact_no

Untitled4

    customer (NewCustomer)

    • Key — Primary key — NOT NULL
    • cust_name (Field)
    • Field2
    • Field3