Introduction

You are currently on Marc Grange's website.
This site is an update of my former site "marc-grange.net"  which is no longer accessible.

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 unfamiliar with these areas, please refer to the columns on these pages:

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

The purpose of the presentation is to introduce some interesting applications of databases in the field of 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 utilizes DBMS (DataBases Management Systems) properties to avoid developing specific applications. Four examples, linked to the humanities 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. Structuring of information: production of the data diagram.
  3. Presentation of queries representative of the area under investigation.
  4. Interactive processing of queries, 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.