1. SylabUZ
2. Wydział Matematyki, Informatyki i Ekonometrii
3. semestr zimowy 2022/2023
4. Mathematics - pierwszego stopnia z tyt. licencjata
5. Database Systems 2

Wygeneruj PDF dla tej strony

Database Systems 2 - opis przedmiotu

Cel przedmiotu

To acquaint the student with the ORACLE database and the PL/SQL language so that the student can design and create a dynamic website which is using the database.

Wymagania wstępne

Zapisz zmiany

Programming skills. Knowledge of the basics of relational databases, SQL and HTML.

Zakres tematyczny

Wykład

1. PL/SQL: program structure, variables, types, expressions and operators, control statements, use of records and tables, using SQL from the PL/SQL level, SQL functions available in PL/SQL, creating and using cursors, blocks in PL/SQL: subroutines (procedures and functions), packages and triggers, error handling in PL/SQL, dynamic PL/SQL.
2. Acyclic databases.
3. Derivation of functional dependencies: with Armstrong axioms, with B-axioms, using digraphs.

Ćwiczenia

1. SQL in an Oracle database. Built-in functions, tree structures.
2. PL/SQL. Cursors, parametrized cursors. Blocks, functions, procedures, triggers. Packages. Error handling .
3. PHP:
   operations on texts and numbers,
   creating interactive forms,
   using of databases,
   session mechanisms, cookies, files,
   classes and objects,
   file operations.
4. Object-oriented databases based on XML:
   XML document structure,
   DTD and XML-Schema,
   XSLT.

Laboratorium

1. SQL in an Oracle database.
2. Tree structures.
3. PL/SQL, creating your own built-in functions, procedures, triggers and packages.
4. Views describing the database structure.
5. Generating data in XML format and presenting them using XSL.

Metody kształcenia

Lecture: seminar lecture.

Exercise classes: problem method; brainstorm; presenting reports.

Laboratory: laboratory exercises in the computer lab.

Efekty uczenia się i metody weryfikacji osiągania efektów uczenia się

Opis efektu	Symbole efektów	Metody weryfikacji	Forma zajęć

Warunki zaliczenia

Lecture: exam consisting of two parts: written and oral, the condition for the oral part is to obtain at least 30% of points in the written part, obtaining 50% of points in the written part guarantees a positive mark, without the need to take the oral part. The condition for taking the exam is obtaining positive grades from classes.

Classes: to get the positive grade one needs to obtain more than 50% of the points from the test covering the entire processed material, one can get a maximum of 20% additional points for preparing a report.

Laboratory: to get the positive grade one needs to obtain more than 50% of the points from the test covering the entire processed material (which constitutes 80% of the mark). The student receives additional points for active participation in classes (20% of the grade).

The final grade for the course is the arithmetic mean of grades from the lecture, classes and laboratory. The condition for obtaining a positive final grade is obtaining positive grades from the lecture, classes and the laboratory.

Literatura podstawowa

1. E. Balanescu, C. Darie, Beginning PHP and MySQL E-Commerce, 2nd Edition, Apress, 2008.
2. J. Clark, XSL Transformations (XSLT), http://www.w3.org/TR/xslt7.
3. L. Quin, Extensible Markup Language (XML), http://www.w3.org/XML.
4. T. Converse, J. Park, C. Morgan, PHP5 and MySQL Bible, Wiley, 2004.
5. S. Urman, R. Hardman, M. McLaughlin, Oracle Database 10g PL/SQL Programming, Oracle Press, 2004.
6. D. Maier, The Theory of Relational Databases, Computer Science Press, 1983.

Literatura uzupełniająca

1. E. Naramore, J. Gerner, Y. Le Scouarnec, J. Stolz, M.K. Glass, Beginning PHP5, Apache, and MySQL Web Development, Wiley, 2005.
2. W. Kim, Introduction to Object-Oriented Databases,  M.I.T. Press, 2008.

Uwagi

Zmodyfikowane przez dr Anna Fiedorowicz (ostatnia modyfikacja: 18-01-2024 14:48)