UNIVERSITY OF LODZ - Central Authentication System
Main page

Foundations of Databases

General data

Course ID: 1100-PB0OII
Erasmus code / ISCED: (unknown) / (unknown)
Course title: Foundations of Databases
Name in Polish: Podstawy baz danych
Organizational unit: Faculty of Mathematics and Computer Science
Course groups: (in Polish) I stopień Informatyka (rozpoczęta w r. 2007) - semestr 1 - 3
ECTS credit allocation (and other scores): (not available) Basic information on ECTS credits allocation principles:
  • the annual hourly workload of the student’s work required to achieve the expected learning outcomes for a given stage is 1500-1800h, corresponding to 60 ECTS;
  • the student’s weekly hourly workload is 45 h;
  • 1 ECTS point corresponds to 25-30 hours of student work needed to achieve the assumed learning outcomes;
  • weekly student workload necessary to achieve the assumed learning outcomes allows to obtain 1.5 ECTS;
  • work required to pass the course, which has been assigned 3 ECTS, constitutes 10% of the semester student load.

view allocation of credits
Language: Polish
(in Polish) Forma zaliczenia:

(in Polish) egzamin

(in Polish) Forma studiów:

(in Polish) stacjonarne

Prerequisits:

computer basics

basic and working knowledge about operational systems

basic and working knowledge about web browsers


Short description:

The aim of the course is to acquaint the student with the fundamentals of databases. The greater part of the course is devoted to the relational database model which is a dominant database model on the field of software. During the classes in the laboratory students get the practical knowledge and gain the skills which enable them to design and to create correct schemas of relational databases. Further, the students create and use various queries in Oracle SQL language to modify data stored in Oracle databases.

Learning outcomes:

Student:

E1. Knows theoretical fundamentals of databases

E2. Knows fundamentals relational model of databases

E3. Creates schemas of relational databases; is able to design and to analyse Entity-Relationship ER diagrams

E4. Creates a database in the selected DBMS which is built on base of the ER-diagram

E5. Creates and knows selected objects of Oracle relational databases such ast tables, views, constraints, indexes, sequences

E6. Uses Oracle SQL dialect as a tool in modifying data stored in Oracle databases

E7. Sees at least some of wider possibilities of using SQL language to modify data stored in Oracle databases applications

This course is not currently offered.
Course descriptions are protected by copyright.
Copyright by UNIVERSITY OF LODZ.
contact accessibility statement USOSweb 7.0.3.0-0