1 / 16

Radio Station Management Web Application

Radio Station Management Web Application. CSCI-B 351 October 20, 2011. Yicheng Feng Mohsen Jafari Karissa McKelvey Dhaval Muchhala Chris Zakian. Goals. WIUX Campus Radio Station Music Database Artist, Album, Song search Reviews Ratings Play Counts Human Resource Management

rogan-anderson
Download Presentation

Radio Station Management Web Application

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Radio Station Management Web Application CSCI-B 351 October 20, 2011 YichengFeng Mohsen Jafari KarissaMcKelvey DhavalMuchhala Chris Zakian

  2. Goals • WIUX Campus Radio Station • Music Database • Artist, Album, Song search • Reviews • Ratings • Play Counts • Human Resource Management • Different types of users • Staff have edit privileges on parts of the data • Handle applications to be radio staff

  3. Users • Member • Rates songs • Apply to be Staff, DJ • Staff • Belongs to at least one committee • Submit album reviews • DJ • Plays songs • Director • Decide upon applications, album reviews • Edit music data

  4. Entity Relationship Model

  5. Architecture

  6. Entering an Album

  7. Entering an Album - Data Flow

  8. Questions?

  9. Entity Relationship Model • Difficult Questions • Reviews • Users • Representing Music Data • Albums with one artist • Multiple artists on an album • Songs featuring artists

  10. Listening to the Radio

  11. Directors Approving Album Reviews

  12. Schema - Users • member(username , name , gender , email, address, birthdate, graduation_year, reg_date) • director(dID, username, bio, major, hometown, homestate, photo) • staff(sID, username) • dj(djID, username references member(username))

  13. Schema – Human Resources • application(appID, application_type, decision, date_submitted, date_decided, reviewer) • committee(name, chair) • committee_member(name, sID, start_date, end_date, active) review(rID, albumID, start_date, sub_date, rating, reviewer, dID, approved) also_like(albumID, likeID)

  14. Schema - Music • artist(artistID, fname, lname, mname, prefix, suffix, birth_date) • song(songID, albumID, name, visibility) • rating(username, songID, score) • play(songID, djID, time) featured_artist(songID, artistID) • album(albumID, artistID, rotation, genre, description, release_date, receive_date, go_for_ads) • review(rID, albumID, start_date, sub_date, rating, reviewer, dID, approved)

More Related