SylabUZ

Generate PDF for this page

Databases Project 1 - course description

General information
Course name Databases Project 1
Course ID 11.3-WK-IiEP-BDP1-P-S14_pNadGenCHGZF
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 2019/2020
Course information
Semester 4
ECTS credits to win 3
Course type optional
Teaching language polish
Author of syllabus
  • dr inż. Agnieszka Lasota
  • dr Anna Fiedorowicz
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
Project 15 1 - - Credit with grade

Aim of the course

The student's designing a relational database modeling a certain fragment of reality and creating an application to handle it.

Prerequisites

Databases 1. Programming skills.

Scope

As part of the project, an IT system is created on a selected topic. Students independently implement and document the various stages of creating an IT system. The end result is to be a working system operating in the client-server architecture as well as analytical and design documentation.

As part of the course, students analyze the subject area, make a logical database design, scripts that create the database structure, or create a system description using selected UML diagrams (classes, use cases, state, activities, implementations), create the code of the appropriate application.

Projects are performed individually or in groups.

Teaching methods

Laboratory exercises; design method.

Learning outcomes and methods of theirs verification

Outcome description Outcome symbols Methods of verification The class form

Assignment conditions

The condition for obtaining a positive assessment is the submission of a complete project (database and application) and documentation within the time limit set by the teacher.

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

Recommended reading

 Client/Server Architectures for BusinessInformation Systems   https://www.hillside.net/plop/plop97/Proceedings/renzel.pdf

https://www.sqldatatool.com/

https://www.uml-diagrams.org/

https://www.lucidchart.com/pages/database-diagram/database-design#top

https://staruml.io/

D. Maier, The theory of relational databases, Computer Science Press, 1983

J. Clark, XSL Transformations (XSLT), http://www.w3.org/TR/xslt7

L. Quin, Extensible Markup Language (XML), http://www.w3.org/XML

https://www.oracle.com/index.html

https://www.w3schools.com/

Further reading

Notes


Modified by dr Alina Szelecka (last modification: 21-11-2020 06:10)