Need help with design suggestions for my app
Hey guys,
I'm developing an app for managing general assemblies using Spring and Angular. Users need to input assembly details (Type, Year, Date, Time, Address, City) and attach files (route sheet, invitation letter, attendance sheet, proxy, attendance form). Actions and their details are extracted from the uploaded Excel route sheet and displayed on a management page. Users can also attach deliverables to actions. Can you suggest a design for this?
11 Replies
you're in #back-end asking for designs
Yeah I'm looking for suggestions on the design of the db schema
that requires a complete analysis of everything you want
every single feature, every single action, every bit of data you need to see, any possible expansions into the future...
it's a lot of work
the best advice i can give is for you to follow up to the 3rd normalization level/rule/whatever
3rd normalization level
What does it mean please
it's a set of rules that detail how you should contrust your database
i don't remember everything, but i think that the 3rd one is that you can't have n:n relationships and to do not put the values of n:n relationships into a database
for example,
user_1, user_2, user_3 ...
instead, you put a table in the middle that has foreign keys of the 2 tables you want to relate
imagine you have a task that can have more than 1 user
instead of having all the users in the task table, you add task_users and it has the user's table primary key and the task's table primary key as foreign keysAlright cool got it man, thanks for your help
you're welcome
if i were you, i would start by planning the requirements first
That's all I know for now 😂
I just need a basic db design to practice
that's the problem: you can't do a basic design without knowing what you will design for
if you don't know what data you will need, in which formats, you're dead in the water
that's like going to a car salesman and you ask for something that can do highway speeds
it's just not enough information to even begin to help you
you're saying you need to upload files, for example
will you work on a gallery-style, like wordpress, where files are in a gallery and can be re-used?
are all files specific to an assembly?
are the files going to be associated with an user or not?
Your best bet is to start a post over in #discussions as this channel is for code-specific help and it doesn't look like you're ready for the code portion yet.
As a starting point to me it seems that you have: Users, "Assembly details", "Attached files", Actions (and action details?), Deliverables.