The CATE project is a modification of the database used for Holman Learning Center. There are some things in the Holman DB that are needed for the CATE db and some things that are not needed.

The Holman database information has been distributed as email. Also, we have screen shots here of two tables that were not part of the email.

The CATE people have asked for the following items based on the Holman reports:

• Enter/View Student Testing
• delete Enter/View ReaderWriter ...
• ASO Master Testing Schedule
• ASO Testing Cancellation Report
• ASO Student Testing Profile Report
• deleteHLC ReaderWriter Proctor Profile
• ASO Accomodations Profile -...
• ASO Testing Comparison Report
• Student Email

We are given the following Cate specific information

Room names, room descriptions

• Agatha Christie: no fluorescent lights, reading software
• Pablo Picasso: reading software
• Walt Disney: EVS CCTV, reading software
• General Patton: Dragon Dictate, reading software
• John F Kennedy: Telesensory large CCTV, reading software
• Ray Charles: JAWS

Disability types, clients can have more than one disability type:

• POHI
• LD
• Dyslexia
• VI
• HI
• Blind
• Other

Equipment/software used (some are listed in the room description above):

• Human Reader
• Human Scribe
• EVS CCTV
• Telesensory Large CCTV
• JAWS
• Magic
• ZoomText
• Dragon Dictate
• On-screen keyboard
• Ergonomic keyboard
• Foot mouse
• Sticky keys
• ReadPlease
• Premier-to-Go
• Talking Cursor
• Talking Word Processor
• Word Prediction
• Kurzweil

The design allow for adding disabilities, equipment/software, and testing rooms.

For this project, focus on the tables and queries. Reports and forms are less important.