| Name | Description | Data type | Constraints |
|---|---|---|---|
| lname | student's last name | VARCHAR2(30) | |
| fnames | student's first name(s) | VARCHAR2(40) | |
| student's email address | VARCHAR2(50) | ||
| gender | student's gender (m or f) | CHAR(1) | |
| program | student's program (coe or lscs) | VARCHAR2(4) |