ㄹㅇㅁ

Tables (5)

BOOKS

  • Registration_Number — CHAR(10) — Primary key — NOT NULL
  • B_Name — VARCHAR(100) — NOT NULL
  • Author — VARCHAR(100) — NOT NULL
  • Publisher — VARCHAR(100) — NOT NULL
  • P_Year — CHAR(4) — NOT NULL
  • Category_key — NVARCHAR(20) — NOT NULL
  • Location — NVARCHAR(20) — NOT NULL
  • CURRENCY — NVARCHAR(20) — NOT NULL
  • PRICE — DECIMAL(10,2) — NOT NULL
  • ISBN — CHAR(13) — NOT NULL
  • Status — ENUM('B','R') — NOT NULL

DEPARTMENT

  • Dept_ID — INT — Primary key — NOT NULL
  • Dept_NAME — VARCHAR(100) — NOT NULL

FACULTY

  • Faculty_ID — CHAR(9) — Primary key — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Fname — VARCHAR(100) — NOT NULL
  • Fclass — ENUM('Professor','Staff','TA') — NOT NULL
  • Gender — ENUM('Male','Female') — NOT NULL
  • Dept_ID — INT — NOT NULL
  • Date_of_Birth — CHAR(10) — NOT NULL
  • Email_Address — VARCHAR(100) — NOT NULL
  • Phone_number — CHAR(13) — NOT NULL

STUDENT

  • Student_ID — CHAR(9) — Primary key — NOT NULL
  • Name — VARCHAR(100) — NOT NULL
  • Fname — VARCHAR(100) — NOT NULL
  • Gender — ENUM('Male','Female') — NOT NULL
  • Date_of_Birth — CHAR(10) — NOT NULL
  • Email_Address — VARCHAR(100) — NOT NULL
  • Phone_number — CHAR(13) — NOT NULL
  • Dept_ID — INT — Foreign key → DEPARTMENT.Dept_ID — NOT NULL

S_RENT

  • Time — DATETIME — NOT NULL
  • Type — ENUM('B','R') — NOT NULL
  • Student_ID — CHAR(9) — Foreign key → STUDENT.Student_ID — NOT NULL
  • Registration_Number — CHAR(10) — Foreign key → BOOKS.Registration_Number — NOT NULL