MyFirstProject

Tables (8)

Copy Of Order (CopyOfOrder)

  • userID — integer — Primary key — NOT NULL
  • CustomerName — varchar(20)
  • orderID — integer — Foreign key → L_Order1.orderID — NOT NULL

Dept. (Department)

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

L_Order1 (P_Order)

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

Publisher (Newpublisher)

  • Publisher_name — varchar(40) — Primary key — NOT NULL
  • contact_name — varchar(20)
  • contact_no — varchar(20)

Student (Untitled)

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

book (NewBook)

  • bookid — integer — Primary key — NOT NULL
  • bookname — varchar(40)
  • price
  • Publisher_name — integer — Foreign key → Publisher.Publisher_name — NOT NULL
  • Field2

customer (NewCustomer)

  • custid — Primary key — NOT NULL
  • cust_name
  • address — Varchar(60)
  • Phone (phone)

order (NewOrder)

  • orderid — Primary key — NOT NULL
  • order_date
  • sale_price
  • bookid — Foreign key → book.bookid — NOT NULL
  • custid — Foreign key → customer.custid — NOT NULL