You are currently on Marc Grange's website.
This site is an update from my old site "" that is no longer available.

The information on these pages is addressed to anyone wishing to apply and use database techniques. Various examples are taken from the field of Social Sciences, but the SQL language training and the database design method presented hereafter, relate to all the fields that imply an effective management of data.
As a practitioner, developer and teacher, I have used and taught databases and computer science for over 30 years.


Knowledge of database design, relational data model and SQL is essential in order to follow this presentation. For readers who do not have the knowledge, but wish to address these various areas, please consult the columns on these pages:

DB Design Basic concepts to design databases.
SQL SQL Interactive Learning.

The purpose of the presentation is to show some interesting applications of databases in the social sciences and humanities. The use of a data model to structure information, here the relational model, allows to work with SQL language for the extraction and production of relevant information relating to the studied field. This "generic" approach uses the properties of DBMS (DataBases Management Systems) to avoid the development of specific applications. Four examples, related to the human and social sciences, will be presented successively: 

- In Sociology : Processing of surveys
- In Demography : Relationships modelling
- In Psychology : Affinity relationships
- In Geography Networks modeling


Each example will go through the following steps:

  1. Presentation of the data in connection with the problem: construction of the data dictionary.
  2. Information structuring: production of the data schema.
  3. Presentation of questions representative of the area under investigation.
  4. Interactive processing of questions, on a "test" database, in SQL language.
Practical application

To put into practice and use, in a real system, the concepts of database design and use (SQL) presented in these pages, see the features of IBEasy+ software.