Gossamer Forum
Home : Products : DBMan : Discussions :

Artist/Album/Song/Multimedia Addons Database?

Quote Reply
Artist/Album/Song/Multimedia Addons Database?
Hi.

I would like to know if it would be possible to design a database with DBMan with the following features.

- My database will be about Artists/Albums/Songs.

- I would like to have 3 different tables (or databases) which should be linked together. (this is calles "relational database" I think). The names of these 3 tables would be ARTIST (:=A) / ALBUM (:=B) / SONG (:=C) .

A- the ARTIST table should have following fields
A1 - artistname
A2 - the albumnames of this artist
A3 - possibility to add comments about this artist
A4 - possibility to add pictures of this artist
A5 - name or email of who sent this record

B- the ALBUM table should have following fields
B1 - albumname
B2 - year of album when it was published
B3 - the songnames of this album
B4 - possibility to add comments about this album
B5 - possibility to add pictures of this album
B6 - name or email of who sent this record

C- the SONG table should have following fields
C1 - songname
C2 - lyrics of this song
C3 - name of the songwriter
C4 - another info about the song
C5 - names of the albums in which you can find the same song
C6 - possibility to add a midi file for this song
C7 - possibility to add a scanned notes picture for this song
C8 - possibility to add comments about this song
C9 - name or email of who sent this record

The following fields of each table should be compatible. (According to these should be searching possible and they should be linked via html links)

A2 -> B1 (search for albumname)
B3 -> C1 (search for songname)
C5 -> B1
A5 -> B6 -> C9 (search for editors of the database)

There should be also a search for the artistnames.

Would such a database setup be possible with DBMan? How difficult would be the programming of such a database? I mean for which features do already Modifications exist?

I hope anyone can help me.

Best greetings,
Baris

Subject Author Views Date
Thread Artist/Album/Song/Multimedia Addons Database? Baris 2830 Jul 12, 2001, 8:49 AM
Thread Re: Artist/Album/Song/Multimedia Addons Database?
LoisC 2740 Jul 12, 2001, 11:32 AM
Thread Re: Artist/Album/Song/Multimedia Addons Database?
Baris 2731 Jul 12, 2001, 11:56 AM
Post Re: Artist/Album/Song/Multimedia Addons Database?
Baris 2728 Jul 12, 2001, 12:15 PM