Practicum in Databases Course code: I62041T | 3 ECTS credits

Basic information

Level of Studies: Undergraduate applied studies

Year of Study: 3

Semester: 5

Requirements:

Goal: Determining the level of knowledge acquired in the field of databases on the example of an Oracle database project.

Outcome: The student will be able to apply knowledge of databases on a specific example of an Oracle database and application design.

Contents of the course

Theoretical instruction:

Creation of a project proposal for a database design in the form of a document with user requirements that represent a part of a real database of a business. Based on the requirements, creation of a connection entity model as well as a conceptual model.
Development of a web application in the APEX environment and SQL queries that provide useful information relevant to business.

Practical instruction (Problem solving sessions/Lab work/Practical training):

Oracle Academy iLearning : Database design and programming with SQL course curriculum, Oracle 2013.

Textbooks and References

Number of active classes (weekly)

Lectures: 0

Practical classes: 3

Other types of classes: 0

Grading (maximum number of points: 100)

Pre-exam obligations

Points

activities during lectures

activities on practial excersises

seminary work

colloquium

Final exam

Points

Written exam

Oral exam