Docstoc

DATABASE REVIEW

Document Sample
DATABASE REVIEW Powered By Docstoc
					                    Institute of Applied Health Sciences

                            University of Aberdeen




                     DATABASE REVIEW




                Department of Mental Health

                     University of Aberdeen




                CHILDHOOD IQ STUDY OF

         1936 ABERDEEN BIRTH COHORT




Childhood IQ Study of 1936 Grampian Birth                      June 2001
Cohort
                                                     DATABASE CODE: C36
                                        Page 1
                      Institute of Applied Health Sciences

                                University of Aberdeen

Table of contents
Introduction                                                                            3

  History                                                                              3
  Overview of Database                                                                 3

Database Structure                                                                     4

Main Table Summary                                                                     5

  ABC1936 Address                  Participant Details                                 5
  ABC1936 PhysicalParticipant      Physical Details                                    5
  ABC1936 Neuro                    Participant Neurological Details                    6
  ABC1936 Health                   Participant Health Details                          6
  ABC1936 Disease                  Diagnosed Patient Diseases                          6
  ABC1936 Biochemistry             Biochemistry Results                                7
  ABC1936 Ancestors                Ancestor Details                                    7
  ABC1936 Siblings                 Sibling Details                                     7
  ABC1936 Descendants              Descendants Details                                 7
  ABC1936 ECG1                     Electrocardiogram Readings – 1st Wave               7
  ABC1936 ECG2                     Electrocardiogram Readings – 2nd Wave               8

Associated Publications                                                                9




Childhood IQ Study of 1936 Grampian Birth                                       June 2001
Cohort
                                                                      DATABASE CODE: C36
                                          Page 2
                        Institute of Applied Health Sciences

                                  University of Aberdeen

Introduction
History
The 1936 Aberdeen Birth Cohort Database was created on an ACCESS Database in 1999. It is
populated with data for Aberdeen City children born in 1936 who sat a mental ability test in June 1947
as part of the Scottish Mental Survey. Aberdeen born children who took part in the original IQ test are
being traced and these individuals are being followed up to undergo (to varying degrees) substantial
physical and neuropsychological assessment. This study mirrors the original 1921 Birth Cohort Study,
completed in 2000 and is currently in the first of three waves.

The aim of this study is to investigate the impact of intellectual ability on longevity and to estimate
whether or not premorbid mental ability influences the rate of cognitive change experienced with
advancing age.


Overview of Database
The Childhood IQ Study of 1936 Aberdeen Birth Cohort data is held as an Access database on a PC
within the Department of Mental Health at Cornhill Hospital.

Demographic, physical and psychological data for traced individuals is held on the database
amounting to approximately 3 Megabytes of storage across 13 database tables, 11 of which contain the
basic data detailed in the Main Table Definitions Section and a further 2 tables used for reference.




Childhood IQ Study of 1936 Grampian Birth                                                  June 2001
Cohort
                                                                          DATABASE CODE: C36
                                               Page 3
                    Institute of Applied Health Sciences

                            University of Aberdeen


Database Structure

                                    ANCESTORS



                                            CON_NO


    PHYSICAL                                                      NEURO
      DATA            CON_NO          ADDRESS        CON_NO        DATA


        CON_NO                                                CON_NO

                                            CON_NO


     HEALTH                                                      DISEASE

                                   DESCENDANTS

        CON_NO                                                CON_NO




       ECG                            SIBLINGS                BIOCHEMISTRY
                      CON_NO




Childhood IQ Study of 1936 Grampian Birth                              June 2001
Cohort
                                                         DATABASE CODE: C36
                                        Page 4
                          Institute of Applied Health Sciences

                                 University of Aberdeen



Main Table Summary
ABC1936 Address                               Participant Details
 Unique Patient Identification Number
   Surname / Forename / Sex / Date of Birth
   Date of Interview
   Occupation
   Address, Postcode, Telephone Number and Deprivation Code
   Occupation of Parents
   Household Breadwinner’s Occupation in 1947
   Number of Rooms / Occupants in Family Home and Household Sanitation Facilities in 1947
   Marital Status / Living Arrangements
   Residential Details
   Hours of Home Help
   Name / Address of General Practitioner
   Years of Formal Education and Highest Qualification Attained
   Smoking Status and History
   Details of Alcohol Consumption

ABC1936 Physical                              Participant Physical Details
 Unique Patient Identification Number
   Surname / Forename
   Record of Physical Waves Completed
   Sit-to-Stand and 6 Metre Walk Time
   Blood Pressure / Pulse / Demi-span
   Weight / Height
   Forced Expiratory Volume and Vital Capacity
   Dental Health
   Visual Acuity
   Hearing Ability
   Electrocardiogram Readings
   Barthel Index Score for Wave 1, 2 and 3
