homework1-3_final
Tables (6)
Major_department (CopyOfUntitled3)
- department_name (Field) — VARCHAR(20) — Primary key
- department_code (Field2) — BIGINT — Primary key
- office_number (Field3) — BIGINT
- office phone (Field4) — VARCHAR(20)
- college (Field5) — VARCHAR(30)
STUDENT (Untitled)
- student_number (Field2) — BIGINT — Primary key
- social security number (Field3) — BIGINT — Primary key
- current address and phone (Field4) — VARCHAR(30)
- permanent address and phone (Field5) — VARCHAR(30)
- birthdate (Field6) — VARCHAR(20)
- sex (Field7) — VARCHAR(10)
- class (Field8) — VARCHAR(20)
- degree program (Field11) — VARCHAR(20)
- student_name (Field) — VARCHAR(30)
- Major_department (Field12) — composite — Foreign key → Major_department.department_name
- Minor_department (Field13) — composite — Foreign key → minor_department.department_name
course (Untitled4)
- course number (Field3) — BIGINT — Primary key
- course name (Field) — VARCHAR(20)
- description (Field2) — VARCHAR(100)
- number of semester hours (Field4) — int
- level (Field5) — int
- offering department (Field6) — VARCHAR(20)
grade report (Untitled6)
- STUDENT (Field33) — BIGINT — Foreign key → STUDENT.social security number
- letter_grade (Field3) — VARCHAR(10)
- numeric _grade (Field4) — int
- student (Field2) — composite
- section (Field32) — BIGNT — Foreign key → section.course
minor_department (Untitled3)
- department_name (Field) — VARCHAR(20) — Primary key
- department_code (Field2) — BIGINT — Primary key
- office_number (Field3) — BIGINT
- office phone (Field4) — VARCHAR(20)
- college (Field5) — VARCHAR(30)
section (Untitled5)
- course (Field32) — BIGNT — Foreign key → course.course number
- instructor (Field) — VARCHAR(20)
- semester (Field2) — VARCHAR(20)
- year (Field3) — int
- section_number (Field5) — int