This will probably be an ongoing discussion any users with applied input will receive points
I'm creating a small access database to hold the information about every computer system at work. (about 40 +5 Servers). Hardware setup, users, location...
TONS of reasons. Main two are: so i know which systems need upgrades and when they were upgraded. SECOND If I drop dead tomorrow someone can come in and see which users use each computer and vice versa.
Ive created a visio diagram to layout DB
I'm not happy with what Ive set up. Any input to help normalize or improve on design would be appreciated. Main part I don't like is location table. I don't like having two pk but it seems impossible to get around.
Computer(Name) may have more then one user
LocID may have then one user.
UserName may use more then one computer
Again this is a discussion to improve DB design before I start creating Test DB