I've been asked to provide a technical analysis of a database with a view to providing a spec for a redesign.
The existing database doesn't appear to have any relationships set up under Tools--> Relationships. The database monitors a sequential process. Surely there should still be relationships set up? Would there ever be a time when they wouldn't be necessary?
There are separate tables for each step in the process. Surely when information repeats, such as Comments fields, there should be a general comments table for all comments, irrespective of step. When the process starts a record is pasted into each step table for that process. Is this good or bad practice? I would have thought that a process should only exist at a step where actual data has been input for that step, not a blank template, if you will.
Any other thoughts on database analysis would be greatly appreciated, as would any advice on database specification - its a cloudy line between specification and design????