Individual Assignment #3
Tables (5)
Book(Detail) (Untitled4)
- Book_ID (Key) — Primary key — NOT NULL
- Book_Registration_Date (Key2) — NOT NULL
- Book_Tiltle (Field)
- Book_Edition (Field2)
- ISBN (Field3)
- Book_Publisher (Field4)
- Book_PublicationYear (Field5)
- Book_Category (Field6)
- Book_Pages (Field7)
- Book_Delivery_Date (Field8)
Book_Author (Untitled5)
- Author_ID (PK) — Primary key — NOT NULL
- Author_Name (Field)
- Author_Career (Field2)
- Author_afiliation (Field3)
- Author_RegistrationDate (Field4)
Book_Order_Form (Untitled3)
- Order_Num (Key) — Primary key — NOT NULL
- Book_Title (Field)
- Book_Author (Field2)
- ISBN (Field3)
- Book_Publisher (Field4)
- Book_Date (Field5)
User (Untitled)
- User_ID (PK) — INT — Primary key — NOT NULL
- User_Name (Field)
- User_Email (Field2)
- User_PhoneNumber (Field3)
User_Position (Untitled2)
- Key — Primary key — NOT NULL
- Position (Field)