1. SylabUZ
2. Wydział Matematyki, Informatyki i Ekonometrii
3. semestr zimowy 2022/2023
4. Mathematics - pierwszego stopnia z tyt. licencjata
5. Database Systems - Project 1

Wygeneruj PDF dla tej strony

Database Systems - Project 1 - opis przedmiotu

Cel przedmiotu

The student designs a relational database modeling a certain fragment of reality and create an application to support it.

Wymagania wstępne

Zapisz zmiany

Database Systems 1. Programming skills.

Zakres tematyczny

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, in a client-server architecture, and project documentation.
During the course, students shall analyze the subject area, create the logical data model and scripts creating the database structure, and, 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.

Metody kształcenia

Laboratory exercises; design method.

Efekty uczenia się i metody weryfikacji osiągania efektów uczenia się

Opis efektu	Symbole efektów	Metody weryfikacji	Forma zajęć

Warunki zaliczenia

The condition for obtaining a positive grade is to submit a complete project (database and application) and documentation within the deadline set by the instructor.

Final grade: 40% for the database project, 40% for the created program, 20% for the documentation.

Literatura podstawowa

1. D. Maier, The Theory of Relational Databases, Computer Science Press, 1983.
2. G.Reese, Java Database Best Practices. Persistence Models and Techniques for Java Database Programming, O'Reilly Media, 2003.
3. S. Urman, R. Hardman, M. McLaughlin, Oracle Database 10g PL/SQL Programming, Oracle Press, 2004.
4. Y. Bai, Oracle Database Programming with Java, Ideas, Designs, and Implementations, CRC Press, 2023.
5. M. Matthews, J. Cole, J.D. Gradecki, MySQL and Java Developer's Guide, Wiley, 2003.
6. G. Reese, Database Programming with JDBC & Java, Second Edition, O'Reilly Media, 2000.
7. https://www.w3schools.com/
8. www.tutorialspoint.com

 

Literatura uzupełniająca

1. R. Barker, Case Method: Entity Relationship Modelling, Addison-Wesley, 1990.
2. K. Sierra, B. Bates, T. Gee,  Head First Java. 3rd Edition, O'Reilly Media, 2022.
3. D. Russell J.T., Learning MySQL and MariaDB, O'Reilly Media, 2015.

 

 

Uwagi

Zmodyfikowane przez dr Anna Fiedorowicz (ostatnia modyfikacja: 18-01-2024 14:12)