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.

Click for Demo

 Nip Shoppe database example 2


View Code
Top-level folder:
Inc folder:

View Files





***