Flat File Database 2

Two Tables with a One-to-Many Relationship

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.

 Nip Shoppe

files for Nip Shoppe example 2

 Nip Shoppe files example 2

data folder

 NIp Shoppe Example 2 data file

inc folder

 Nip Shoppe Example 2 inc file

View Code

Top-level folder:
data folder:
data/products folder:
inc folder: