Ministry of Education and Science of the Republic of Kazakhstan Non-Profit JSC «Almaty University of Power Engineering and
Telecommunications»
Faculty of Radio Engineering and Telecommunications
“Electronics” Department
«Approved»
Dean of FRET _____________ U.Medeuov
“_____”___________ 2014.
Syllabus
on PS 3308 – DATA COLLECTION AND STORAGE SYSTEM for students majoring in 5B071600 specialty – Instrument making
Year of study 3-rd
Semester 6-th
Number of credits 3
Total ECTS credits 6
Total hours 135
including: lectures 22 h
practical classes 15 h
laboratory classes 15 h
Self-study assignments (SSA) 75 h including: self-study under the
teacher’s supervision (SSTUS) 30h
Computation graphic work 3
Examination
Almaty 2014
The Course Syllabus has been developed by T. V. Golubeva, senior teacher.
The syllabus is based on the curriculum and the standard program of the discipline for 5B071600 specialty – Instrument making.
The Course Syllabus has been reviewed at the meeting of “Electronics”
Department of 26.05.2014, minutes No. 10.
“Electronics” Department Chair___________________A.A.Kopesbayeva
The Course Syllabus has been approved at meeting of educational- methodical commission of FRET 05.06.2014, minutes No.8.
About teacher: Golubeva T. V., senior-teacher. Published 16 scientific articles and methodical works, scientific and pedagogical experience is 9 years.
Laboratory classes according to the discipline are held in laboratory B-426.
Office: «Electronics» department
Address: 050013, Almaty, Baitursynov street, 126. AUPET
1. Details about instructors
T.V. Golubeva, senior teacher, she has published 16 scientific papers, as well as methodological instructions. Office: “Electronics” department: tel. 278-46- 83, [email protected].
Laboratory classes according to this discipline are held in specialized laboratory B-329.
Office: “Electronics” Department
Address: 050013, Almaty, Baytursynov street, 126, AUPET Contacts: 278-46-83, [email protected]
1 AIM OF THE COURSE
Goals and tasks of discipline are ensuring an adequate body of knowledge and skills on the normative - legal standards of information systems for the collection and storage of data. The problem of the discipline is learning the main principles and methods of modern means for collecting and storing data.
At the end of the study discipline a student must:
know – legal and regulatory framework of the state system of standards for engineering data collection systems.
be able to read, correct, supplement project documentation of data collection systems.
Have skills to use standards for engineering data collection system.
Prerequisites: materials technology of electronic devices, standardization, metrology and certification.
Postrequisites: devices and systems of displaying information, industrial network of information management systems, technological process automation means.
2 System of evaluation
The level of student’s progress in studying the course program is evaluated under the scale adopted in the credit education technology (see Table 1).
Table 1
Letter assessment
Digital equivalent s of points
Grade in % Traditional evaluation
А 4.0 95-100 Excellent
А- 3.67 90-94 Excellent
В+ 3.33 85-89 Good
В 3.0 80-84 Good
В- 2.67 75-79 Good
С+ 2.33 70-74 Satisfactory
С 2.0 65-69 Satisfactory
С- 1.67 60-64 Satisfactory
D+ 1.33 55-59 Satisfactory
D- 1.0 50-54 Satisfactory
F 0 0-49 Unsatisfactory
Evaluation of access rating (AR) is accumulated within a semester. Each kind of academic task is evaluated by 100 – point scale and included into the access rating taking into account a coefficient according to Table 2.
Table 2
Parameter Coefficient
Laboratory course 0,4
Course work 0,4
Mid-term tests 0,1 Attending lectures 0,1
Total 1,0
Final assessment is calculated as follows:
F = 0.6AR + 0.4E where E is a mark at the examination.
Maximal grade is given in case of the rhythmic fulfillment and high quality of studying. Points for testing and attending are given according to the number of correct answers and missed lectures.
Credit transfer at academic mobility of the university students
Credit transfer of ECTS (European Credit Transfer System) into grade-rating letter system and vice versa is carried out according to Tables 3 and 4.
Table 3 - Credit transfer of ECTS (European Credit Transfer System) into the grade- rating letter system of evaluation of students’ academic achievements in RK.
Evaluation
by ECTS Letter assessment
Digital equivalent
of points
Grade in %
Traditional evaluation
А А 4.0 100 Excellent
В В+ 3.33 85
Good
С В 3.0 80
D С 2.0 65
Satisfactory
E D 1.0 50
FX, F F 0 0 Unsatisfactory
Table 4 - Transfer of grade-rating letter system of the Republic of Kazakhstan into ECTS evaluation system
Letter system
Digital equivalent of
points
Grade in % Traditional evaluation
Evaluation by ECTS
А 4.0 95-100
Excellent А
А- 3.67 90-94
В+ 3.33 85-89 Good В
В 3.0 80-84
Good С
В- 2.67 75-79
С+ 2.33 70-74 Satisfactory
С 2.0 65-69 Satisfactory D
С- 1.67 60-64
D+ 1.33 55-59
D 1.0 50-54 Satisfactory E
F 0 0-49 Unsatisfactory FX, F
Policy of the course
- do not be late and do not miss classes;
- be attentive and monitor the class scenario suggested by the lecturer and take an active part in classes;
- missed classes will be credited if a student miss them for good reasons;
- provide course paper not later than in the next-to-last week of the semester;
- self-study in the library and at home.
Norms of academic ethics:
- discipline;
- politeness;
- goodwill;
- honesty;
- responsibility;
- study in classrooms with off mobile phones.
Conflict situations shall be discussed in an open way in the student groups with a lecturer and an advisor; if it is impossible to solve the conflict it shall be reported to the Dean Office.
3 CONTETNT OF THE COURSE
The learning of the «Collecting and storing data systems» implies mandatory lectures and laboratory classes and independent students’ work. Table 5 consists of information about the thematic plan of the discipline with indication of themes and number of academic hours for each theme.
3.1 Lectures Table 5
№ Sections Content of lectures Hours
1 Introduction The description of the main functions of Database Management Systems (DMS), transaction management and logging
2 (1,2,3)
2 СТ РК 1237-2004 The system of the standards of information, library and publishing industry. The main technical
requirements for archival storage
2 (3,6)
3 The main concepts of a relational approach to the database organization.
Main concepts and
definitions. Basic tools of relational data manupilation
Basic concepts of relational databases are given. Fundamental properties of the relationship and relational model of the data are described. Relational algebra and relational estimate.
2 (1,2,3)
4 ГОСТ 34.321-96 The system of standards of databases.
The reference model of data management.
2 (1,2,3) 5 The relational database
design and internal
organization of relational DMS
Database normalization, modeling, ER-diagrams. The memory organization, indexes, log information.
2 (1,2,3)
6 The transaction management and transaction serialization
Transactions and the integrity of data.
The user disconnection. The transaction serialization.
2 (1,2,3) 7 Transaction serialization
methods
Synchronized captures: granular synchronized captures, predicate synchronized captures, deadlocks, recognition and destruction.
2 (1,2,3)
8 Logging database changes Logging and buffering. Individual transaction rollback.
Mild failure recovery.
Physical database consistency.
Hard failure recovery.
2 (1,2,3)
9 SQL database language Queries of data manipulation.
Operators of definition and
6 (1,3,4)
manipulation of database schemes.
Definition of integrity constraints and triggers.
Database presentation.
Definition of management structures Access authorization to the relations and its fields.
Save points and kickbacks of transactions. Built-SQL. Dynamic SQL.
3.2 Practical classes
Methodological recommendations for work execution can be found in printed form at “Electronics” department .
Table 6
№ Theme Content Hours
1 Database creation Script writing for database, tables creation and communication on key fields.
2 (1,3,5) 2 Database filling Script writing for filling database
tables by information. Entering with one entry. Entering data arrays from structured text-files.
4 (1,3,5)
3 Table structure modification in databases
Script writing for table modification in active databases.
Change of dimension and field type.
Field entering.
4 (1,3,5)
4 Data searching Writing queries for searching in database. Data aggregation.
Operations in the sample data.
4 (1,3,5) 5 Data modification Script writing for changing
information in active databases, data removing taking into account the existing links between tables.
2 (1,3,5)
3.3 Laboratory classes
Methodological recommendations for work execution can be found in printed form at “Electronics” department .
Table 7
№ Theme Content Hours
1 Database creation Create a database, tables, link tables according to key fields.
2 (1,3,5) 2 Database filling Enter the information in database
tables. Entering one by one. Entering data arrays from structured text-files.
4 (1,3,5) 3 Database tables structure
modification
Modify tables in active databases.
Make changes on dimension and field type. Add new fields.
4 (1,3,5) 4 Data searching Write queries to the database.
Написать запросы к базе данных для поиска. Work out data aggregation and operations in the sample data.
4 (1,3,5)
5 Data modification Write and work out scripts for changing information in active
databases, make data removing taking into account the existing links
between tables.
2 (1,3,5)
3.4 Themes for computation graphic work (CGW) The sample list of themes for CGW [1-5]
1. Create data storage of patients for hospital.
2. Create students database for educational institution . 3. Create data storage of books for library.
3.5 Self-Study Activities (SSA)
One of the main aims of credit system education is ensuring a high quality level of students’ self-study activities, which, in turn, requires improving the quality of teaching and methodological maintenance of discipline. Students' independent work, carried out under the guidance of a teacher takes 50% of all independent work.
The total hours of SSA is 83 academic hours. SSA held on the topics of lectures, laboratory exercises and CGW.
Exam questions
1. Database. Information systems. Databank. Database Management Systems.
Main concepts and definitions.
2. Documentary and factual information systems.
3. The life cycle of information systems and databases.
4. Life cycle models. Cascade, iterative spiral model. DMS - historical review and current state.
5. Main functions of DMS.
6. Architecture of DMS. The centralized architecture.
7. Architecture of DMS. «File-server» architecture.
8. Architecture of DMS. «Client-server» architecture.
9. Architecture of DMS. «Client-server» three-tier (multi-link) architecture.
10. Data types and models. Hierarchical. Network. Relational. Advantages.
Disadvantages. Examples.
11. The structure of the relational model. Relation. Attributes. Domains. Tuples.
Scheme of relationship. Restrictions.
12. Manipulation of the relational model. Conventional operations. Special relational operations.
13. Integral part of the relational model. The primary key. Key properties. Foreign key.
14. Stages of database design. Infological design.
15. Modeling method «Entity - Relationship» (ER-diagram). Examples.
16. Types of relationship between entities. Examples.
17. Logical Design. Mapping Rules of ER - diagrams on logic schemes. Examples.
18. Physical Design.
19. Table normalization. Issues, solved during table normalization.
20. Table normalization. 1 normal form. Examples.
21. Table normalization. 2 normal form. Functional dependency.
22. Table normalization. 3 normal form. Normal form of Boyce-Codde.
23. Table normalization. 4 normal form. 5 normal form.
24. Data storage. the distinction of data storage from relational base.
25. MS Access. Table Object. Purpose. Operating Modes. Field properties. Setting..
Tables relationships.
26. MS Access. Queries Object. Purpose. Operating modes. Request form.
Selection condition. Sort. Grouping. Query with a parameter. Calculated field.
Requests from multiple tables.
27. MS Access. Select queries. Crosstab query. Requests to create, update, add, delete tables.
28. MS Access. Form object. Purpose. Modes of operation. Subform. Controls.
Sections of the form.
29. MS Access. Object Reports. Purpose. Modes of operation. Grouping records.
Sort. Sections of the report.
30. MS Access. Объект Macro object. Purpose. Establishing conditions. Examples
31. What determines the standard СТ РК 1237-2004.
32. What determines the standard ГОСТ 34.321-96.
33. Model of exports and imports in accordance with the ГОСТ 34.321-96.
34. The access control model in accordance with the ГОСТ 34.321-96.
35. Standardisation of access control - ГОСТ 34.321-96.
5 Recommended books and materials 5.1 Main
1. Гагарина Л.Г. Алгоритмы и структура данных.-М.: «Финансы и статистика»,2009
2. Кузин А.В. Базы данных.-М.,2008
3. Фуфаев Э.В. Базы данных.-М.: «Академия», 2006, 2007,2011 4. Кариев Ч.А. Технология Microsoft ADO.NET.-М.,2007,2012
5. Гультяев А.К. Управление проектами Microsoft Office Professional 2007.-СПб.: «Корона-Век»,2010
5.2 Additional
1. Гвоздева Т.В. Проектирование информационных систем.-Ростов- на/Д.,2009
2. Виейра Р. Программирование баз данных Microsoft SQL Server 2005.
Базовый курс.-М.,2007
3. Бекаревич Ю. Access 2007.-СПб.,2007
4. Базы данных/состав. О.С.Ахметова.-А.: «КазНПУ» ,2012
5. Агальцов В.П. Базы данных. Кн.2. Распределенные и удаленные базы данных.-М.: «Форум» - Инфра-М,2009
