Start thinking about a database for your individual project for this course
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 for your database.
Lab: Northwind Customer datatable
In your XAMPP/MAMP use the SQL script contained in NorthwindMaster.zip
to create and populate the tables of the Northwind database. First you must create the database, the script
will not create the database. Then with that (empty) database selected, navigate to the SQL tab, paste in the
script, and click Go.
Make a PHP page that connects to the Northwind database, selects all of the Customer data, and places that
data into a table with the datatable functionality (pages, searching and sorting).