Database Systems

Language of Instruction:Czech
Private info:http://www.fit.vutbr.cz/study/courses/IDS/private/
Completion:credit+exam (written)
Type of
Guarantor:Zendulka Jaroslav, doc. Ing., CSc. (DIFS)
Deputy guarantor:Bartík Vladimír, Ing., Ph.D. (DIFS)
Lecturer:Bartík Vladimír, Ing., Ph.D. (DIFS)
Rychlý Marek, RNDr., Ph.D. (DIFS)
Zendulka Jaroslav, doc. Ing., CSc. (DIFS)
Instructor:Bartík Vladimír, Ing., Ph.D. (DIFS)
Rychlý Marek, RNDr., Ph.D. (DIFS)
Faculty:Faculty of Information Technology BUT
Department:Department of Information Systems FIT BUT
Introduction to Software Engineering (IUS), DITS
Information Systems (IIS), DIFS
Substitute for:
Data Modelling and Database Design (DSI), DCSY
Monobhajoby konceptuálních modelů2019-03-04C228 08:0010:50
Monobhajoby projektů2019-05-06N203 08:0009:50
Monexam - 1. oprava2019-05-27D0206 D0207 D105 09:0011:502BIA 2BIB 3BIT
Monexam - IDS - zkouška2019-05-27E112 09:0011:502BIA 2BIB
Monobhajoby konceptuálních modelů2019-03-11C228 09:0015:50
Monobhajoby projektů2019-05-06N203 10:0015:50
Monobhajoby konceptuálních modelů2019-03-04C228 13:0014:50
Monobhajoby projektů2019-04-29N103 13:0014:50
Tueobhajoby projektů2019-05-07N203 10:0015:50
Tueobhajoby projektů2019-04-30N204 13:0013:50
TueProhlídka opravených písemek2019-06-04C228 13:0014:502BIA 2BIB
TueProhlídka opravených písemek2019-04-16C228 14:0014:502BIA 2BIB
WedProhlídka opravených písemek2019-05-22C228 13:0014:502BIA
Thuexam - půlsemestrální zkouška2019-04-04D105 E112 07:0007:502BIA 2BIB 3BIT
Thuexam - 2. oprava2019-06-06D105 09:0011:502BIA 2BIB 3BIT
Thuexam - IDS - zkouška2019-06-06E112 09:0011:502BIA 2BIB
Thuobhajoby projektů2019-05-02N204 12:0013:50
Thuobhajoby konceptuálních modelů2019-03-07C228 13:0014:50
Friexam - řádná2019-05-10A112 D0206 D0207 D105 E104 E105 E112 08:0010:502BIA 2BIB 3BIT
Friobhajoby konceptuálních modelů2019-03-08C228 09:0010:50
Friobhajoby konceptuálních modelů2019-03-15C228 09:0014:50
FriObhajoby projektů2019-05-03N203 12:0015:50
Learning objectives:
  Mastering fundamentals of relational database theory and skill in using database technology at a level required for database design, development of database applications and database administration.
  Fundamentals of database systems (DBS). Conceptual modeling. The relational model. Relational database design from a conceptual model. Normalization-based design of a relational database. SQL language. Transaction processing. DBS architectures: client/server, multi-tier architectures, distributed DBS. Introduction to database administration: data security and integrity, introduction to physical database design, performance optimization, database recovery, concurrency control. Trends in database technology. The project consists in designing the structure of a relational database and programming SQL scripts to create the database, querying data in it, database triggers, and stored procedures.
Knowledge and skills required for the course:
  The sets, relations and mappings. The elementary notions of the graph theory. Basics of hashing and tree-based search. Basic steps of software development. Rudiments of programming and data modeling.
Subject specific learning outcomes and competencies:
  • 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 competencies:
  Student will learn how to analyze a given problem in a small team and he/she will learn to design and implement solution of the problem individually. He/she learns to present and defend  both partial and final results of the project.
Why is the course taught:
  Since the 1960s, when data intensive applications and systems have been developed and used, typically information systems and their parts, database systems have been used to store data. Database technologies have evolved rapidly and are widely used today. It is therefore necessary for students to acquire competences and skills in this field. This subject is focused on the basics of database technologies, namely relational databases that play a key role here.
Syllabus of lectures:
  1. Fundamental concepts of database systems.
  2. Conceptual modeling.
  3. Fundamentals of the relational model. Transformation of a conceptual model to a relational database schema.
    Introduction to database application development in Oracle products environment.
  4. The SQL - data definition.
  5. The SQL - SELECT statement (fundamentals).
  6. The SQL - SELECT statement (extension).
  7. The SQL - other statements for data manipulation. System catalogue.
    Introduction to PL/SQL.
  8. The SQL - views, missing information, embedded SQL, cursor, dynamic SQL. Query by example (QBE).
    Fundamentals of application development in Oracle Form Builder.
  9. The client/server architecture. Database triggers and stored procedures. Data integrity, data security.
  10. Data organization at the internal level - indexing and hashing. Query processing and optimization.
    Report development in Oracle Report Builder. 
  11. Introduction to normal forms, the use of normalization in database design.
  12. Transaction processing - properties and states of  a database transaction. Introduction to failure recovery and concurrency control.
  13. Current trends in database technology.
Syllabus - others, projects and individual work of students:
  1. 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).
  2. An SQL script that creates and populates database tables.
  3. An SQL script with queries over the database tables.
  4. An SQL script with statements for advanced database objects and project documentation.
Fundamental literature:
  • 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.
Study literature:
  • Lemahieu, W., Broucke, S., Baesens, B.: Principles of Database Management. Cambridge University Press. 2018, 780 p.
Controlled instruction:
  Mid-term exam passing, realization and presentation/defence of projects in due dates. In the case of a reported barrier of mid-term exam and to present/defend a project, a student will be offered a substitute date of the exam or an oral exam, and she/he will be allowed to present/defend the project in a substitute date, respectively.
Progress assessment:
  • 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 semester.
  • The minimum number of points for the final examination is 20.
Exam prerequisites:
  To be allowed to sit for written examination student is present and defend project outcomes, and to earn at least 24 points during semester.

Your IPv4 address: