Ãëàâíàÿ              Ðåôåðàòû - Èíôîðìàòèêà

Ñîçäàíèå è îïèñàíèå áàçû äàííûõ ÑÒÓÄÅÍÒÛ (Îò÷åò ïî êóðñó Áàçû äàííûõ) - ðåôåðàò

Îò÷åò ïî êóðñó «Áàçû äàííûõ».

1.   Çàäà÷à: ñîçäàòü áàçó äàííûõ «Ñòóäåíòû».

2.   Ñòðóêòóðà áàçû äàííûõ.

Òàáëèöû:

Íàçâàíèå ïîëÿ Òèï ïîëÿ Êëþ÷åâîå ïîëå

Ãðóïïû

Êîä ãðóïïû Ñ÷åò÷èê ü
Íàçâàíèå ãðóïïû Òåêñòîâûé
Êîä êàôåäðû ×èñëîâîé
Êóðàòîð ×èñëîâîé

Êàôåäðû.

Êîä Ñ÷åò÷èê ü
Íàçâàíèå êàôåäðû Òåêñòîâûé
Ïîëíîå íàçâàíèå Òåêñòîâûé
Ôàêóëüòåò
×èñëîâîé
Ïðåäìåòû
Íàçâàíèå ïðåäìåòà
Òåêñòîâûé
ü
Êîä ïðåäìåòà Ñ÷åò÷èê
Êîä ×èñëîâîé
Ïðåïîäàâàòåëè
Êîä Ñ÷åò÷èê ü
Ôàìèëèÿ Òåêñòîâûé
Èìÿ Òåêñòîâûé
Êàôåäðà ×èñëîâîé
Ñòóäåíòû
Êîä ñòóäåíòà Ñ÷åò÷èê ü
Ôàìèëèÿ ñòóäåíòà Òåêñòîâûé
Èìÿ ñòóäåíòà Òåêñòîâûé
Îò÷åñòâî ñòóäåíòà Òåêñòîâûé
Ïîë Òåêñòîâûé
Êîä ãðóïïû ×èñëîâîé
Íàñåë¸ííûé ïóíêò Òåêñòîâûé
Íàçâàíèå ïóíêòà Òåêñòîâûé
Èíäåêñ Òåêñòîâûé
Óëèöà Òåêñòîâûé
Äîì Òåêñòîâûé
Êâàðòèðà Òåêñòîâûé
Òåëåôîí Òåêñòîâûé
Ñòóäåíòû è ïðåäìåòû
Êîä ñòóäåíòà ×èñëîâîé ü
Êîä ïðåäìåòà ×èñëîâîé

Ôàêóëüòåòû.

Êîä Ñ÷åò÷èê ü
Íàçâàíèå ôàêóëüòåòà Òåêñòîâûé

3. Îïèñàíèå ñâÿçåé ìåæäó òàáëèöàìè.

Îòíîøåíèå 1

Òàáëèöà         Ïðåïîäàâàòåëè               Ïðåäìåòû

Ïîëå               Êîä                                Êîä

Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì

Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè

Îòíîøåíèå 2

Òàáëèöà         Ãðóïïû                          Ñòóäåíòû

Ïîëå               Êîä ãðóïïû                     Êîä ãðóïïû

Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì

Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè

Îòíîøåíèå 3

Òàáëèöà         Êàôåäðû                              Ãðóïïû

Ïîëå               Êîä                                Êîä êàôåäðû

Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì

Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè

Îòíîøåíèå 4

Òàáëèöà         Ïðåïîäàâàòåëè               Ãðóïïû

Ïîëå               Êîä                                Êóðàòîð

Òèï îòíîøåíèÿ:      áåç îáåñïå÷åíèÿ öåëîñòíîñòè

Àòðèáóòû:              îäèí-êî-ìíîãèì

Îòíîøåíèå 5

Òàáëèöà         Ïðåäìåòû                       Ñòóäåíòû è ïðåäìåòû

Ïîëå               Êîä ïðåäìåòà                                   Êîä ïðåäìåòà

Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì

Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè

 

Îòíîøåíèå 6

Òàáëèöà         Ãðóïïû                          Ïðåäìåòû

Ïîëå               Êîä ãðóïïû                     Êîä ïðåäìåòà

Òèï îòíîøåíèÿ:      îäèí-ê-îäíîìó

Àòðèáóòû:              îäíîçíà÷íûé, áåç îáåñïå÷åíèÿ öåëîñòíîñòè

Îòíîøåíèå 7

Òàáëèöà         Êàôåäðû                        Ïðåïîäàâàòåëè

Ïîëå               Êîä                                Êàôåäðà

Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì

Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè

Îòíîøåíèÿ 8

Òàáëèöà         Ôàêóëüòåòû                            Êàôåäðû

Ïîëå               Íàçâàíèå ôàêóëüòåòà         Êîä

Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì

Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè

4. Îïèñàíèå çàïðîñîâ.

5. Ïðèìåðû ôîðì è îò÷åòîâ.


                Êàôåäðû

                              Íàçâàíèå êàôåäðû          ÎÐÌÏÈ

        Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî

        Øàäðóíîâ                                   Âëàäèìèð                                    Àëåêñàíäðîâè÷

        ×åð÷èíöåâà                                 Òàìàðà                                         Ñåðãååâíà

        Êàðàóëîâ                                     Ãåííàäèé                                     Àíäðååâè÷

        Ãàáèòîâ                                       Ðîáåðò                                         Ìóõòàðîâè÷

                              Íàçâàíèå êàôåäðû          ÏÐÌÏÈ

        Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî

        Ïåðãàìåíò                                   Âëàäèìèð                                    Õàèìîâè÷

                              Íàçâàíèå êàôåäðû          Ìàòåì

        Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî

        Èçîñîâ                                        Âëàäèìèð                                    Àëåêñååâè÷

                              Íàçâàíèå êàôåäðû          ÂÒ è ÏÌ

        Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî

        Ôèëèïïîâ                                   Âëàäèìèð                                    Âèêòîðîâè÷

15 ÿíâàðÿ 2000 ã.                                                                                                                                          Ñòðàíèöà 1 èç 1


                Ñïèñîê

                                   Ôàìèëèÿ                             Èìÿ                                         Îò÷åñòâî             Êàôåäðà

                                   Ãàáèòîâ                                    Ðîáåðò                                      Ìóõòàðîâè÷               ÎÐÌÏÈ

                                   Êàðàóëîâ                                 Ãåííàäèé                                 Àíäðååâè÷  ÎÐÌÏÈ

                                   Ôèëèïïîâ                                Âëàäèìèð                                Âèêòîðîâè÷               ÂÒ è ÏÌ

                                   ×åð÷èíöåâà                             Òàìàðà                                     Ñåðãååâíà  ÎÐÌÏÈ

                                   Èçîñîâ                                     Âëàäèìèð                                Àëåêñååâè÷                Ìàòåì

                                   Øàäðóíîâ                                Âëàäèìèð                                Àëåêñàíäðîâè÷         ÎÐÌÏÈ

                                   Ïåðãàìåíò                               Âëàäèìèð                                Õàèìîâè÷   ÏÐÌÏÈ

  15 ÿíâàðÿ 2000 ã.                                                                                                                                           Ñòðàíèöà 1 èç 1