tutor emmar

1.0

Display Purpose

Select Action

1. Student Looking up Faculty Office Hours

2. Faculty maintaining calendar

1.1

Student or Faculty (radio button)

2.0 Student Module

2.1 Open database

create struct <<called>> FacData

select entire recordset of Faculty data

Faculty ID, Last Name, phone number

while not end of recordset

insert into FacData faculty record

2.2 while not end of FacData

print Faculty ID as link, Faculty Record in grid format

2.3 select faculty (link id)

pass faculty id to ShowFacultyHours(linkid)

3.0 ShowFacultyHours

3.1 ShowFacultyHours(linkid)

select dataset from database table calendar where id = linkid

3.2 DisplayFacultyHours

print formatted dataset

4.0 Faculty Module

textboxName

textboxMondayStart

textboxMondayStop

textBoxTuesdayStart

textBoxTuesdayStop

assume data read in = “6:00 pm”

when reading from database do so in this fashion

select * from database where id = linkid

******** variable ****** field name

textboxName = Name

textboxSemester = Semester