Source

1
Hybridised Onto
Produces
Source
Sample
High Level ERD
Used In
Groups
Scans As
Scan
Slide
Experiment
Mapped by
Contains
Spotted From
Array
Plate
Consists of
Recorded In
Spot
Result Set
Contains
Identifies
Microarray Database Schema G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
Sequence
2
Sample to Experiment Level 0 Data Flow Diagram
Selected characteristics
Grow Plants
Sample Details
Bulk Samples together
Bulk Sample
Bulk Samples
Plant Details
Samples
Source Details
Sample Details
Harvest Samples
Use as single Sample
Bulk Sample
Sample Source
Sample
Samples
Add Samples to Experiment
Selected Samples
Record of Experiment
Define Experiment
Experiment Parameters
Experiment
Microarray Database DFD G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
3
Identify Sequences
Sequences
Sequences to Spots and Plates to Arrays Level 0
Data Flow Diagram
Sequence Details
Known Sequences
Generate the Array
Plate-Sequence Map
Map Sequence to Plate
Sequence
Known Sequences
Array-Sequence Map
Array Details
Plate Size
Identify Plates
Plate Details
Plate Details
Array
Spot
Plate
Plate Details
Amplification Results
Amplify Plates
Amplification
Microarray Database DFD G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
4
Experiment
Amplification
Experiment and Array to Result Set Level 0 Data
Flow Diagram
Selected Experiment
Plate Amplifications
Selected Array
Generate Slide
Array
Slide Details
Slide
Array Details
Slide Details
Scan Slide
Scan Parameters
Scan
Known Sequences
Slide Image
Analyse Image
Normalisation
R,G Channel Levels
Normalised Channel Values
R,G Channel Levels
Result Set
Microarray Database DFD G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
5
Sample_Source
Plant to Experiment
Organism
Sample
Source_ID
Organism_Name
Sample_ID
Organism_Name
Description
Plant_ID
Ecotype_Name
Description
Ecotype
Mutant_Line_Name
Tissue_Name
Ecotype_Name
Treatment
Harvest_Date
Description
Expt_Sample
Owner
Tissue
Experiment_ID
Mutant_Line
Location
Tissue_Name
Sample_ID
Mutant_Line_Name
Description
Description
Keyword
Expt_Keyword
Treatment
Keyword
Experiment_ID
Treatment_Name
Description
Keyword
Description
Experiment
Experiment_ID
ExptGroup
ExptGroup_Expt
Category
Description
Group_Type
Group_Type
Category
Category
Description
Experiment_ID
Description
Sequence
Microarray Database Schema G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
Time_Course_Period
6
Sample to Slide
Experiment
Experiment_ID
Slide
Description
Slide_ID
Category
Experiment_Sample
Array_ID
Experiment_ID
Experiment_ID
Sample
Date_Spotted
Sample_ID
Sample_ID
Date_Hybridised
Source_ID
Sample_X_ID
Bulk_ID
Sample Bulk_Sample
X_Labelling_Info
Description
Bulk_ID
Sample_Y_ID
Tissue_Name
Sample_ID
Y_Labelling_Info
Harvest_Date
Bio_Replicate_No
Owner
Tech_Replicate_No
Location
Bulk_Sample
Bulk_ID
Bulked_Date
Constraint If Bulk_ID not null then Source_ID
null, if Source_ID not null then Bulk_ID null.
Bulked_By
Microarray Database Schema G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
7
Slide
Plate to Slide
Array
Plate
Slide_ID
Array ID
Plate_ID
Array_ID
Description
Library_Name
Experiment_ID
Library
Plate_Size
Spot
Bio_Replicate_No
Library_Name
Source
Spot_ID
Tech_Replicate_No
Description
Location
PI_Sequence_ID
Date_Spotted
Owner
Organism_Name
Array_ID
Date_Hybridised
Ecotype_Name
Array_Block
Organism
Sample_X_ID
Tissue_Name
Array_Row
Organism_Name
X_Labelling_Info
Array_Col
Description
Sample_Y_ID
Amplification
Y_Labelling_Info
Tissue
Amplification_ID
Slide_Amplification
Tissue_Name
Plate_ID
Slide_ID
Sequence
Description
Date_Amplified
Amplification_ID
PI_Sequence_ID
Ecotype
Gel_Photo
Clone_ID
Plate_Well
Ecotype_Name
Function
Well_ID
Well_Amplification
Description
Accession_No
Plate_ID
Amplification_ID
Accession_No_Source
PI_Sequence_ID
Well_ID
Sequence
Plate_Row
Status
Plate_Col
Microarray Database Schema G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
Concentration
Origin_Well_ID
8
Slide
Scan_Primary_Results
Slide to Results
Slide_ID
Primary_Results_ID
Array_ID
Scan_ID
Experiment_ID
Scan
Spot_ID
Bio_Replicate_No
Scan_ID
Ch1_Median
Tech_Replicate_No
Slide_ID
Ch1_Mean
Date_Spotted
Date
Ch2_Median
Date_Hybridised
Scan_Secondary_Results
Time
Ch2_Mean
Sample_X_ID
Secondary_Results_ID
X_Labelling_Info
Scan_ID
Sample_Y_ID
Spot_ID
Y_Labelling_Info
Dia
Etc.
Norm_Results_1
Spot
Norm_Results_2
Primary_Results_ID
Spot_ID
Norm_Results_3
Scan_ID
PI_Sequence_ID
Spot_ID
Array_ID
Ch1_Median
Array_Block
Ch1_Mean
Array_Row
Ch2_Median
Microarray Database Schema G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
Array_Col
Ch2_Mean
9
Microarray Database Schema
Sample
Sample_ID
Sample_Bulk_Sample
Source_ID
Bulk_ID
Bulk_ID
Sample_ID
Tissue_Name
Collection_Date
Owner
Location
Slide_Amplification
Slide_ID
Amplification_ID
Plate_Well
Well_ID
Plate_ID
PI_Sequence_ID
Plate_Row
Microarray Database Schema G. Kennedy CSIRO Plant
Industry V1.1 26/3/2001
Plate_Col
Origin_Well_ID