In class practice

Analysis of fungal community metabarcoding (ITS rDNA) data, examining how communities differ between benthic substrates and across a stream continuum and annual flow permanence gradient.

This project presents a comprehensive redesign of a relational database schema tailored for managing restaurant operations, including table reservations, food ordering, customer records, menu structures, and staff assignments. The report highlights key improvements such as enhanced field naming, the use of constraints (ENUM, UNIQUE, DEFAULT), and the addition of status tracking and timestamps. The redesign aims to support improved data integrity, scalability, and reporting efficiency for real-world deployment.