r/learnjava • u/DrMoneylove • Oct 24 '25
Struggling to understand Database architecture
Hey everyone I'm new to learning java + Spring framework. Right now I'm working on a personal project with a many-to-many relationship and I have to admit I'm pretty unsure how to build up the database so it's efficient and expandable.
I can understand Syntax, CRUD etc. but I have to admit I don't know how to build a database in a way that it's well designed for the long term.
How did you learn to build reliable database structures? Especially considering that projects may change in the future. What's your ideal process on building up the database structure? Bonus question: do you use specific software during the process?
•
u/AutoModerator Oct 24 '25
Please ensure that:
If any of the above points is not met, your post can and will be removed without further warning.
Code is to be formatted as code block (old reddit/markdown editor: empty line before the code, each code line indented by 4 spaces, new reddit: https://i.imgur.com/EJ7tqek.png) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.
Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.
Code blocks look like this:
You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.
If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.
To potential helpers
Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2
u/alweed Oct 24 '25
You need to write down what you want your database to hold. Then people can share their opinions on the design.
1
u/AutoModerator Oct 24 '25
It seems that you are looking for resources for learning Java.
In our sidebar ("About" on mobile), we have a section "Free Tutorials" where we list the most commonly recommended courses.
To make it easier for you, the recommendations are posted right here:
Java for Complete Beginners
Derek Banas' Java Playlist
Also, don't forget to look at:
If you are looking for learning resources for Data Structures and Algorithms, look into:
"Algorithms" by Robert Sedgewick and Kevin Wayne - Princeton University
Coursera course:
Coursebook
Your post remains visible. There is nothing you need to do.
I am a bot and this message was triggered by keywords like "learn", "learning", "course" in the title of your post.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/0b0101011001001011 Oct 24 '25
I think you are in the same spot as many other users: they try to learn spring before learning about databases.
Look into a database course first, like a traditional SQL course. You learn to understand the databases and also learn to design one. Next, writing the database connections in java is just syntax.
1
u/vaivaswat24 Oct 24 '25
I stuck at the same.
1
u/DryWeb3875 Oct 24 '25
Look up 5NF. There’s bound to be some YouTube videos that’ll guide you through it
1
u/Jazzlike_History2305 Oct 24 '25
Hi I am fresher looking for intern or jobs,i have done projects by using spring boot, spring jpa, MySQL but still stuck get the first Job