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)
|
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 |
Copyright by UNIVERSITY OF LODZ.