I need to design a database schema for an angling clubs that lists the history of the club.
I need to store details of
anglers (personal details, address etc)
who belong to a
club (club details, address etc)
now
each anglers international competition results (year, competition, location, result)
each anglers national competition results (year, competition, location, result)
What would be the database schema for this?
Start Free Trial
