Download Nikol Simecek MSc by Research

Nikol Simecek – MSc by Research
GENE SYNONYM
Synonym ID
Gene ID
Synonym
GENE
Gene ID
Gene Symbol
Gene Name
PK
FK
PRIMER PROBE
PR ID
PK
FK
Assay ID
Start
Length
Melting Temperature
GC content
Primer/Probe sequence
Type(FP, RP or PRB)
PK
GENE SEQUENCE
Gene Sequence ID
Gene ID
Species ID
Accession
Gene Sequence
SPECIES
Species ID
Common Name
Scientific Name
TAQMAN FILE
File ID
Gene Sequence ID
File Name
Date/Time created
PK
FK
FK
PK
FK
TAQMAN ASSAY
Assay ID
File ID
Record
Amplicon Length
Penalty
PK
PK
FK
PK = Primary Key
FK = Foreign Key
Figure 6 Final Entity Relationship Diagram
2.5 Database implementation
With the database design in place, the next step was to implement the database using
an appropriate relational database management system (RDBMS).
2.5.1 RDBMS installation
MySQL, distributed by MySQL AB at http://www.mysql.com, was chosen as the
26