The purpose of this assignment is to give you the chance to practice some writing pages with embedded PHP queries. You will write some pages that display query results from a database, much as you practiced in the lab on embedded queries.
You will need a populated database to complete this assignment. I suggest that you use the database schema you completed for a prior assignment, but you if you wish you may jettison that and choose some other topic. In any case, the database should be created by you, and should include at least one many-to-one relationship. You may make up the values to be included or get them from some factual source. If the latter, you should cite the source somewhere on your page.
Specifics
You should implement at least three pages with embedded queries. One should return and display at least two different attributes from a single relation in a formatted table with appropriate column headers. The second should restrict the tuples returned using a WHERE clause. The third should display data resulting from a JOIN across the many-to-one relationship, and should show data values from both sides of the join. Note that these requirements are not mutually exclusive -- you could in principle combine them all in a single page, but I am asking for three pages.
To assist my grading, please include an index page linking to your three pages of embedded queries, identifying the SQL query used by each, and which if the above requirements it is intended to satisfy. Finally, you should include a fourth link to a dump file of the database, so I can check that the query results are correct. You don't need to worry much about presentation for this assignment -- the pages can consist of plain unstyled HTML.
Grading
Please read the previous section carefully and make sure that you meet all its requirements! Work that does not follow the instructions will not receive full credit.
In your work, try to use general functions in place of more specific ones, where possible. Top grades are reserved for work that makes efficient use of well-designed general-purpose functions, and shows other evidence of careful scripting.