View on GitHub

ClassDB

An open-source system to let students experiment with relational data

Viewing currently registered users

Author: Andrew Figueroa, Steven Rollo

The ClassDB.User view holds entries for all currently registered ClassDB users. Only users from the current ClassDB database are displayed. Any Instructor or DBManager is able to read the values from this tables. They can also modify the FullName and ExtraInfo of any user.

Three additional views: ClassDB.Instructor, ClassDB.Student, ClassDB.DBManager are provided to display only the corresponding type of ClassDB user.

To retrieve a list of currently registered Instructors, the following query would be run:

SELECT *
FROM ClassDB.Instructor;

Likewise, to obtain a list of currently registered Students:

SELECT *
FROM ClassDB.Student;

All four views also contain logging information if the logging capabilities of ClassDB have been enabled. See User Logging for more information. Additional logging information can also be viewed using the Frequent User Views.