Another one of those I say tah-may-toe, you say toe-mat-o...<BR><BR>You have StaffID, it is the PK for the Staff table that lists all your staff.<BR><BR>You have a customer table and somewhere in ...
The end goal of database design is to be able to transform a logical data model into an actual physical database. A logical data model is required before you can even begin to design a physical ...
Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.