Uniwersytet Łódzki - Centralny System UwierzytelnianiaNie jesteś zalogowany | zaloguj się
katalog przedmiotów - pomoc

Introduction to Databases

Informacje ogólne

Kod przedmiotu: 0800-TIDZAN Kod Erasmus / ISCED: (brak danych) / (brak danych)
Nazwa przedmiotu: Introduction to Databases
Jednostka: Wydział Zarządzania
Grupy:
Punkty ECTS i inne: 0 LUB 5.00 (w zależności od programu)
zobacz reguły punktacji
Język prowadzenia: angielski
Efekty kształcenia:

(tylko po angielsku) Knowledge:

1. defines and discusses the main notions of relational algebra and the relational data model 08T-1P_W06

2. Has knowledge of methods and tools used to store and organize data 08T-1P_W06

3. Is familiar with basic database systems and applications used in the field of logistics processes support 08T-1P_W09

Skills:

1. Is able to use in practice a design theory for relational databases (especially to create the Entity-Relationship Diagrams and to built database for the given Entity-Relationship Diagram) 08T-1P_U12

2. Is able to use SQL, stored procedures and functions, views and indexes, constraints and triggers. 08T-1P_U10

3. Has the ability of using SQL in a server environment 08T-1P_U10

4. Is able to use a database connection in Java and PHP 08T-1P_U13

Attitudes:

1. Understands the need for continuous long-life learning and knowledge strengthening. Especially is aware of technology trends in the area of database systems 08T-1P_K01





Forma studiów:

stacjonarne

Wymagania wstępne:

(tylko po angielsku) None.

Skrócony opis: (tylko po angielsku)

The course introduces the students to the theory of databases, focusing on the main concepts and definitions of this technology. The course is also devoted to database design, analysis, relational model of data and SQL language.

Zajęcia w cyklu "Semestr zimowy 2014/2015" (zakończony)

Okres: 2014-10-01 - 2015-02-15
Wybrany podział planu:


powiększ
zobacz plan zajęć
Typ zajęć: Laboratorium, 24 godzin więcej informacji
Wykład, 24 godzin więcej informacji
Koordynatorzy: Marek Majewski, Andrzej Skowron
Prowadzący grup: Marek Majewski, Andrzej Skowron
Lista studentów: (nie masz dostępu)
Zaliczenie: Ocena zgodna z regulaminem studiów
Czy ECTS?:

T

Czy IRK BWZ?:

T

Metody dydaktyczne:

(tylko po angielsku) The teaching methods applied to the course include lecture, discussion, solving exercises and problems , presentations, working in groups.

Sposoby i kryteria oceniania:

(tylko po angielsku) Final evaluation of the course (the coordination evaluation) = 33% the lecture’s evaluation; 67% computer laboratory’s evaluation

The assessment of the computer lab consists of two parts :

• attendance - 20 points (more then 3 non-attendance means no points)

• the presentation of solutions of 3 projects in 2 members team – 12 points for each project

The grades of the computer lab are awarded in accordance with the following scale:

• 50 – 56 = 5;

• 45 – 49 = 4+;

• 40 – 44 = 4;

• 35 – 39 = 3+;

• 30 – 34 = 3;

• 0 – 29 = 2.

The positive mark of the computer lab is the necessary condition to take a part in the test (which forms the basis of assessment of the lecture).

The grades of the test are accordance with the following scale:

• 36 – 40 = 5;

• 32 – 35 = 4+;

• 28 – 31 = 4;

• 21 – 27 = 3+;

• 19 – 20 = 3;

• 0 – 19 = 2.

The final grade is an average of the partial grades.


Treści kształcenia:

(tylko po angielsku) Lecture:

Introduction do database systems 2

The foundation of relational algebra and the relational data model 4

The conceptual data model 2

Design theory for relational databases 4

Introduction to SQL, stored procedures and functions 4

Relational database programming 4

Query languages for XML 4

Security and user authorization in SQL 2

Technology trends and databases 2

Computer Laboratory:

Introduction to SQL 2

SQL functions 2

Table joins 3

Subqueries 2

Database modifications (insertion, deletion, updates) 3

Transactions in SQL 2

Constraints and triggers 2

Views and indexes 2

SQL in a server environment 2

Stored procedures 2

User authorization in SQL 2

Database connection in Java and PHP 4


Literatura: (tylko po angielsku)

• Date, C. J. An Introduction To Database Systems. Pearson Education, 2006.

• Ullman, Jeffrey D., Jennifer Widom. A First Course in Database Systems. Prentice Hall, 2007.

• Garcia-Molina, Hector, Jeffrey D. Ullman, Jennifer Widom. Database Systems: The Complete Book. Prentice Hall, 2008.

• Stephens, Rod. Beginning Database Design Solutions. Wrox, 2008.

• Neeraj Sharma, Liviu Perniu, Raul F. Chong, Abhishek Iyer, Adi-Cristina Mitea, Chaitali Nandan, Mallarswami Nonvinkere, Mirela Danubianu. Database fundamentals (free ebook).

• Hugh Darwen. An Introduction to Relational Database Theory (free ebook).

Opisy przedmiotów w USOS i USOSweb są chronione prawem autorskim.
Właścicielem praw autorskich jest Uniwersytet Łódzki.