Relational databases work by organizing data into tables, which consist of rows and columns. Each row represents a unique record, while each column represents a variable or attribute of the data. In Epidemiology, tables might include data on patients, disease incidence, risk factors, and outcomes. Researchers can use SQL to perform queries, join tables, and generate reports that provide insights into public health issues.