Topic: Database structure of electronic log (automated workplace of the Teacher)
Hello, respected ! I had problems with designing of a DB of electronic log.
At me meanwhile five tables: Specialities (Specialty), Groups (Groups), Students (Students), Estimations (Evalution), Disciplines (Discipline).
I think that Disciplines in an any way should be anchored to Estimations. But a problem still what not each group studies those disciplines which study remaining groups, accordingly, and specialities. I think that it is necessary to anchor still Disciplines to Specialities. But then the database structure will be shorted. Whether it is correct? How then to build a SQL query?