Introduction

You are currently on Marc Grange's website.
This site is an update from my old site "marc-grange.net" 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.

Prerequisites

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.
Objective

The objective of this presentation is to show some interesting applications of databases in the 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 that uses the DBMS (DataBases Management Systems) properties avoids developing specific applications. 
Four examples, in connection with the Humanities and Social Sciences, will be successively presented:

- 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.