Designing Databases for Historical Research
Historical Research Handbook: Designing Databases for Historical Research
C. Fundamentals of database design
All of the foregoing concepts and aspects of database organisation need to be taken into consideration when designing the database that will be used in your historical research, as each of them will either have an implication for how some of your historical information will need to be converted into suitably shaped data (see Section E), or else they will have an impact upon the types of linking, counting and analysing it will be possible to perform on your data. Designing the database will not only involve modelling the information from your sources, but it will also involve making decisions about the conceptual approach of your database, the functions you want it to perform, and how you want the tables and fields of the database to operate at the most minute of levels.