Relational Database Design for History Research? (showing different titles, positions held etc)
I'm a PhD researcher in History, working on the disgraced members of the Ottoman ruling classes between 1574-1617. I only look at disgraced officials who served in the Imperial Council and held the top positions in the empire, who came from one of the three sectors in the Ottoman ruling classes: the military-administrative bureaucrats, the learned-judiciary, and the financial bureaucrats. I can think of the following fields: name; titles held (they hold different titles in different years); the dates of their appointments, dismissals, disgraces, comebacks; education; ethnic origin; number of disgraces they experienced; the types of disgrace they experienced (treason, embezzlement); who accused them with these charges (often other members within my population); the punishments they received (dismissal, exile, confiscation of property, execution); talent.
I also want to be able to see how these people's lives changed year-by-year. For example: Koca Sinan Pasha was in exile in 1584, but in 1589 he was appointed grand vizier, in 1591 he was disgraced (because his rival Ferhad Pasha accused him of treason), in 1593 he was reappointed grand vizier, in 1595 he died of natural causes. Ferhad Pasha was appointed grand vizier in 1591 (after bringing Koca Sinan Pasha into disgrace) and in 1593, he himself was disgraced (by Saturcu Mehmed Agha's libellous letter), in 1595 he was reappointed grand vizier, in 1595 again he was disgraced (because of Koca Sinan Pasha's accusation) and two months later Ferhad Pasha was found guilty: he was executed and his property was confiscated.
These are the types of events I am interested in, and showing the role of people in them. Another complication I have is that I use different types of records to document these events, often narratives taken out of chronicles and histories. For example, I have three chronicles that mention Koca Sinan Pasha's disgrace in 1591 and an archival document. I also want to have a table whereby I can see Koca Sinan Pasha's DISGRACE 1 which is related to texts produced on different dates. And in these texts, other members of the population are also mentioned (another relation).
So far, I've been using non-relational excel sheets, and a chronological entry of texts in word files created for each person. This is very old fashioned research method and makes seeing the bigger picture very difficult. I think creating a database of this kind not only involves database design (about which I know very little) and also probably templates. I guess my database of collective biography focusing on disgrace will be similar to a database of CV's with fields for education, different jobs and job titles, etc. Although would be more complex because of the way the members of the population show up in different CVs.
Do you think a non-professional and inexperienced researcher can realistically use File Maker Pro for this project?
Do you think File-Maker pro is the right database program for such a project?
How can I learn more about showing change in one person's life (relating appointments, dismissals, deaths to time)?
For example, how can I show different titles and positions held in different years?
Is there any specific text I can read that will help me create these relations in a database and show changes chronologically in one person's life, or changes in the list of the members of the Imperial Council by years?
How long the building of such a database last?