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)