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.