Forum Home
Press F1
Thread ID: 139582	2015-05-26 21:20:00	Databases	gary67 (56)	Press F1

Post ID	Timestamp	Content	User
1401408	2015-05-28 00:01:00	Yes I guess so as each artist can have many albums but also some songs appear on many albums. Correct.	Webdevguy (17166)
1401409	2015-05-28 21:56:00	here goes I now have set up so far Artist ID Artist name Album name Album ID Album name Artist name Album length File type Song ID Song name Album name Artist name (do I need this as this could be determined from the album table?) (I know I will need it for compilation albums later just trying to save some typing) Song length I have created a relationship of one to many for artist to album album to song and one for song to album (because one song can be on many albums)	gary67 (56)
1401410	2015-05-28 22:06:00	I'd create an Album table, a Song table and then a third table linking songs to albums (because it's a many to many relationship).	pcuser42 (130)
1401411	2015-05-28 23:20:00	I'd create an Album table, a Song table and then a third table linking songs to albums (because it's a many to many relationship). What fields would you use in each? Can you give me a brief description of the layout you would use. The song table will be huge since each album has approx 10-12 songs.	gary67 (56)
1401412	2015-05-29 00:15:00	Found an excellent tutorial Here (databasementor.com) Does exactly what I want :thumbs::thumbs:	gary67 (56)
1401413	2015-05-29 02:00:00	What fields would you use in each?Can you give me a brief description of the layout you would use.The song table will be huge since each album has approx 10-12 songs.Song table:Song IDSong nameOther data about the song (length etc)Album table:Album IDAlbum nameOther data (release year etc)Artist table:Artist IDArtist nameOther dataSong-Album Link tableLink IDSong IDAlbum IDAlbum-Artist link tableLink IDAlbum IDArtist IDInsert multiple rows with the same artist ID and different albums to link one artist to multiple albums. Insert multiple rows with the same album ID and different artists to represent albums with multiple artists.	pcuser42 (130)
1401414	2015-05-29 02:01:00	Mobile site doesn't keep new lines for some reason...	pcuser42 (130)
1401415	2015-05-29 02:12:00	Now that I'm back at a PC: Song table: Song ID Song name Other data about the song (length etc) Album table: Album ID Album name Other data (release year etc) Artist table: Artist ID Artist name Other data Song-Album Link table: Link ID Song ID Album ID Album-Artist link table: Link ID Album ID Artist ID Insert multiple rows with the same artist ID and different albums to link one artist to multiple albums. Insert multiple rows with the same album ID and different artists to represent albums with multiple artists.	pcuser42 (130)
1401416	2015-05-29 19:44:00	Now that I'm back at a PC: Song table: Song ID Song name Other data about the song (length etc) Album table: Album ID Album name Other data (release year etc) Artist table: Artist ID Artist name Other data Song-Album Link table: Link ID Song ID Album ID Album-Artist link table: Link ID Album ID Artist ID Insert multiple rows with the same artist ID and different albums to link one artist to multiple albums. Insert multiple rows with the same album ID and different artists to represent albums with multiple artists. Yeah, what he said. Up to now you've had tables duplicating data from other tables, when all they really need to hold is a link (ID field) to the data in the other tables. The Many-to-Many relationship in the last table can be a bit confusing for a newbie. To make it even more confusing, there can be further mixing up of Artist info, eg Song X, by artist Y, featuring 'guest' artist Z. Or Classic song X reworked by artist Y, remixed, extended, disco beat, orchestral, without vocals, with vocals, the permutations seem endless. So do you want the Classic Roxanne by Sting (and the Police) to be linked to Sting, or to The Police, or to Sting and The Police. Then do you want some rappers mix version of it still linking back to the original title and / or artists? Honestly, a music collection can be a real tangle of data. Tracing mankinds lineage back to year zero would be easier.	Paul.Cov (425)
1401417	2015-06-03 00:14:00	gary67, going back in time, one would have been able to write a program for you. As a branch accountant, I had to write spreadsheets and databases for the company's various divisions, cost centres, etc. The attachment is the only one I could find on an old floppy and it's very basic. Note the date and that was after the holding company was one of the first to use pcs' in the earlier 1970's, rofl. lurking.	Lurking (218)
1 2