University of Bialystok - Central Authentication SystemYou are not logged in | log in
course directory - help

Databases

General data

Course ID: 0600-IS1-2BD#a Erasmus code / ISCED: 11.302 / (0612) Database and network design and administration
Course title: Databases Name in Polish: Databases
Department: (in Polish) Instytut Informatyki
Course groups: (in Polish) 2 rok 1 stopnia sem. zimowy Informatyka
(in Polish) 3L stac. I st. studia informatyki - przedmioty obowiązkowe
ECTS credit allocation (and other scores): 5.00
view allocation of credits
Language: English
Type of course:

obligatory courses

Prerequisites:

Computer Systems Architecture 0600-IS1-1ASK
Introduction to Object-Oriented Programming 0600-IS1-1WPO#a
Introduction to Structured Programming 0600-IS1-1PPS#a
Linear Algebra with Analytic Geometry 0600-IS1-1ALG

Prerequisites (description):

Presentation of basic issues and terminology in the field of databases and relational model.

Getting to know the methods of database design. Preparing a relational database schema

based on selected models. Formulating queries in SQL. Gaining knowledge about the

optimization of databases. Presentation of the concept of transactions and concurrency

Short description:

Assumptions and objectives of the Course: Presentation of basic issues and terminology in the field of databases and relational model.

Getting to know the methods of database design. Preparing a relational database schema

based on selected models. Formulating queries in SQL. Gaining knowledge about the

optimization of databases. Presentation of the concept of transactions and concurrency

Full description:

Course profile: General Academic

Form of study: Full-time studies

Course type: Obligatory

Year/semester of study: 2 / 3

Prerequisites (sequential system of courses and exams): Items introducing: Linear Algebra with Analytic Geometry, Introduction to Structural Programming, Computer System Architecture, Introduction to Object-Oriented Programming,

Lecture: 30 Laboratory classes: 30

Teaching methods: Lectures, laboratory classes

ECTS credits: 5

Balance of student workload:

Class attendance:

- lecture 30h

- laboratory classes 30h

Course preparation:

- lecture 15h

- laboratory classes 15h

Literature study: 5h

Reports, homeworks: 10h

Preparation for tests: 10h

Preparation for the exam: 15h

Exam duration: 2h

Individual consultation with the teacher: 3h

Student workload:

Direct interaction with the teacher: 65, 2 ECTS

Practical exercises: 45, 2 ECTS

Learning outcomes:

Learning outcomes:

The student knows the properties and definitions of the relational model. K_W05

The student understands database design. K_W05

The student knows methods of searching and presentation of information from databases. K_W05

The student knows definition and properties of transactions. K_W05

The student can model a database. K_U11

The student can search for and present the requested information from databases. K_U11

The student can modify the structure and content of databases. K_U11

The student creatively solves posed problems. K_K05

Assessment methods and assessment criteria:

exam

Classes in period "Academic year 2018/2019" (in progress)

Time span: 2018-10-01 - 2019-06-30
Choosen plan division:


magnify
see course schedule
Type of class: Laboratory, 30 hours more information
Lecture, 30 hours more information
Coordinators: (unknown)
Group instructors: (unknown)
Students list: (inaccessible to you)
Examination: Examination
Course descriptions are protected by copyright.
Copyright by University of Bialystok.