Flat File Database 2

Database with 2 Tables

When Miss Kitty got back to work on the Nip Shoppe database, she realized that a 'categories' table was needed to group products.

There would be a one-to-many relationship between the two tables - a single Product could belong to multiple Categories. The two tables would be joined by a third table composed of Product Key/ Category Key pairs.

Files and folders for this demo

 Nip Shoppe database demo 2 files

Contents of the 'data' folder:
 Nip Shoppe 2 data file

Contents of the 'data/products' folder:

Contents of the 'inc' folder:

Leave a comment