From Certificate to Population

 

Example of an original marriage certificate

 

The data compiled comes from civil records, especially marriage certificates. Known for their quality and integrity, the Quebec vital event records contain information such asnames and surnames, places and dates of events, places of residence, occupations, signatures, mentions of attendance, etc.

 

Example of a computerized marriage certificate

 

 
 
 
 
 
 
 
 
 
 
  
 
 
 
 

Example of a reconstructed family

The BALSAC database is developed in two phases, completed in chronological order whenever possible:
 
1. Data entry: civil registration data is entered, validated and corrected when necessary.
 

2. Data linkage: all information related to couples is linked and processed to reconstruct families. Based almost exclusively on a comparison of nominative data, linkage follows a progressive approach starting with the easiest step (fully-automated linkage process done as soon as the information is transferred with the Data Entry function) to the most difficult (computer-assisted linkage).

 

Simplified structure of the relational database

BALSAC, which uses a relational database structure with a universal identification number for individuals and families, is comprised of three main tables. One relates to individuals, the second to couples, and the third to events (i.e. births, marriages, deaths, etc.).