wallacealeco
Registered User.
- Local time
- Today, 06:52
- Joined
- Sep 7, 2011
- Messages
- 23
Hi. As an experienced, if very amateur database designer I have been asked to combine several databases that an organisation uses. All the databases are people based so a central file containing this 'person list' seems the way to go. Problem is each user has different needs in terms of what info they want about each person so I could end up with over 100 fields for each person, some of which would never be used by most users. A lot of redundancy! My idea is to have a simple central list to which users are linked. Then each user could have a related table with the extra data they need. My question is would this be better than one large central table.
Thanks in anticipation.
Thanks in anticipation.