1 / 26

Autism Survey Website

Autism Survey Website. Ashley Tillette SoCalBSI August 24, 2006. Outline. Where I worked → My project Purpose of project Background on Autism Introduction to databases Database creation Web-based Future direction. Outline. Where I worked → My project Purpose of project

Download Presentation

Autism Survey Website

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Autism Survey Website Ashley Tillette SoCalBSI August 24, 2006

  2. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  3. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  4. Where I worked → My project • “Sequencing and Genotyping Core” at UCLA • Dr. Jeanette Papp - Director • Ram Sripracha • My project • Develop a database with a web-front end to assist in the collection of questionnaire data for researchers dealing with autism

  5. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  6. Purpose of project • Headed by • UCLA Center for Autism Research & Treatment (CART) • CART Project 1: Infants at Risk of Autism - A Longitudinal Study • My project • Parents with autistic child • Track changes during study period

  7. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  8. What is Autism? • Neurological disorder that affects children • Onset → before 3 years of age • Characterized by abnormal social, communicative, and behavioral functioning

  9. What is Autism? (cont.) • Cause unknown • Possibilities • group of genes or chromosomal abnormalities • environmental factors • Diagnosis • The Diagnostic and Statistical Manual of Mental Disorders (DSM) • The International Statistical Classification of Diseases and Related Health Problems (ICD) • The Autism Diagnostic Interview-Revised (ADI-R)

  10. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  11. Introduction to databases • What is a database? • a collection of data, typically describing the activities of one or more related organizations • Example database • Students → names, student id number, gpa • Enrolled → classes, grade, student id number

  12. Intro to databases (cont.) Students Enrolled

  13. Intro to databases (cont.) • Keys • Primary key → attribute(s) whose value uniquely identifies an entity in the set • Foreign key → a connection between two tables • Example • Primary keys • s_id for students table • class_id and s_id for enrolled table • Foreign key • s_id connects both tables

  14. Intro to databases (cont.) Students foreign key Enrolled

  15. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  16. My project • Develop a database with a web-front end to assist in the collection of questionnaire data for researchers dealing with autism

  17. Creation of Database • Used PostgreSQL • 1st step → create tables • 2nd step → establish keys • 3rd step → enter data

  18. Tables • forms → form_id (pk) • questions → question_id (pk) • participant_answers → set_id, question_id, cat_id (pk) • Many others

  19. Preview Table – “forms”

  20. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  21. Web-page • Used PHP for design • Setup • Login for data entry person • Choose parent, stage, and form • Input answers for each form • Website • http://aatillet.lifeofram.com/index2.php

  22. Outline • Where I worked → My project • Purpose of project • Background on Autism • Introduction to databases • Database creation • Web-based • Future direction

  23. Future direction • Check between two data entry people • Retrieve data from database • Perform statistical analysis on data • Allow parents to take survey online • Use design of website and database for other projects

  24. References • Ramakrishnan, Raghu and Gehrke, Johannes. “Database Management Systems – Third Edition”. 2003

  25. Acknowledgements • Ram Sripracha • Dr. Jeanette Papp • UCLA Center for Autism Research & Treatment (CART) • Diana Tran • SoCalBSI

  26. Questions

More Related