simple db - how am I doing so far?

From: <strongsilentone_at_gmail.com>
Date: Sun, 14 Dec 2008 13:03:19 -0800 (PST)
Message-ID: <e6bbfc35-d454-46d6-8130-52b348693df5_at_r15g2000prh.googlegroups.com>



Hi, I'm designing a simple database to help out a co-worker. There are some questions I think are worth asking this individual before I go any further, but I'd like some feedback on the approach I've taken so far. This database is intended to assist in managing massive quantities of sheet music. Please don't laugh, I'm using MS Access. It suits this purpose just fine :)

(if this is unclear you can view it on my blog http://sscode.blogspot.com/2008/12/table-inventory-master-sid-title.html )

table: INVENTORY (master)

sID	TITLE	ARRANGER	PUBLISHER	GENRE	INSTRUMENTS
auto	text	long int	long int	long int	long int


table: ARRANGER
aID	arranger
auto	text


table: PUBLISHER
pID	publisher_name	phone_number
auto	text	text


table: GENRES
gID	genre
auto	text


table: INSTRUMENTS
iID	instrument
auto	text
Received on Sun Dec 14 2008 - 22:03:19 CET

Original text of this message