What is a good database design (schema) for student working day plan-CodePudding

I'm trying to make a application for student working day plan. I've tried looking around for some similar examples, but I couldn't find any specific or clear enough ones for this kind of application.

At the moment, I created such a scheme https://dbdesigner.page.link/Qbt5snDBnmzYraKQA ,since I'm new to databases, I don't know if such a database is well designed or not.Is there some other better approach to designing this kind of database? Thanks in advance.

CodePudding user response：

Databases gets complicated over time as data changes, gets deleted etc. It's a vast topic. For starters, try to rearrange your design to a more 1:N from left-to-right, it will be easier to read, as in:

[discipline]    [professor]

[group]         [semester]

                [student]                [lecture]                [timetable]
                
                [study_program]

CodePudding user response：

There is a website that provides sample databases on a variety of subjects. The samples come with diagrams and actual databases, built in MS Access. Under the subject of Students, there are 36 samples. Some of them may be relevant to the problem you are working on.

The site is Database Answers.