I am in need of a data management system. I currently have process that allows administrators to upload CDs into a grouping of genre folders: blues, rock, jazz, Americana, and so on. In a genre folder a new folder is created and named after an artist, and then that artist’s CD which is made up of MP3 tracks is uploaded into the artist folder in the correct genre. The user then moves and inserts the tacks in an organized folder structure and database that stores the music though a PHP driven script. The current system does not handle the moving of album cover images, so changes maybe made to the upload script, and an add image option must be included in the admin area, as to associate cover art with CDs already upload. What we need is a management system that will allow an admin to make changes to the data stored in the database. So if the artist name is incorrect an update system will change the data, also a delete system that will either delete a artist, all there attached CDs, or a the ability to delete either a single CD or individual tracks from an Artist songs and CDs. PLEASE NOTE THAT THE DELETES IN THE DATABASE MUST ALSO DELETE THE PHYSICAL FILES AND FOLDERS. We would also like the ability to provided groupings of artists. Example Bob Dylan will be uploaded as an artist in rock genre, but we like to create groupings of artists, so an artist may be displayed in two genre groups.
We also are in need of a well designed search system for end users. Attached are some images to help explain the users interface. In the first picture you will see a series of genre buttons, on the clicking on one of these a second page will open displaying the artists. On clicking of artist an area on the page will become populated with the two links VIEW CDs or VIEW TRACKS. Based the link clicked, the desired data will be displayed. With the desired CDs or TRACKS displayed, the user should be able to sample the individual track, the whole CD, or add the tracks or tracks to a play list. The user play list system is already in place. You will have to view the current system to get a good idea of how the current system is working.