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