Wombat games

Tags
Challenge
No

Make an app like this one.

Create two more tables in your wombat DB.

The games table shows games. Here's my definition of it. It just has an id and a name.

Games

Create another table to represent a many-to-many relationship between games and wombats. Each wombat can play many (or no) games, and one game can be played by many (or no) wombats. I named the table plays, but you can call it something else. Here's my definition.

Plays

Put some test data in your new tables.

Here are the files I created for the app:

Files

You don't have to use this structure.

There are four pages. First, a page to show a list of wombats.

Wombats list

Click a link, and see the deets for that wombat, including a list of the games that wombat plays:

Wombat deets

If a wombat plays no games, show a message to that effect.

Wombat plays no games

Click on a game name, and see the deets for that game, including a list of the wombats who play that game:

Game deets

If no wombats play the games, show a message to that effect.

No wombats

There should also be a page to show a list of games.

Games list

Click on a link to see the deets for that game.

Submit the URL of your solution, and a zip of your files. The usual coding standards apply.

Where referenced