music application
Posted by:
123R 567
Date: March 02, 2006 05:32PM
hiya,
I was wondering if any one could help me. Im new to all this so every little bit of help will be much appreciated :o)
I want to create an online music application that allows a user to search through music tracks ( also allowing the user to click on the track and the system can allow them to hear a sample) and then add it to a playlists that they can create. Now my question is can this be done by using Servlets, mysql and sql statments? If it can could someone give an idea on how to go about doin this? Ie how to store the users choice of music tracks in thier playlists and allows then to play the tracks
etc
heres my data model please let me if its suited to the project, plus do i have to store the tracks in the database, if i do wont that take up a lot of memory?
CREATE TABLE ALBUM (
ALBUM_ID INTEGER(6) NOT NULL AUTO_INCREMENT,
ALBUM_NAME VARCHAR(50),
RELEASE_DATE DATE, (YYYY/MM/DD)
MUSIC_DIRECTOR VARCHAR(50),
LABEL VARCHAR(50),
GENRE VARCHAR(50),
DIRECTOR VARCHAR(50),
CAST VARCHAR(100),
PRIMARY KEY (ALBUM_ID) );
CREATE TABLE TRACKS(
TRACK_ID INTEGER(6) NOT NULL AUTO_INCREMENT,
ALBUM_ID INTEGER(6),
TRACK_NAME VARCHAR(50),
TRACK_LENGTH TIME, ('HH:MM:SS')
SINGERS VARCHAR(100),
PRIMARY KEY (TRACK_ID),
INDEX (ALBUM_ID),
FOREIGN KEY (ALBUM_ID) REFERENCES ALBUM (ALBUM_ID) );
CREATE TABLE MEMBER(
EMAIL VARCHAR(30) NOT NULL,
PASSWORD VARCHAR(8) NOT NULL,
FIRST_NAME VARCHAR(50),
LAST_NAME VARCHAR(50),
GENDER VARCHAR(8),
POSTCODE VARCHAR(8),
COUNTRY VARCHAR(20),
PRIMARY KEY (EMAIL));
CREATE TABLE MEMBER_WEBCD(
WEBCD_ID INTEGER(6) NOT NULL AUTO_INCREMENT,
EMAIL VARCHAR(30),
WEBCD_NAME VARCHAR(50),
PRIMARY KEY (WEBCD_ID),
INDEX (EMAIL),
FOREIGN KEY (EMAIL) REFERENCES MEMBER(EMAIL)
);
CREATE TABLE WEBCD(
WEBCD_ID INTEGER(6),
TRACK_ID INTEGER(6),
TRACK_NAME VARCHAR(50),
PRIMARY KEY (WEBCD_ID,TRACK_ID),
INDEX (TRACK_ID),
FOREIGN KEY (TRACK_ID) REFERENCES TRACKS(TRACK_ID),
INDEX (WEBCD_ID),
FOREIGN KEY (WEBCD_ID) REFERENCES MEMBER_WEBCD(WEBCD_ID)
);
Im really confused as how to go about doing it all so plz help!!!!!!!!!!
Thanks
R123 :o)