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