Childhood IQ Study of 1936 Grampian Birth                                            June 2001
Cohort
                                                                         DATABASE CODE: C36
                                                Page 5
                        Institute of Applied Health Sciences

                                    University of Aberdeen

ABC1936 Neuro                                   Participant Neurological Details
   Unique Participant Identifier
   Surname / Forename
   Record of Neurological Wave Participation (3 Waves)
   HADS Anxiety / Depression Score
   Original mental ability test score (1947)
   Mental Ability 1937 Test Resit Score in 1998
   MMSE Score
   Date of Neurological Testing
   National Adult Reading Test (NART) – Numbers Correct and Errors
   NART Predicted Full Scale IQ
   Time taken for Ravens and Number Correct
   Auditory Visual Learning Test – Numbers Correctly Recalled
   Digital Symbol Score and Block Design Score
   Uses of Objects – Numbers Correct and Incorrect

ABC1936 Health                                  Participant Health Details
 Unique Participant Identifier
   Surname / Forename
   Age of Menopause
   Disease History
   Prescribed Medication Details / Dietary Supplement Details
   First Degree Relatives Living in Grampian Region
   First Degree Relatives Living outwith Grampian Region
   History of Heart Disease / Diabetes / High Blood Pressure
   History of Heart Disease / Diabetes / High Blood Pressure / Cerebrovascular Disease in Relatives
   History of Dementia / Mental Illness in Relatives
   Personal History of Heart Disease

ABC1936 Disease                                 Diagnosed Patient Diseases
 Unique Participant Identifier
   History of Diagnosed Diseases
   Total Number of Body Systems Affected by Disease


Childhood IQ Study of 1936 Grampian Birth                                                 June 2001
Cohort
                                                                             DATABASE CODE: C36
                                                  Page 6
                         Institute of Applied Health Sciences

                                  University of Aberdeen

ABC1936 Biochemistry                       Biochemistry Results
 Unique Participant Identifier
   Blood Number (Genes)
   Blood Haemoglobin
   Cholesterol Level
   Triglyceride Level
   High Density Lipoprotein
   Low Density Lipoprotein

ABC1936 Ancestors                          Ancestor Details
 Unique Participant Identifier
   Father’s Date of Birth; Date of Death and Cause of Death
   Mother’s Date of Birth; Date of Death and Cause of Death
   Paternal Grandfather’s Date of Birth; Date of Death and Cause of Death
   Maternal Grandmother’s Date of Birth; Date of Death and Cause of Death

ABC1936 Siblings                           Sibling Details
 Unique Participant Identifier
   Number of Siblings (Live and Dead)
   Sibling Identification Number
   Siblings : Gender; Date of Birth; Date of Death and Cause of Death

ABC1936 Descendants                        Descendants Details
 Unique Participant Identifier
   Number of Children (Live and Dead)
   Child Identification Number
   Gender of Child; Date of Birth; Date of Death and Cause of Death
   Details of Additional Children

ABC1936 ECG1                               Electrocardiogram Readings – 1st Wave
 Unique Participant Identifier
   ECG rate / ECG axis codes
   Arrhythmia code
   ECG reading


Childhood IQ Study of 1936 Grampian Birth                                          June 2001
Cohort
                                                                         DATABASE CODE: C36
                                              Page 7
                       Institute of Applied Health Sciences

                                  University of Aberdeen

ABC1936 ECG2                            Electrocardiogram Readings – 2nd Wave
 Unique Participant Identifier
   ECG rate / ECG axis codes
   Arrhythmia code
   ECG reading




Childhood IQ Study of 1936 Grampian Birth                                       June 2001
Cohort
                                                                DATABASE CODE: C36
                                          Page 8
                        Institute of Applied Health Sciences

                                 University of Aberdeen


Associated Publications
Deary IJ.
An instantaneous measure of a lifetimes cognitive change.
In preparation 2001

Deary IJ.
Influence of E4 allele on Childhood IQ.
Submitted to Intelligence 2001

Leaper S. et al.
MR1 Deleted Brain White Matter Lesions: Associations with Balance and Gait Speed in Older Adults.
Submitted to Age and Aging 2001




Childhood IQ Study of 1936 Grampian Birth                                             June 2001
Cohort
                                                                      DATABASE CODE: C36
                                              Page 9

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:1/11/2012
language:
pages:9