Minggu, 31 Januari 2016

[MS_AccessPros] Questions About Name Fields

 

I'm working on a database which can involve multiple composers. It's a
song database. My question is what is the best way to design the
composer name fields?

1. Use separate LAST NAME, FIRST NAME fields or just one name field?

2. Use separate COMPOSER NAME fields to allow those songs that have
multiple composers? Seems to say composer1, composer2, etc. would be
cumbersome because some will have more than three authors, etc.?

3. Of course, there will be a table of all composers.

Any ideas would be appreciated.

Thanks,
Jerry in Michigan, USA

__._,_.___

Posted by: Jerry in Michigan <bearjercares@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar