Semester: Winter
Lectures/Classes: 30 / 30 hours
Field of study: Bioinformatics
Study cycle: 2nd cycle
Type of course: compulsory
Contact person: dr Jacek Lewandowski
Short description: The module introduces the theory and practice of: 1) the basics of UML modeling, 2) database modelling techniques and syntax of database queries in SQL, 3) methods used to design and implement database applications in Java. The aim of the module is to introduce students to the practical use of programming languages to create database applications for cross platform IT environments.
Full description: The module introduces and apply in practice: 1.the rules for creating UML models (class diagrams, use case diagrams, course diagrams) 6h, 2. database modelling techniques and syntax of the SQL queries (entity relationship diagram, relational database, data types, database operations, database queries) 8h 3. methods for implementation of database applications in Java (object programming, classes, inheritance, polymorphism, error handling, input / output streams, user interface). 12h The aim is to get acquainted with various types of languages and cross platform IT environments used in the process of data collection and processing.
Bibliography: 1. Schildt H.: Java: A Beginner’s Guide, Sixth Edition, McGraw-Hill Education, 2014 2. B. Eckel, Thinking in Java., Helion, ed. IV, 2006. 3. Beaulieu A.: Learning SQL, O'Reilly Media 2009. 4. Schildt, H.: Java: The Complete Reference, Ninth Edition, McGraw-Hill Education, 2014 5. G. Booch, J. Rumbaugh, I. Jacobson, The Unified Modeling Language Reference Manual, Addison-Wesley Professional, 2002.
Learning outcomes: Knowledge: The student know how to build and query database systems using SQL language. The student knows the basic UML models and can transfer them to the program code. The student knows the syntax, basic data structures and control structures in Java programming language. Skills: The student independently designs and implements relational databases and SQL queries to read/write relevant data from/to database. The student creates basic UML models and transfers them to the program code. The student creates simple Java programs. Social competences: The student understands the need to create a transparent code for others (using usual layout). The student understands the need for clear program code and clear HCI The student understands the need to document the created programming code.
Assessment methods and assessment criteria: PC lab assesment: in order to obtain a pass the student is required to complete all design and programming tasks as well as be able to present and discuss their design and code. Module assesment: Students who pass the PC lab assesment are subject to a written exam consisting of a test part (20-30 closed questions) and 3-5 open programming tasks. The exam lasts 120 minutes. If the exam is not passed in the first term, the student has the right to a resit in the form of an oral exam.

Return to the List of Courses