fdsfsd

Tables (4)

Course (Untitled3)

  • Subject Code (varchar[20]) — Primary key — NOT NULL
  • Professor ID (number[8])
  • Subject (number[6])
  • W/N (varchar[2])
  • Student ID (number[7]2) — Foreign key → Student.Student ID — NOT NULL

LMS (Untitled4)

  • Lecture (number[2])
  • Professor Name (varchar[4])
  • Learning (number[4])
  • Percent (number[3])
  • Subject Code (varchar[20]2) — Foreign key → Course.Subject Code — NOT NULL

Schedule (Untitled2)

  • Student ID (number[7])
  • Professor ID (number[8])
  • Building Name (varchar[10])
  • Room (varchar[15])
  • Student ID (number[7]2) — Foreign key → Student.Student ID — NOT NULL
  • Subject Code (varchar[20]) — Foreign key → Course.Subject Code — NOT NULL

Student (Untitled)

  • Student ID (number[7]) — Primary key — NOT NULL
  • name (varchar[5])
  • Department (varchar[8])
  • Gender (varchar[1])
  • Grade (number[1])