|
1 |
Title of discipline |
Database-management systems |
|
2 |
Course of teaching |
4, specialty 1-31 03 01-04 Mathematics (scientific and design activity) |
|
3 |
Semester of teaching |
7 |
|
4 |
Number of credits |
2 |
|
5 |
Full name of lecturer |
Senior lecturer Zaitcev Viktor Sergeevich |
|
6 |
Objectives of the study disciplines |
The aim of the discipline is to teach students the common data models, which are used in modern DBMS, the basics of relational databases, the common constructions of the data definition languages (DDL) and data manipulation languages (DML). As a result of study, the students should be able to: – determine normal relation forms, to decompose the relations to bring it to the normal form of Boyce-Codd and the fourth normal form; – use the data manipulation language SQL. |
|
7 |
Prerequisites |
Programming Methods and Informatics. |
|
8 |
Content of discipline |
An introduction to databases. DBMS Access. Basic concepts of relational algebra. Database design. Database automation tools. Structured query language (SQL). MS SQL Server. New directions in DBMS. |
|
9 |
Recommended literature |
1. Homonenko A.D. Databases: textbook for higher education institutions – St. Petersburg, 2000. 2. Prague C., Irwin M. Microsoft Access 2000 Bible – John Wiley & Sons, Inc. New York, NY, USA, 1999. 3. Date C.J. An Introduction to Database Systems, 7th edition. – Addison-Wesley Pub (Sd), 2002. |
|
10 |
Teaching Methods |
Problematic, communicative with elements of educational and research activity, controlled independent work. |
|
11 |
Language of teaching |
Russian |
|
12 |
Conditions (requirements), actual control |
– laboratory activities – tests |
|
13 |
Form of current certification |
Credit |