Project Performance against Analysis Objectives and Possible Extensions

The Objectives of the Project were discussed during the Analysis stage.

Taking each objective in turn:

The system must store and allow update and deletion of information about each song in the record library

• This objective has been fully met, with all the required data being stored in the Music Database.
• In future development, however, it may be prudent to add more track genres than those originally suggested and implemented.

Find a track or tracks by searching on any of the above criteria. The results of this search will be displayed on the screen for immediate reference.

• Again, this criterion has been fulfilled by the Find Facility of the program. Printing of search results is not available in the program, but as this was not one of the original objectives, I do not see this as a problem.
• However, it may be an area which could be extended in future by using a combination of dynamic SQL and the Data Reporting Environment.

Allow the user to browse through the songs available and view details of any chosen song.

• This feature of the program has been implemented.
• For future development, the opportunity to print the details of a single track could be implemented, or even a request system whereby a track could be added to a list of track to be played, along with the details of a particular patient.

Store and allow update and deletion of information about each member.

• This criterion has been fulfilled, with all the required data being stored.
• In future, further details about each member may become necessary or useful, and so this may be an area for future development.

Find a member or members by searching on any of the above criteria.

• Again, this criterion has been fulfilled by the Find Facility of the program.
• Printing of search results is not available in the program, but as this was not one of the original objectives, I do not see this as a problem. However, it may be an area which could be extended in future by using a combination of dynamic SQL and the Data Reporting Environment.

Allow the user to browse through a database of members view the details of any chosen member.

• This feature of the program has been implemented.
• For future development, the opportunity to print the details of a single member could be implemented.

Allow a presenter (and only a presenter) to book an hour when they can use the studio. Although not originally suggested, after discussion with current members, a system whereby a data sheet of bookings could be printed has now been suggested.

• Both the original booking objective, and the suggested printing objective have been met.
• In future, a request system could also be devised to complement the booking system.

Print members’ details ordered by status should be available, as this could serve as a useful telephone directory and print a list of all of the tracks in the music database should also be made available

• Both of these criteria have been met using the Visual Basic Data Reporting Environment, and examples of the printed reports can be seen in Appendix B (not available online).
• I cannot see much potential for future development in this particular area of the program.

User feedback

A letter from the Technical Manager of Newtown Hospital Radio providing feedback on the program can be found in Appendix C (not available online). Since all of the original criteria specified were met, the Hospital Radio team were pleased with the new system.