Database Management

Skills in database management allow me to understand dynamic possibilities for the virtual arrangement of records. The following Entity Relationship Diagram (ERD) highlights a database schema that I designed for organizing information related to succulents. It demonstrates my understanding of normalization through the modeling of one-to-many or many-to-many relationships, primary and foreign keys, and joint tables.

Data Retrieval

How could my database to respond to the following query?

Display the taxonomic hierarchy and a visual description of each succulent species. Indicate if the species has a variety, and what that variety looks like in comparison to the general species. 

After using insert statements to enter values into the database, select statements could retrieve the information. In the image below, the left pane gives a glimpse into values inserted into the “visual description” field of the “species” table. The pane on the right shows what the above query statement looks like “under-the-hood.” The select statements ask for the taxonomic hierarchy, the species’ visual description, and variety distinctions in their appearance. The bottom of the image reveals the output.