music database - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

music database

sloppyjoesloppyjoe Posts: 2Member
Hi all im new to this forum and new to the language of sql and psql.
Im trying to design a music database using psql. i have a basic grasp of the language and im just looking for a starting point. In the html interface I want a search text box where anything can be typed. Artist, Track, Album, Genre. Next the text box will be a drop down box where they can choose where they want to search. again... artist, album etc etc.

All im asking for is a starting point here. What tables should i have? What columns in the tables? and where should i place my primary and foreign keys.

Any help appreciated.
Thankyou
Sign In or Register to comment.