Information Systems Databases (курсова робота)

Major: Telecommunications and Radio Engineering
Code of subject: 6.172.05.E.141
Credits: 2.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 7 семестр
Mode of study: денна
Learning outcomes: By the end of the study, learners are expected to: – demonstrate knowledge of database conceptual design; – design a user’s model for a chosen subject domain and to convert it into the infological model presented as entity-relationship diagram in MS Visio; – demonstrate knowledge of relational database schema design by employing the concepts of normal forms and entity-relationship diagrams in MS Visio; – translate relational database logical model into Access database schema by creating the tables, defining the data and determining the relations; – demonstrate knowledge of querying relational databases by using SQL and QBE; – design DB management facilities (queries, forms and reports) in for a DB developed; – load DB developed with appropriate data in the amount enough for DB testing; – be able to present results of DB design and to substantiate it while discussing them with other students and teachers.
Required prior and related subjects: – Informatics of the information and communication systems – Modelling of radioelectronic devices – Software facilities of information-computer technologies – Databases in information and computer systems
Summary of the subject: Conceptual modelling and database design. Identifying the subject domain and user requirements to the database. Development of user’s model for a chosen subject domain. Creation of the infological model as an Entity-Relationship (ER) diagram in MS Visio. Identifying strong entities, attributes, keys and relationships. Refining the ER model by introducing weak and associative entities. Logical modelling and database design. Refining the infological model by adjusting in accordance with relational data model. Development of a relational database logical model in MS Visio. Estimation of relationship characteristics and referential actions. Datalogical modelling and database design Translating relational database logical model into Access database schema by creating the tables and establishing relations. Data definition, assignment of primary and foreign keys. Loading the developed DB with appropriate data in the amount enough for DB testing. Database management. Design of DB management facilities (queries, forms and reports). Assignment of access rights. Interface development. DB testing.
Assessment methods and criteria: – Current control: oral interviewing and checking of course work advance – 40 points (40 %); – Final control: control procedure - – differentiated test/credit: course work defence – 60 points (60 %)
Recommended books: 1. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. _ Львів: «Магнолія 2006»б 2008. – 456 с 2. Конноли Т., Бегг К., Страчан А. Базы данных: проектирование, реализация и сопровождение. Теория и практика. – М.: Изд. Дом “Вильямс”. 2000. – 1120 с. 3. Роб П., Коронел К. Системы баз данных: проектирование, реализация и управление. 5-е изд. – СПб.: БХВ-Петербург. – 2004. – 1040 с. 4. Elmasri R. Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.—6th ed. p. cm. – N.Y.-Addison-Wesley, Pearson, 2010. - 1200 pages. ISBN-13: 978-0-136-08620-8. 5. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с. 6. Пирогов В. Ю. Информационные системы и базы данных: организация и проектирование: учеб. Пособие / В. Ю. Пирогов. — СПб.: БХВ-Петербург, 2009. — 528 с. 7. Гліненко Л.К. Методичні вказівки до виконання курсової роботи з дисципліни «Бази даних в інформаційно-комп’ютерних системах» / Л.К.Гліненко. Львів: Видавництво львівської політехніки, 2018

Information Systems Databases

Major: Telecommunications and Radio Engineering
Code of subject: 6.172.05.E.137
Credits: 4.00
Department: Electronics and Information Technology
Lecturer: Hlinenko Larysa
Semester: 7 семестр
Mode of study: денна
Learning outcomes: By the end of the study, learners are expected to: – comprehend the fundamentals of database approach, database design and the use of database management systems for applications in infocommunication systems; – know the fundamentals of relational database organization and means of manipulating the relational data; – demonstrate knowledge and skills of relational database schema design by employing the concepts of entity-relationship diagrams, normal forms and normalizing procedures; – declare, define, and access relational database schemas in relational database management systems using the data definition language subset of SQL and facilities of QBE; – demonstrate knowledge and skills of querying relational databases by using SQL and the ability to convert relational algebra queries to SQL; – be able to apply the acquired knowledge for the relational database development in DBMS Access and to support query and constraint realization with QBE and SQL; – demonstrate knowledge of recent advances in database systems by identifying the connection between traditional relational databases and other data models; – be able to present results of DB design and to substantiate it while discussing them with other students
Required prior and related subjects: – Informatics of the information and communication systems – Modelling of radioelectronic devices – Software facilities of information-computer technologies
Summary of the subject: Characteristics of the database (DB) approach. Advantages of using the DB approach. Data and structure independence. Database system concepts and architecture. Database management systems (DBMS). DBMS architecture and functions. Data models and schemas. Traditional and advanced data models. Database languages and interfaces. Centralized and client/server architectures for DBMSs. Classification of database management systems. The relational data model and relational database constraints. The relational algebra and relational calculus. Relational algebra operations from set theory. Unary relational operations: SELECT and PROJECT. Binary relational operations: JOIN and DIVISION. Conceptual modelling and database design. Data modelling using the Entity-Relationship (ER) model. Entity types, entity sets, attributes, and keys. Relationship types, Relationship sets, roles and characteristics. Notations of ER model. Database design theory and normalization. Basics of functional dependencies and normalization for relational databases. Normal forms. Relational decompositions algorithms for relational database schema design. Basic SQL. SQL Data Definition and data types. Specifying constraints in SQL. Views (virtual tables) in SQL Basic retrieval queries in SQL. INSERT, DELETE, and UPDATE statements in SQL. Introduction to transaction processing. Desirable properties of transactions. Characterizing schedules based on serializability. Concurrency control techniques. Two-Phase locking techniques for concurrency control. Database recovery techniques. Databases of radioelectronic components and technological equipment. Databases of scientific and engineering effects. New DB technologies. OLAP and OLTP Systems. Data warehouses. Multidimensional, object-oriented and object-relational systems, areas of application.
Assessment methods and criteria: – Current control: laboratory reports, oral interviewing, written tests – 40 points (40 %): laboratory works execution and defence - 10 pointstests - 30 points – Final control: control procedure - written and verbal examination (60 %): written examination (test) - 54 points; oral interviewing (verbal examination) - 6 points
Recommended books: 1. Берко А.Ю., Верес О.М., Пасічник В.В. Системи баз даних та знань. Книга 1. Організація баз даних та знань: навч. посібник. _ Львів: «Магнолія 2006»б 2008. – 456 с 2. Конноли Т., Бегг К., Страчан А. Базы данных: проектирование, реализация и сопровождение. Теория и практика. – М.: Изд. Дом “Вильямс”. 2000. – 1120 с. 3. Роб П., Коронел К. Системы баз данных: проектирование, реализация и управление. 5-е изд. – СПб.: БХВ-Петербург. – 2004. – 1040 с. 4. Elmasri R. Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.—6th ed. p. cm. – N.Y.-Addison-Wesley, Pearson, 2010. - 1200 pages. ISBN-13: 978-0-136-08620-8. 5. Павлиш В.А., Гліненко Л.К. Основи інформаційних технологій і систем: навч. посібник / В.А.Павлиш, Л.К. Гліненко. - Львів: Видавництво львівської політехніки, 2013. - 500 с. 6. Пирогов В. Ю. Информационные системы и базы данных: организация и проектирование: учеб. Пособие / В. Ю. Пирогов. — СПб.: БХВ-Петербург, 2009. — 528 с.