Eugene, Your question is very broad. The combination of the business logic for the student management system plus database normalization best practices will result in the right database schema for this platform. Example business logic : - User must have a B or higher to be eligible to move to the next grade or auto upgraded to the next grade - User can be upgraded to the next grade but will not be eligible to enroll if the account balance for the prior year is not zero
Some of the business rules will guide your database design/model creation. You need to be able to do the above resulting in an ERD which you can then share and someone can then offer additional feedback. On Monday, December 6, 2021 at 3:35:53 AM UTC-7 eugenet...@gmail.com wrote: > Dear Gilwell, > > That is where I want an idea. I do not understand how I do the diagram. > > Thanks > > On Mon, 6 Dec 2021 at 12:30, Gilwell Muhati <gilw...@gmail.com> wrote: > >> Hello @Eugene >> What does your ERD diagram look like? - Please share the diagram >> >> >> >> >> *Regards,Gilwell Muhati | +254 710 739 116 | * >> *~~“The mind is its own place and in itself can make a heaven of hell, a >> hell of heaven…”~~John Milton * >> >> >> On Mon, Dec 6, 2021 at 1:14 PM Eugene TUYIZERE <eugenet...@gmail.com> >> wrote: >> >>> Dear Team, >>> >>> I am developing a student management system and I am stuck at the point >>> below which I need your idea. >>> >>> I need to record school fees every semester and promote a student from >>> one level (year) to the next level every year. Like 1st Year to second year. >>> >>> How can I achieve this to avoid data duplication in the database. >>> >>> Regards, >>> >>> -- >>> *Eugene* >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to django-users...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/CABxpZHubDPpuLt5bfpD10FWinnBSjZLT6sJs717NXzqhiThFWg%40mail.gmail.com >>> >>> <https://groups.google.com/d/msgid/django-users/CABxpZHubDPpuLt5bfpD10FWinnBSjZLT6sJs717NXzqhiThFWg%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to django-users...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/CALO4FhHouSYeK3kVCu696XP5xgnC9cY1KJ7wDVPU36jVPiwh0A%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/django-users/CALO4FhHouSYeK3kVCu696XP5xgnC9cY1KJ7wDVPU36jVPiwh0A%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > *TUYIZERE Eugene* > > > > *Msc Degree in Mathematical Science* > > *African Institute for Mathematical Sciences (AIMS Cameroon)Crystal > Garden-Lime, Cameroon* > > Bsc in Computer Science > > *UR-Nyagatare Campus* > > Email: eugene....@aims-cameroon.org > eugenet...@gmail.com > > Tel: (+250) 7 88 26 33 38, (+250) 7 22 26 33 38 > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c07ec2bf-4012-4fde-9577-cca8fa35db5dn%40googlegroups.com.
