I am working on a project which takes up data of students and analysis it and gives em help and tips on how they should study. I am having trouble designing the data base.
>>54557621
There is one College. m courses , n semesters, o subjects.
>HURR DURR UML IS SHIT AND BOORING
>IM GONNA SKIP FOR VIDEO GAME DESIGNING
serves you right
databases would be ERD
your application logic would be UML
>>54557621
Ok OP, il get right to work on your homework. While Im at it do you want me to make you a facebook or instagram website as well?
just spitballing but with superior document storage support postgres 9.5 is the best RDBMS imho.
instead of generating analysis on the fly you could generate all the reports nightly and store the results in json and have your application just fetch that information when needed
>>54557672
You actually can represent tables in UML. Just use classes for tables, attributes for table fields and associations for relations. You can also add constraints to define the primary key and other unique indexes.
>>54557710
thanks anon
>learn something new everyday
>>54557726
you never heard of UML before ?
>>54557733
i heard of and used UML before but not to model db
>>54557739
It never is. OO and relational data are two very different beasts and usually require middleware to get them to talk. Look up Object-relational mappings.
Switch your major to gender studies, you're not cut out for this.
>>54557859
but i am
>>54557866
If you're asking questions like in OP, no, you're not. This is shit I was doing in my parents basement when I was like 13.