Transcript Intro to Databases - Florida State University College of

Intro to Databases I
Data Gathering
Nancy Clark, MEd
Director of Medical Informatics Education
FSU College of Medicine
7/21/2015
1
Goal
 Recognize Database application
 Participate in design process
7/21/2015
2
Objectives
Students will demonstrate an understanding of
databases by accomplishment of the following tasks:
Part I
 Create a simple
database
 Create a form
 Search a database
 Sort a database
 Query a database
7/21/2015
Part II
 Data Extraction
 Create a simple report
 Create a form Letter
 Create mail labels
3
Database Software








Oracle
SQL (‘sequal’)
Access
File Maker Pro
dBase
Corel Paradox
FoxPro
Lotus Approach
7/21/2015
 JFile
 HanDbase
 Pendragon
Forms
 Satellite
Forms
4
Not Quite Databases
 Excel

Tables
 Word


7/21/2015
Tables
Mail Merge/form letters
5
Examples of Databases in
Healthcare
Patient Billing
Patient Demographics
Appointment System
Medical Records
HMO Formulary
7/21/2015
Lab Data
MEDLINE
6
Database Functions
 Information for decision making
 Research
 Get paid
 Improve day-to-day operation
 Quality improvement
 Reduce errors
7/21/2015
7
Healthcare Systems Databases
Hospital
7/21/2015
8
Vocabulary

Database: Flat vs
Relational
Field

Fieldname




Table
Record
Form





Sort
Search
Export/Import
Query
Print



7/21/2015
Report
Mail Merge
Form Letter
9
Database
 Collection of similar
data
 Fields

7/21/2015
Field Names
10
Database
 Collection of similar
data
 Fields

Field Names
 Table
7/21/2015
11
Database
 Collection of similar
data
 Fields

Field Names
 Table
 Record
7/21/2015
record
12
Types of Fields






Text
Memo
Number
Date/Time
Currency
Yes/No (Radio
Buttons)
7/21/2015
 Object

Picture, audio, etc
 Hyperlink
 Pick list


Short list
Table
13
Reasons to Use Pick Lists
 Free text unpredictable
 Can do summaries
 Ease of reporting
 Standard vocabulary
7/21/2015
14
Database
 Collection of similar
data
 Fields

Field Names
 Table
 Record
 Data Entry Form
7/21/2015
15
Field Formats
 Size
 Format
 Default Value
 Caption
 Validation
 Required?
 Etc.
7/21/2015
16
Database
 Flat
 Relational
7/21/2015
17
Queries
 Filter
 Selects only records that meet criteria
 Examples of criteria




7/21/2015
Dates
Genders
Value ranges
Diagnoses
18
Reports
 Lists of data
 Summaries of all or parts of data




Counts
Sums
Averages
Comparisons
 Screen or printout
7/21/2015
19
Designing a Database
7/21/2015
20
Goals of Design Process
 Understand your data and why tracking
 Eliminate duplication data
 Eliminate redundant data
 Eliminate meaningless data
 Promote accuracy and consistency of data
7/21/2015
21
Goals of Design Process
 Insure ability to retrieve needed information
 Support business functions using it
 Easy to use
 Lends itself to future growth
7/21/2015
22
Process
Step 1
 What is the purpose of the
database?
 What information do I
want to get out of it?
 What should the reports
look like?
 What am I going to do with
this information?
7/21/2015
Step 2
 What data do I need to
collect to provide this
information?
 Define fields, tables
 Design data entry forms
 Ask yourself, How much
can I pay to get this
developed?
23
Big Questions in Healthcare
 Where is the data going to live?
 Who owns the data?
 Who inputs the data?
 Who can access the data?
 How does the data get into the system?
 Can we share data?
7/21/2015
24
Hands-on Experience
 Using JFile

Create a simple database to keep track of all of
your passwords and UserIDs
 Using Access

Use Wizard to create CD or Book inventory
 Using Word

7/21/2015
Create a simple mail merge
25
Theoretical Experience
 Design a diabetic patient registry


Users: practicing docs in FL
Goal: improve diabetic care based on guidelines

Provide data for research
 What are the issues?
 What is best way to collect and compile
data? (hardware? software?)
7/21/2015
26