Ви переглядаєте архівну версію офіційного сайту НУЛП (2005-2020р.р.). Актуальна версія: https://lpnu.ua

Database and Knowledge Base Organization

Major: Computer Sciences
Code of Subject: 6.122.00.O.4
Credits: 5
Department: Automated Control Systems
Lecturer:
Semester: 1 семестр
Mode of Study: денна
Learning outcomes:
Required prior and related subjects:
Summary of the subject:
Recommended Books:
Assessment methods and criteria:

Database and Knowledge Base Organization

Major: Computer Sciences
Code of Subject: 6.122.00.O.6
Credits: 5
Department: Artificial Intelligence Systems
Lecturer: Melnykova N.I.
Semester: 1 семестр
Mode of Study: денна
Learning outcomes:
know:
- ability to demonstrate knowledge and understanding of the scientific and mathematical principles underlying information technology;
- ability to demonstrate knowledge of the basics of professionally oriented disciplines of specialty: methods and tools of modern information technologies, computer technology and modern technologies of information systems design and programming, mathematical methods of analysis and synthesis of complex objects, methods of collection, processing, analysis, systematization and storage of scientific and technical information, methods and means of distributed systems and parallel computing, principles and methods of construction and application of computer networks, principles w eb-technologies and methods and methods of their use for solving specialty problems;
- the ability to demonstrate advanced knowledge in at least one area of information technology;
- the ability to demonstrate knowledge and skills in experimentation, data collection and domain modeling;
- ability to demonstrate an understanding of the impact of technical solutions in a social, economic, social and environmental context; ability to demonstrate knowledge of economics and project management
- to know the basics of professional-oriented disciplines in the field of computer sciences;
- methodology for designing relational databases;
- memory structure and index structures of DBMS MS SQL Server;
- basic structure of the SQL language;
- standard interfaces for accessing database servers.

be able:

- to work effectively both individually and in the team, to present the results of work;
- to be able to search information in various sources for solving specialty tasks;
- to be able to think systematically and apply creative abilities to the formation of fundamentally new ideas;
- design application databases;
- to develop and implement the logical and physical models of data representation with the help of specialized CASE-tools in the conditions of an automated workplace;
- to create software for access and data management.
Required prior and related subjects:
Algorithmic and Programming, part 2
Discrete mathematics
Teamwork and presentation skills
Summary of the subject:
Relational data model Normalization of the database. ER-databases. The language of structured SQL queries. MS SQL Server memory structures and index structures. Manage Transactions. Technology of object-relational mapping. Hibernate BUSINESS INTELLIGENCE (introduction).
Recommended Books:
Coronel C., Morris S. Database Systems: Design, Implementation, and Management. 12th ed. – Cengage Learning, 2017. – 818 p.
Connolly T.M., Begg C.E. Database Systems: A Practical Approach to Design, Implementation and Management: Global Edition. – 6th Edition. – Pearson Education, 2015. – 1440 p.
Kroenke D.M., Auer D.J. Database Processing: Fundamentals, Design, and Implementation. 14th ed. – Pearson Education Ltd., 2016. – 638 p.
Elmasri R., Navathe S.B. Fundamentals of Database Systems. 7th ed. – Addison Wesley, 2016. – 1272 p.
Foster E.C., Godbole S. Database Systems: A Pragmatic Approach. Second Edition. – Apress, 2016. – 619 p.
Powell G. Beginning Database Design. – Wrox, 2006. – 500 p.
Bagui S., Earp R. Database Design Using Entity-Relationship Diagrams. 2nd ed. – CRC Press, 2011. – 362 p.
Hernandez M.J. Database Design for Mere Mortals. 3rd Edition. – Addison-Wesley Professional, 2013. – 672 p.
Dewson R. Beginning SQL Server for Developers. 4th ed. – Apress, 2015. – 670 p.
Петкович Душан. Microsoft SQL Server 2012. Руководство для начинающих. СПб.: БХВ-Петербург, 2013. — 816 с.
Assessment methods and criteria:
laboratory works - 30
settlement work -15
written component - 40
oral component – 15

Database and Knowledge Base Organization

Major: Computer Sciences
Code of Subject: 6.122.00.O.5
Credits: 5
Department: Computer-Aided Design
Lecturer:
Semester: 1 семестр
Mode of Study: денна
Learning outcomes:
Required prior and related subjects:
Summary of the subject:
Recommended Books:
Assessment methods and criteria: