1. phpMyAdmin can be used to examine the STRUCTURE of the database. Fields include name, gender, apartment number of each resident. Also included: relationship to head of household, including maid, lodger and porter.
2. The BROWSE command shows all data.
3. SQL query is constructed via popup. This query should produce names and apartment numbers of all MAIDS (relationship_id = 5).
4. Results of query shown in 3, modified to SORT by last name, ascending.
5. phpMyAdmin feature can convert SQL query to PHP syntax. This would be helpful when querying the database from a web page.
