Molecular Biophysics & Biochemistry 447b3 / 747b3 Bioinformatics

Relational Databases

Unstructured Data

Semi-Structured Data

Structured Data

Survey 1

Survey 2

Turn the Survey into a Table (I)

Turn the Survey into a Table (II)

Turn the Survey into a Table (III)

Statistics are only Possible on Standarized Values

SQL

matches table

matches table 2

structures table

folds table

Structure of a Table

What is a Key?

SQL Select on a Single Table

SQL Select on a Single Table, Example

SQL Select on a Single Table, Example 2

Joins

SQL Select on Multiple Tables

Foreign Key

Selection as Array Lookup

SQL Select on Multiple Tables

ER-diagrams

Aggregate Functions-- Statistics on Attributes

RDB’s can encode complex data: Encoding Trees in RDBs

Further topics

Forms & reports [user views]

Normalization