erd

Tables (5)

book (Untitled3)

  • bno (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar
  • author (Field2) — varchar

dongari (Untitled2)

  • did (Key) — int — Primary key — NOT NULL
  • dname (Field) — varchar

dongarijoin (Untitled5)

  • dno (Key) — int — Primary key — NOT NULL
  • sno (Key2) — int — Foreign key → student.sno — NOT NULL
  • did (Key3) — int — Foreign key → dongari.did — NOT NULL
  • rdate (Field) — date

rent (Untitled4)

  • rno (Key3) — int — Primary key — NOT NULL
  • rdate (Field) — date
  • sno (Key) — int — Foreign key → student.sno — NOT NULL
  • bno (Key2) — int — Foreign key → book.bno — NOT NULL

student (Untitled)

  • sno (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • department (Field2) — varchar