• At least four entities, list the important properties, indicate a primary key
• At least one one-to-many relationship
• At least one many-to-many relationship.
• State the relationships in two ways, such as, "A Congress person may be on many committees" and "A committee consists of many congress persons."

• Lab: Product Select Make a PHP page that has a drop-down select populated by a northwind query with the ProductName displaying to the user and the ProductID serving and the option's value. Put your credentials in an included file as shown in the examples; I should be able to swap my credential file for yours and run your code without needing other changes.
• Lab: "Product API" Make a page (possibly the previous page) with a form that allows the user to enter a ProductID then use the GET method and a "prepared, parametrized" query to output the data for that product in JSON format.
• Lab: Shippers Radio Make a PHP page that has a set of radio buttons populated by a northwind query with Shipper Company Name displaying in a label and the ShipperID serving as the value for the radio button

Make some PHP pages for project. I am not going to specify the number of pages, but the following features and functionality should be present

• Have an INSERT query. There should be some type of validation on at least two different type of fields (or two different patterns/filters).
• Have a DELETE query.
• Have an UPDATE query.
• Have a SELECT query that populates an element of a form. (For example, you have a one-to-many relationship as well as a many-to-many relationship, and the options for the foreign key(s) in an INSERT or UPDATE might come from a drop-down select).
• Have at least five SELECT queries.
  • At least one must be displayed in a datatable.
  • At least one must be displayed in a PDF table.
  • At least one must be displayed as JSON.
  • At least one must be a JOIN.
  • At least one must be parametrized -- have a WHERE clause with data provided by the user.