Abstract
The purpose of this article is to introduce the effective use of a relational database management system (RDBMS) in statistical analysis of Shumon Aratame Cho (population registers = SAC).
First, the data structure of SACs is compared with that of the questionnaires for the Third National Survey on Household Changes. Secondly, I explain the features of the RDBMS and examine some early uses of the system in historical studies, combing data from various sources. The main body of the paper is a detailed explanation of SQL statements to obtain the variables necessary for estimating the proportion and transition rates of coresidence of people with their children, using the SAC database. I also suggest the potential of RDBMS for achieving effective use of questionnaires in sociological research.
