This document describes the redis version of the student database. The database was created from 5 input files, each one in the form of a table. student.txt --fields: sid, sname, majordept, gradyear dept.txt --fields: deptid, deptname course.txt --fields: courseid, coursename, deptcode section.txt --fields: sectid, courseid, instructorname, yearoffered enroll.txt --fields: enrollid, studentid, sectid, grade dept is a hash containing (deptcode, deptname) pairs hkeys dept : returns a list of deptcodes hvals dept : returns a list of deptnames hget dept:20 returns the name of dept 20 student is a list of student ids student:id is a hash with keys sname,majorid,gradyr,major student::sections is a set of sections that the student is enrolled in student::courses is a set of courses that the student is enrolled in lrange student 0 5 : returns a list of studentids in positions 0-5 lrange student 0 -1 : returns a list of all studentids get student:3:major : returns major of student 3 hget student:3 major : returns major of student 3 smembers student:kim:courses : returns a list of courses that kim is taking smembers student:kim:sections : returns a list of sectids that kim is enrolled in course is a list of course ids course: is a hash with keys (title,deptid,dname) course::title is a string course::sections is a set of sectionids of sections of the course course::students is a set of studentids enrolled in the course hget course:12 title returns the name of course 12 get course:12:title returns the name of course 12 smembers course:12:sections returns a list of the sectionids of sections of course 12 smembers course:calculus:students returns a list of studentids enrolled in the course section is a list of section ids section: is a hash with keys (courseid,prof,yroffered,ctitle) section::courseid, section::prof, section::yroffered, and section::ctitle are strings section::students is a set of student ids section::studentsbyname is a set of student names lrange section 0 -1 returns a list of all section ids get section:33:ctitle returns title of course with section 33 hget section:33 ctitle returns title of course with section 33 smembers section:33:students returns a list of student ids enrolled in section 33 smembers section:33:studentsbyname returns a list of names of students enrolled in section 33 enroll is a list of enroll ids enroll: is a hash with keys (studentid,sectid,grade,sname,ctitle) enroll::sectid, enroll::ctitle, enroll::studentid, enroll::sname, enroll::grade are strings lrange enroll 0 -1 returns a list of all enroll ids hget enroll:24 sname returns name of student in enroll record 24 get enroll:24:sname returns name of student in enroll record 24