SQL logical design help (crow's foot)

Hi all,

I have this scenario to do but I’m having issues to make it work, can you please help me

The US environmental department needs to have a database which
stores details about rivers. The name, total length, mouth (sea/lake into
which it flows) and the states it crosses are required. In addition to
storing their name, the length that the river covers through each one of
them is also recorded. Also, for each state, the name of bounding states
and their capitals are to be stored.
• Create a logical design for the database above

My design:

Firstly, welcome to the forums.

While we are primarily here to help people with their Free Code Camp progress, we are open to people on other paths, too.

This looks like a homework problem.

With your current questions, we don’t have enough context to know what you already know or don’t know, so it is impossible to guide you without just telling you the answer (which we won’t do).

It is pretty typical on here for people to share a codepen / jsfiddle example of what they have tried so that anyone helping has more of an idea of what help is actually helpful.

Can you describe what troubles you are having with the current design?

Happy coding :slight_smile: