PaddyIrishMan
Registered User.
- Local time
- Today, 17:08
- Joined
- Jun 5, 2002
- Messages
- 166
Hi all,
I’m looking for some opinions on the following scenario please:
Currently my company uses lots of different databases:
A Database for tracking support calls A Database for tracking Software Errors
A Database for storing Employee TimeSheets
(It goes on…)
I want to normalise this whole process & be able to use the data to generate metrics for the whole process.
My Question(s):
Should I create one BIG Database with lots of forms & a switchboard, this one database could be used to record everything?
Should I keep the databases separate & link the tables that share information?
If I am to link the tables, should I link to ‘Live’ tables or rather than link tables just have a local copy of the table & update it every time the database is opened?
Any Comments or Suggestions graciously welcomed.
Thanks in advance,
Patrick.
I’m looking for some opinions on the following scenario please:
Currently my company uses lots of different databases:
A Database for tracking support calls A Database for tracking Software Errors
A Database for storing Employee TimeSheets
(It goes on…)
I want to normalise this whole process & be able to use the data to generate metrics for the whole process.
My Question(s):
Should I create one BIG Database with lots of forms & a switchboard, this one database could be used to record everything?
Should I keep the databases separate & link the tables that share information?
If I am to link the tables, should I link to ‘Live’ tables or rather than link tables just have a local copy of the table & update it every time the database is opened?
Any Comments or Suggestions graciously welcomed.
Thanks in advance,
Patrick.