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)

Options: ReplyQuote


Subject
Written By
Posted
music application
March 02, 2006 05:32PM
March 03, 2006 04:26PM
March 07, 2006 04:24AM
March 07, 2006 05:08AM
March 07, 2006 10:53AM
March 07, 2006 11:06AM
March 07, 2006 11:27AM
March 07, 2006 11:27AM
March 07, 2006 02:48PM
March 07, 2006 04:05PM
March 07, 2006 04:19PM
March 12, 2006 06:07PM
March 13, 2006 07:00AM
March 25, 2006 06:17AM
March 25, 2006 07:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.