ERDTest2

Tables (3)

Student

  • student_no — nvarchar2(30) — Primary key — NOT NULL
  • name — nvar2char(30)
  • phone_no — number

register

  • registerno — number — Primary key — NOT NULL
  • student_no — nvarchar2(30) — Primary key — NOT NULL
  • grade — nvarchar2(30)
  • student_no (student_no2) — nvarchar2(30) — Foreign key → Student.student_no — NOT NULL
  • subject_no — number — Foreign key → subject.subject_no — NOT NULL

subject

  • subject_no — number — Primary key — NOT NULL
  • subject_name — nvarchar(30)
  • grade — number
  • subject_no (subject_no2) — number — Foreign key → subject.subject_no — NOT NULL