Home

Audio-Transcript Database Implementation

Welcome to Group 3's wiki! We have implemented an database and user interface that is used for an Audio-Transcript application.

Our Objective

The objective of our project is to create and provide a more efficient and user friendly system for searching and finding audio files on the topics the user is looking for. It is also our goal to combine the audio field and the transcripts so they are both accessible to the public and have the ability to view the transcript that corresponds to the audio file while the audio is playing. We want to provide a user friendly interface for searching, and viewing these files. Providing an straightforward way to interact with these files and a system that would allow for public users to submit new files to be transcribed would encourage interaction between the user and those behind the scenes to collaborate and improve upon existing systems. Better user interaction makes the user feel like their suggestions are valued and their interaction with our system is important. We also want those with higher access to the database to be able to improve and make changes, like adding relevant tags, information and new files, to the system more easily.

Project Description

The audio-transcript files are sorted and arranged in a neat, elegant user friendly user interface. Files are tagged with topics, names, dates, and other relevant information so they are able to be searched for more easily, made easy through tagging the files with relevant information. There a search page accessible by a link in the navigation bar so users can easily search for a file based on their desired topic, year, like or view count. Users are also able to search for and make comments. If a file is selected, the user is taken to a different page where they could view the transcript. When viewing the transcript, the user would see the entire transcript at once and have the ability to like the transcript. On the transcript page there is a link to the transcript for each audio file. There a submission page for users to submit suggestions for updates, new audio files, records, or errors they have seen. For example, if someone found an error in the transcript or wanted to make a suggestion for improvement or a new submission to be transcribed. There are Admin and Moderator sign in features which take you to a page where you can insert, update and delete items from the database as well as search the full contents of the database.