SQL

---

Database Schema and Table Creation

I designed a simple database schema to store information about organisms and their genes using MySQL database. Specifically, it contains the genus, species, and taxon ID for any given organism and accommodates all genes for each of the organisms, storing the accession, gene product name, and gene symbol for each. The database was populated with the appropriate data from the following NCBI accessions: CBG36883, CBG32879, CBG33788, ADZ50581, ADZ50584, and ADZ49168.

Organism table: orgs

Genes table: genes

Junction table using foreign keys from orgs and genes

Result: