ECTS
ECTS Course Catalogue
Course details
Course code: IGS10180o11Semester: 2011/2012 summer
Name: Data bases
Major: Geodesy and Cartography
Study Type: first cycle
Course type: compulsory
Study Semester: 4
ECTS points: 3
Hours (Lectures / Tutorials / Other): 15 / 30 / 0
Lecturer: dr inż. Tomasz Kubik
Language of instruction: Polish / English
Learning outcomes: The student posses the basic knowledge about relational algebra, is able to design a database schema for a simple problem concerning database integrity requirements, is familiar with SQL queries used to manipulate data stored in the database, knows the processes occurring in the database and the role of databases in the architecture of enterprise solutions
Competences: the student may participate in projects requiring knowledge of data bases at the level of intermediate advanced user
Prerequisites: Information Technology, Informatics
Course content: Introduction (database systems and their management, query languages, client-server architecture). Database design (relational data model, the process of normalization, requirements analysis). Elements of SQL (the creation and manipulation of data, queries designing.) Methods of preserving the integrity of the database (relations, assertions, domains, triggers). Managing access to data (users, roles, permissions). Concurrency problems (transactions, isolation levels). XML support.
Recommended literature: Database Design for Mere Mortals. Michael J. Hernandez
Database in Depth: Relational Theory for Practitioners. C.J. Date
Assessment methods: lectures: test exam (minimum passing score is 50% of total points)
practical: average mark received for all the assignments (each assignment must be evaluated positively)
Comment: GGI