IDS Acad. year 2020/2021 Summer semester 5 credits
Language of instruction
Subject specific learning outcomes and competences
- Student is able to develop conceptual models of an application domain for database applications.
- He/she can develop database applications for relational databases, knows the standard database language for relational databases SQL, and has experience with some integrated development environment for database applications. and have knowledge of relational database management system fundamentals.
- He/she receives basic competencies for database administrator's work like user account creation, access rights assignment and performance tuning.
- Student acquaints with fundamentals of some important functions of advanced database system like transactional processing, concurrency and recovery.
- Student acquaints with basic English terminology in the subject.
Generic learning outcomes and competences
Why is the course taught
Prerequisite kwnowledge and skills
- Lemahieu, W., Broucke, S., Baesens, B.: Principles of Database Management. Cambridge University Press. 2018, 780 p.
- Zendulka, J.: Databázové systémy. Přednášky v elektronické podobě. (in Czech).
- Zendulka, J., Rudolfová, I.: Databázové systémy. IDS. Studijní opora. FIT VUT v Brně. 2006, 217 s. (in Czech).
- Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.
- On-line help of Oracle products, Oracle documentation available at http://www.oracle.com/pls/db112/homepage.
Syllabus of lectures
- Fundamental concepts of database systems.
- Conceptual modelling.
- Fundamentals of the relational model. Transformation of a conceptual model to a relational database schema.
Introduction to database application development in Oracle products environment.
- The SQL - data definition.
- The SQL - SELECT statement (fundamentals).
- The SQL - SELECT statement (extension).
- The SQL - other statements for data manipulation. System catalogue.
Introduction to PL/SQL.
- The SQL - views, missing information, embedded SQL, cursor, dynamic SQL. Query by example (QBE).
Fundamentals of application development in Oracle Form Builder.
- The client/server architecture. Database triggers and stored procedures. Data integrity, data security.
- Data organization at the internal level - indexing and hashing. Query processing and optimization.
Report development in Oracle Report Builder.
- Introduction to normal forms, the use of normalization in database design.
- Transaction processing - properties and states of a database transaction. Introduction to failure recovery and concurrency control.
- Current trends in database technology.
Syllabus - others, projects and individual work of students
- Presentation of a conceptual model (ERD or a class diagram) and a use case model for a given problem (continuation of the project started in the subject Introduction to software engineering).
- An SQL script that creates and populates database tables.
- An SQL script with queries over the database tables.
- An SQL script with statements for advanced database objects and project documentation.
- Data and use case models - 5 points
- Building of the database in SQL - 5 points
- Querying in SQL - 5 points
- Advanced database objects and documentation - 19 points
- Midterm written exam - 15 points
- Final written examination - 51 points
- To be allowed to sit for written examination student is to present and defend project oucomes in due dates, and to earn at least 24 points during the semester.
- The minimum number of points for the final examination is 20.
Course inclusion in study plans