1

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?

2

Re: Database structure of electronic log (automated workplace of the Teacher)

Database I want to connect to Delphi. Here an interface sketch.

3

Re: Database structure of electronic log (automated workplace of the Teacher)

150698 wrote:

I think that it is necessary to anchor still Disciplines to Specialities.

And what for? What practical task will be solved by this communication?

4

Re: Database structure of electronic log (automated workplace of the Teacher)

Dimitry Sibiryakov wrote:

it is passed...
And what for? What practical task will be solved by this communication?

That the student of a speciality "the theoretical physics" could not be delivered a twain under the Law Divine and to leave that without the grant wink
The HARDWARE - communication of disciplines and specialities is essence "curriculum". If to enter "curriculum", arises to enter and "schedule". Look, whether it enters into your task.
By the way, here that  it is exact in the task enters is "types of estimations". An estimation at a seminar, an estimation for , an estimation for examination, etc.

5

Re: Database structure of electronic log (automated workplace of the Teacher)

To tell the truth, I in confusion. How to me then to define, what groups study a specific subject? If at me all disciplines which are conducted by the teacher, and group this subject are selected does not study, what then?

6

Re: Database structure of electronic log (automated workplace of the Teacher)

150698 wrote:

As to me then to define, what groups study a specific subject?

By the exposed estimations?.

7

Re: Database structure of electronic log (automated workplace of the Teacher)

Cat Matroskin;
+

Matroskin wrote:

the HARDWARE - communication of disciplines and specialities is essence "curriculum".

At me the table plan

Matroskin wrote:

By the way, here that  is exact in the task enters is "types of estimations". An estimation at a seminar, an estimation for , an estimation for examination, etc.

... for_wats
Exceptional as the general example demanding a file:

8

Re: Database structure of electronic log (automated workplace of the Teacher)

Well and accordingly the automated workplace of the teacher in this circuit is a subset (part) of all functional of the circuit:
- To look at the plan and to come in time on occupations.
- To deliver estimations to students in day of occupation, it is possible not to everyone, some estimations to one student (course + an estimation for occupation) are possible.
As though and all...

9

Re: Database structure of electronic log (automated workplace of the Teacher)

150698 wrote:

To tell the truth, I in confusion. How to me then to define, what groups study a specific subject? If at me all disciplines which are conducted by the teacher, and group this subject are selected does not study, what then?

Well make "curriculum" if want. Simply logical following question "And well to select not all disciplines which are studied by group, and those disciplines occupations on which at this group transit today" - and then the schedule is required wink

10

Re: Database structure of electronic log (automated workplace of the Teacher)

Well))

11

Re: Database structure of electronic log (automated workplace of the Teacher)

150698 wrote:

it is good))

In a picture above in the table plan there is a date, time, audience, basically (for ) if  in it still a heap of parameters: occupation type (lecture, a seminar), an occupation Subject, duration... That this table with a tightness can descend both for the curriculum and for the schedule... smile))

12

Re: Database structure of electronic log (automated workplace of the Teacher)

150698 wrote:

To tell the truth, I in confusion. How to me then to define, what groups study a specific subject? If at me all disciplines which are conducted by the teacher, and group this subject are selected does not study, what then?

Simply you go to a teaching department and you start with them to extort - what papers appear at creation and group guiding
You learn that in the nature there is a curriculum, for each discipline, stated by the order
Further you do the curriculum for each educational group (readonly), and using the stated plan the plan of attendance and estimations, and further the pivot table for application formation to the diploma are formed....
The teacher conducts a subject, instead of group, the teacher can be ill and will be replaced, but the group should learn a lesson which to it is assigned in the plan...
Etc., etc.
...Interesting business if though someone, from those who will use it, in it is interested....

13

Re: Database structure of electronic log (automated workplace of the Teacher)

AndreyTarasov;
It is an academic year project)) be not frightened!