The database for your project should have at least four entities.
Each table should include a number of properties.
Primary keys should be indicated.
It should have at least one one-to-many relationship.
It should have at least one many-to-many relationship.
Your project report must include a statement about each relationships in two ways, such as, "A Congress person may be on many committees"
and "A committee consists of many congress persons."
Your project report must include an ER diagram (design view is OK) for your database.
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.
Make a SQL script for your database and/or tables.
Submit a report with your design and description. Submit your
SQL script. Submit all of your PHP files.
