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 - Project 1

Generate PDF for this page

Database Systems - Project 1 - course description

Aim of the course

Students design a relational database modelling and create applications for its use.

Prerequisites

Save changes

Database Systems 1. Programming skills.

Scope

Students create a system on a selected topic. Students implement and document the process of creating an information system. The final effect will be a working system, working in a client-server architecture, and documentation.
During the course, students shall analyze the present area, do conceptual data model, SQL script, creating database structure, if it is necessary then create a description of the system using the selected UML diagrams (class, use case, state, activity, implementation), create an application to operate on this database.
Projects are done individually or in groups.

Teaching methods

Practical.

Learning outcomes and methods of theirs verification

Outcome description	Outcome symbols	Methods of verification	The class form

Assignment conditions

Total score: 40% for the project database, 40% of the created program, 20% of the documentation.

Recommended reading

1. D. Maier, The theory of relational databases, Computer Science Press, 1983.
2. M. Wybrańczyk, Delphi 7 i bazy danych, Helion, 2003.
3. M. Marzec, JBuilder i bazy danych, Helion, 2005.
4. G.Reese, Java. Aplikacje bazodanowe. Najlepsze rozwiązania, Helion, 2003.
5. Mościcki, I. Kruk, Oracle 10g i Delphi. Programowanie baz danych, Helion, 2006.

Further reading

1. P. Neil Gawroński, InterBase dla ,,delfinów'', Helion, 2001.
2. Jakubowski: SQL w InterBase dla Windows i Linuksa, Helion, Gliwice 2001.
3. R. Barker, CASE* Method. Modelowanie związków encji, WNT, Warszawa 2005

Notes

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