Click here for Flash demo   (Requires DSL - 41 meg)

The client requirement was to add a field to an existing user table (for the user magnetic card id) and to build a table and user interface so door access security could be configured (based on multiple user profiles and door security settings); I was provided a Sentinel-Prox SP-6820 magnetic card swipe reader, three magnetic cards and a PC parallel port PC Relay driver board (K74V2) and no hardware specifications.

During the ORM CSDP it was not deemed feasible to follow client specifications as users could have multiple cards (see resulting data structure); a user could leave a card at home and be issued a temporary card. This coupled with role security evolved their application to a point where it met their requirements (but not their single table specification). I asked for their patience and trust and delivered what they required. Disclaimer: This was a low budget project so functionality (not user interface) was the priority - generally I would not leave foriegn key fields as combo boxes.

Note: what may not be evident from the flash presentation is that when the door relay is configured for 5 and the magnetic card is swiped (web cam shown on screen) that there is a few second delay for which the relays stays on (to provide user access to locked door) and then it turns off.   Another important note is that the desktop application is on my development machine and the door security configuration is on an internet web server - the desktop application accesses the door security configuration information via web services when the card is swiped; note that I have the time lapsed for data retrieval in ticks (tick = 100 nanoseconds).