1. SylabUZ
2. Faculty of Mathematics, Computer Science and Econometrics
3. winter term 2019/2020
4. Mathematics - First-cycle studies leading to Bachelor's degree
5. Database Systems 2

Generate PDF for this page

Database Systems 2 - course description

Aim of the course

Familiarize students with the ORACLE database and PL/SQL. At the end of the course students should be able to independently design and develop dynamic website using database.

Prerequisites

Save changes

Programming skills. Basic knowledge of relational databases and SQL, and HTML.

Scope

Lecture:
1. PL/SQL

• Structure of programme, variables, data types, expressions, comparisons and control structures.
• Using collections and records.
• Performing SQL operations from PL/SQL.
• Procedures, functions, packages in PL/SQL.
• Handling PL/SQL errors.
• Dynamic PL/SQL.

2. Acyclic database.
3. Deriving functional dependencies using:

• Armstrong’s axioms.
• B-axioms
• directed acyclic graphs.

Class:
1. PHP

• Operations on text and numbers.
• Creating interactive forms.
• Communication with databases.
• Sessions and cookies.
• File operations.

2. Object-oriented databases and XML

• Structure of the XML document.
• DTD and XML-Schema.
• XSLT.

JavaScript

• Syntax,
• Classes, objects, JSON format,
• AJAX and XML support,
• Examples of frameworks.

Laboratory:
1. SQL in Oracle.
2. Tree structures in Oracle databases.
3. PL/SQL, create stored procedures, functions, triggers, and packages.
4. Views describes schema objects in the database.
5. Transforming XML data with XSLT and JavaScript.

Teaching methods

Lecture: Seminar lecture.
Class: Method problematic, brainstorming, presentations.
Laboratory: Computer laboratory exercises.

Learning outcomes and methods of theirs verification

Outcome description	Outcome symbols	Methods of verification	The class form

Assignment conditions

Lecture: The exam consists of two parts, written and oral, access to the oral part is getting 30% of the points of the written part, 50% of the points from the written part guarantees a positive evaluation.
Class: condition pass is 50% of test covering all the material processed.
Laboratory: condition pass is 50% of the points of the four planned tests or final test covering all the material processed, for the preparation of the talk, you can get up to an additional 20%..
Final evaluation of the course is the arithmetic mean of the lecture, class and laboratory. However, a prerequisite for a positive final assessment is to obtain positive evaluations of the lecture, class and laboratory.

Recommended reading

1. D. Maier, The theory of relational databases, Computer Science Press, 1983.
2. E. Balanescu, M. Bucica, Cristian Darie, PHP 5 i MySQL. Zastosowania e-commerce, Helion, 2005.
3. J. Clark, XSL Transformations (XSLT), http://www.w3.org/TR/xslt7.
4. L. Quin, Extensible Markup Language (XML), http://www.w3.org/xml.
5. T. Converse, J. Park, C. Morgan, PHP5 i MySQL. Biblia, Helion, 2005.
6. S. Urman, R. Hardman,

Further reading

1. E. Naramore, J. Gerner, Y. Le Scouarnec, J. Stolz, M.K. Glass, PHP5, Apache i MySQL. Od podstaw, Helion, 2005.
2. B. Basham, K. Sierra, B. Bates, Head First Servlets & JSP, Helion, 2005.
3. W. Kim, Wprowadzenie do obiektowych baz danych, WNT, Warszawa, 1996.

Notes

Modified by dr Robert Dylewski, prof. UZ (last modification: 20-09-2019 10:04)