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 1

Generate PDF for this page

Databases 1 - course description

Aim of the course

To acquaint the student with the terminology related to databases. Gaining by the student the knowledge and skills in the design and use of databases. Getting to know the applications of the SQL language.

Prerequisites

Save changes

Fundamentals of logic. Programming skills.

Scope

Lecture

• Basic concepts of the relational data model.
• Operations on relations (union, intersection, difference and complement; projection, selection and join, division).
• Functional dependencies and Armstrong axioms.
• Relational schemas.
• Decomposition of relational schemas (without data loss, without loss of functional relationships and into independent components).
• The normalization process of relational schemas (First Normal Form, Second Normal Form, Third Normal Form, Boyce–Codd Normal Form, 4NF, 5NF).
• Multivalued dependencies.
• The set of axioms for multivalued dependencies.
• Optimization of the sets of functional dependencies.
• SQL language:
  • Data Definition Language - DDL.
  • Data Manipulation Language - DML.
  • Data Control language - DCL.
• Database design (diagrams: DFD, ERD, generating the database schema).

Laboratory

• Applications of the SQL language.
• Data types, expressions and operators, conditions, functions, procedures.
• SELECT statement: inner and outer join, simple and correlated subqueries, grouping and aggregate functions, set operators UNION, MINUS, INTERSECT.
• Defining database structures: domains, tables, views, indexes, sequences / generators, triggers, integrity constraints.
• Database user management and transaction control.
• The use of selected computer CASE tools to generate a simple database schema.

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: an 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 classes.

Laboratory: the grade consists of points from four tests writen in the semester or from points from a test covering the entire material (80% of the grade) and students' activity during classes (20% of the grade).

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

Recommended reading

1. D. Maier, The Theory of Relational Databases, Computer Science Press, 1983.
2. C.J. Date: An Introduction to Database Systems, Addison-Wesley Longman, 2000.
3. C.J. Date, H. Darwen: A Guide to SQL Standard, 4th Edition, Addison-Wesley Professional, 1996.
4. C.J. Date: SQL and Relational Theory. How to Write Accurate SQL Code, O’Reilly, 2009.
5. R. Colburn: Special Edition Using SQL, Que, 2000.
6. J.D. Ullman, J. Widom: A First Course in Database Systems, 3rd Edition, Pearson, 2007.
7. D. Russell J.T., Learning MySQL and MariaDB, O'Reilly Media, 2015.
8. https://www.w3schools.com/
9. www.tutorialspoint.com

Further reading

1. R. Barker, Case*Method: Entity Relationship Modelling, First Edition, Addison-Wesley, 1990.
2. P. Dubois, MySQL (Developer's Library), 5th Edition, Addison-Wesley Professional, 2013.
3. L. Welling, L. Thomson, MySQL Tutorial, Sams Publishing, 2003.
4. W. Kim, Introduction to Object-Oriented Databases, MIT Press, 2008.

 

.

Notes

Modified by dr Anna Fiedorowicz (last modification: 30-01-2024 14:28)