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
customer (NewCustomer)
- Key — Primary key — NOT NULL
- cust_name (Field)
- Field2
- Field3