Good Access Database Design Book

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i've been playing around with MS Access 2k3 for a while now, and am still
trying to learn good database design. I've rebuilt my current one (For IT
Equipment Tracking) and just get it right. Im looking for some
recommendations for books to learn good database design.
Thanks,
 
Quick question untill I get the book. In a inventory database, i have all the
equipment in a single table. If i want to assign each piece of equipment to a
specific room (by serial number) with multiple pieces and types of equipment
in each room, should i put the room number in the same table, or create a
seconed "Equipment Assignments" table with the serial number and room in it?
thanks,
 
if you haven't time to run out to a bookstore just yet, suggest you go to
the website listed in the "Tip" i posted, and begin reading up on relational
design theory and practices at some of the numerous websites listed on the
Access Junkie's Resources page.

hth
 
If you don't care about tracking the movement of equipment from one room to
another, the single table might be all you need. If you want to record when
item x was moved from room a to room b, though, you'll need that assignments
table.
 
Back
Top