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