Ñîçäàíèå è îïèñàíèå áàçû äàííûõ ÑÒÓÄÅÍÒÛ (Îò÷åò ïî êóðñó Áàçû äàííûõ) Îò÷åò ïî êóðñó «Áàçû äàííûõ». 1.   Çàäà÷à: ñîçäàòü áàçó äàííûõ «Ñòóäåíòû». 2.   Ñòðóêòóðà áàçû äàííûõ. Òàáëèöû: Íàçâàíèå ïîëÿ Òèï ïîëÿ Êëþ÷åâîå ïîëå Ãðóïïû Êîä ãðóïïû Ñ÷åò÷èê ü Íàçâàíèå ãðóïïû Òåêñòîâûé Êîä êàôåäðû ×èñëîâîé Êóðàòîð ×èñëîâîé Êàôåäðû. Êîä Ñ÷åò÷èê ü Íàçâàíèå êàôåäðû Òåêñòîâûé Ïîëíîå íàçâàíèå Òåêñòîâûé Ôàêóëüòåò ×èñëîâîé Ïðåäìåòû Íàçâàíèå ïðåäìåòà Òåêñòîâûé ü Êîä ïðåäìåòà Ñ÷åò÷èê Êîä ×èñëîâîé Ïðåïîäàâàòåëè Êîä Ñ÷åò÷èê ü Ôàìèëèÿ Òåêñòîâûé Èìÿ Òåêñòîâûé Êàôåäðà ×èñëîâîé Ñòóäåíòû Êîä ñòóäåíòà Ñ÷åò÷èê ü Ôàìèëèÿ ñòóäåíòà Òåêñòîâûé Èìÿ ñòóäåíòà Òåêñòîâûé Îò÷åñòâî ñòóäåíòà Òåêñòîâûé Ïîë Òåêñòîâûé Êîä ãðóïïû ×èñëîâîé Íàñåë¸ííûé ïóíêò Òåêñòîâûé Íàçâàíèå ïóíêòà Òåêñòîâûé Èíäåêñ Òåêñòîâûé Óëèöà Òåêñòîâûé Äîì Òåêñòîâûé Êâàðòèðà Òåêñòîâûé Òåëåôîí Òåêñòîâûé Ñòóäåíòû è ïðåäìåòû Êîä ñòóäåíòà ×èñëîâîé ü Êîä ïðåäìåòà ×èñëîâîé Ôàêóëüòåòû. Êîä Ñ÷åò÷èê ü Íàçâàíèå ôàêóëüòåòà Òåêñòîâûé 3. Îïèñàíèå ñâÿçåé ìåæäó òàáëèöàìè. Îòíîøåíèå 1 Òàáëèöà         Ïðåïîäàâàòåëè               Ïðåäìåòû Ïîëå               Êîä                                Êîä Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè Îòíîøåíèå 2 Òàáëèöà         Ãðóïïû                          Ñòóäåíòû Ïîëå               Êîä ãðóïïû                     Êîä ãðóïïû Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè Îòíîøåíèå 3 Òàáëèöà         Êàôåäðû                              Ãðóïïû Ïîëå               Êîä                                Êîä êàôåäðû Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè Îòíîøåíèå 4 Òàáëèöà         Ïðåïîäàâàòåëè               Ãðóïïû Ïîëå               Êîä                                Êóðàòîð Òèï îòíîøåíèÿ:      áåç îáåñïå÷åíèÿ öåëîñòíîñòè Àòðèáóòû:              îäèí-êî-ìíîãèì Îòíîøåíèå 5 Òàáëèöà         Ïðåäìåòû                       Ñòóäåíòû è ïðåäìåòû Ïîëå               Êîä ïðåäìåòà                                   Êîä ïðåäìåòà Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè   Îòíîøåíèå 6 Òàáëèöà         Ãðóïïû                          Ïðåäìåòû Ïîëå               Êîä ãðóïïû                     Êîä ïðåäìåòà Òèï îòíîøåíèÿ:      îäèí-ê-îäíîìó Àòðèáóòû:              îäíîçíà÷íûé, áåç îáåñïå÷åíèÿ öåëîñòíîñòè Îòíîøåíèå 7 Òàáëèöà         Êàôåäðû                        Ïðåïîäàâàòåëè Ïîëå               Êîä                                Êàôåäðà Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè Îòíîøåíèÿ 8 Òàáëèöà         Ôàêóëüòåòû                            Êàôåäðû Ïîëå               Íàçâàíèå ôàêóëüòåòà         Êîä Òèï îòíîøåíèÿ:      îäèí-êî-ìíîãèì Àòðèáóòû:              áåç îáåñïå÷åíèÿ öåëîñòíîñòè 4. Îïèñàíèå çàïðîñîâ. 5. Ïðèìåðû ôîðì è îò÷åòîâ.                 Êàôåäðû                               Íàçâàíèå êàôåäðû          ÎÐÌÏÈ         Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî         Øàäðóíîâ                                   Âëàäèìèð                                    Àëåêñàíäðîâè÷         ×åð÷èíöåâà                                 Òàìàðà                                         Ñåðãååâíà         Êàðàóëîâ                                     Ãåííàäèé                                     Àíäðååâè÷         Ãàáèòîâ                                       Ðîáåðò                                         Ìóõòàðîâè÷                               Íàçâàíèå êàôåäðû          ÏÐÌÏÈ         Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî         Ïåðãàìåíò                                   Âëàäèìèð                                    Õàèìîâè÷                               Íàçâàíèå êàôåäðû          Ìàòåì         Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî         Èçîñîâ                                        Âëàäèìèð                                    Àëåêñååâè÷                               Íàçâàíèå êàôåäðû          ÂÒ è ÏÌ         Ôàìèëèÿ                                  Èìÿ                                            Îò÷åñòâî         Ôèëèïïîâ                                   Âëàäèìèð                                    Âèêòîðîâè÷ 15 ÿíâàðÿ 2000 ã.                                                                                                                                          Ñòðàíèöà 1 èç 1                 Ñïèñîê                                    Ôàìèëèÿ                             Èìÿ                                         Îò÷åñòâî             Êàôåäðà                                    Ãàáèòîâ                                    Ðîáåðò                                      Ìóõòàðîâè÷               ÎÐÌÏÈ                                    Êàðàóëîâ                                 Ãåííàäèé                                 Àíäðååâè÷  ÎÐÌÏÈ                                    Ôèëèïïîâ                                Âëàäèìèð                                Âèêòîðîâè÷               ÂÒ è ÏÌ                                    ×åð÷èíöåâà                             Òàìàðà                                     Ñåðãååâíà  ÎÐÌÏÈ                                    Èçîñîâ                                     Âëàäèìèð                                Àëåêñååâè÷                Ìàòåì                                    Øàäðóíîâ                                Âëàäèìèð                                Àëåêñàíäðîâè÷         ÎÐÌÏÈ                                    Ïåðãàìåíò                               Âëàäèìèð                                Õàèìîâè÷   ÏÐÌÏÈ   15 ÿíâàðÿ 2000 ã.                                                                                                                                           Ñòðàíèöà 1 èç 1