SylabUZ

Generate PDF for this page

Databases 2 - course description

General information
Course name Databases 2
Course ID 11.3-WK-CSEEP-D2-S22
Faculty Faculty of Exact and Natural Sciences
Field of study computer science and econometrics
Education profile academic
Level of studies First-cycle studies leading to Bachelor's degree
Beginning semester winter term 2022/2023
Course information
Semester 4
ECTS credits to win 5
Available in specialities Information systems
Course type optional
Teaching language english
Author of syllabus
  • dr Anna Fiedorowicz
  • mgr Grzegorz Arkit
Classes forms
The class form Hours per semester (full-time) Hours per week (full-time) Hours per semester (part-time) Hours per week (part-time) Form of assignment
Lecture 30 2 - - Exam
Laboratory 30 2 - - Credit with grade

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

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 Ewa Synówka (last modification: 28-03-2024 07:43)