1. SylabUZ
2. Faculty of Exact and Natural Sciences
3. winter term 2022/2023
4. computer science and econometrics - First-cycle studies leading to Bachelor's degree
5. Databases 2

Generate PDF for this page

Databases 2 - course description

Aim of the course

To acquaint the student with a selected relational database management system, e.g. the ORACLE database; getting the knowledge about the procedural extension of the SQL language (e.g. PL/SQL language) so that the student can design and create a dynamic website which is using the database.

Prerequisites

Save changes

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

Scope

Lecture

1. SQL in a relational database. Built-in functions, tree structures.
2. Procedural extension of the SQL language:
   • program structure, variables, types, expressions and operators, control statements,
   • use of records and tables,
   • using SQL from the subroutine level,
   • available SQL functions,
   • creating and using of cursors,
   • blocks: subroutines (procedures and functions), packages and triggers,
   • error handling.
3. PHP:
   • operations on texts and numbers,
   • creating interactive forms,
   • using of databases,
   • session mechanisms, cookies,
   • classes and objects,
   • file operations.
4. Object-oriented databases based on XML:
   • XML document structure,
   • DTD and XML-Schema,
   • XSLT.

Laboratory

1. SQL in a relational database.
2. Built-in functions.
3. Tree structures.
4. Procedural extension of the SQL language; creating your own built-in functions, procedures, triggers and packages.
5. Views describing the database structure.
6. Generating data in XML format and presenting them using XSL.

Teaching methods

Lecture: seminar lecture.

Laboratory: laboratory exercises in the computer lab.

Learning outcomes and methods of theirs verification

Outcome description	Outcome symbols	Methods of verification	The class form

Assignment conditions

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 a positive grade from the laboratory.

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 and laboratory. The condition for obtaining a positive final grade is obtaining positive grades from the lecture and the laboratory.

Recommended reading

1. M. Kay, XSL Transformations (XSLT) Version 2.0, https://www.w3.org/TR/xslt20.
2. L. Quin, Extensible Markup Language (XML), http://www.w3.org/XML.
3. T. Converse, J. Park, C. Morgan, PHP5 and MySQL Bible, Wiley, 2004.
4. S. Urman, R. Hardman, M. McLaughlin, Oracle Database 10g PL/SQL Programming, Oracle Press, 2004.
5. J. Clark, XSL Transformations (XSLT), http://www.w3.org/TR/xslt7.

Further reading

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.
3. D. Maier, The Theory of Relational Databases, Computer Science Press, 1983.
4. E. Balanescu, C. Darie, Beginning PHP and MySQL E-Commerce, 2nd Edition, Apress, 2008.

Notes

Modified by dr Anna Fiedorowicz (last modification: 06-02-2024 19:40)