How better to design the database?

Question

How better to design the database?

23 views

doing this little site for several groups at the University. page with schedule, file archive, and other pleasures. the question arose in relation to the everyday schedule. on the page of each group will hang her schedule for tomorrow (optional — on any given day). at the moment, there are two tables, but they are not related to each other:

subjects (list of subjects)
subjId (unique number of the subject)
subjName (full name of subject)

groups (list of groups)
groupId (unique number of the subject)
subjName (name of group)

you need to map each group a list of items on Monday\\Tuesday\\etc...
knowledge of php and mysql at the primary level. therefore, I wanted to ask the gurus how better to design the database.

asked Mar 20, 2019 by turbo_exe | 23 views

6 Answers

Related questions

blo · Answer 1 · 2019-03-22T08:50:35+0000

well, like anything complicated, the table will be like this:
\r
timetable{
subjId int
groupId int
day int
startTime time
}
\r
schedule for the day for the group:
select * from timetable,subjects where timetable.subjId=subjects.subjId and groupId= & day= order by startTime;

blo · Answer 2 · 2019-03-22T08:50:35+0000

But what about odd/even weeks? Well, wait no — then will be.
A number of audience? And the name of the teacher... Because of this extra information is enough to make the examination in to 4. :)

blo · Answer 3 · 2019-03-22T08:50:35+0000

Googling about ER-model (model of entity-relationship), just your case. Can more about normalization to check if the first approach will overcome the terms...
You can Google something more specific, for example, is (there is, however, aktsess, but you can look at the pictures with the model).

TheShock · Answer 4 · 2019-03-22T08:50:35+0000

We do not touch because the group can be a few things. Make a table:
id (unique number)
id_group (group)
id_subjects (object)
id_day (day of week)
There may be other fields like lower/upper week.
Something to add to the group object are added to the table the necessary data. The sample is simple, select all the desired date in the right group. Or choose all for a specific date and make a schedule for all groups on this day of the week.

How better to design the database?

Please log in or register to add a comment.

Please log in or register to answer this question.

6 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

Most popular tags