database structures and foreign keys
I am just learning mysql at the moment. I am using your Blue_Sky_music database to help me understand how relational databases work, in order to create one myself accurately. The only question I have is, looking at the bsm database using mysql gui tools and php admin, it does not appear that the tables are joined (have foriegn keys that link the tables) within them. However the data does appear to be related. Do you make the relationships in the end user application, in mysql or both? This is a question that has stumped me and I cannot seem to find a clear anwser on the web.