Location: [CPSC 333] [Student Information Systems] [Version One] Data Dictionary for Version One
Name: first name
Kind: At
Type: string
Description: A non-key attribute of Student
Name: ID number
Kind: At
Type: integer
Description: A key attribute of Student; should be exactly eight digits long
Name: last name
Kind: At
Type: string
Description: A non-key attribute of Student
Name: middle initial
Kind: At
Type: character
Description: A non-key attribute of Student
Name: status
Kind: At
Type: [ `registered' | `passed' ]
Description: A non-key attribute of Student
Name: Student
Kind: E
Type: @ID number + first name + middle initial + last name + status
Description: Corresponds to students who are registered in or who have recently passed the course
[View ERD] [Return to Simulation]
Location: [CPSC 333] [Student Information Systems] [Version One] Data Dictionary for Version One