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.