Faculty of Information Technology, BUT

Course details

Database Systems (in English)

IDSe Acad. year 2018/2019 Summer semester 5 credits

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. Development of a database application in modern development and database environment.

Guarantor

Deputy Guarantor

Language of instruction

English

Completion

Credit+Examination (written)

Time span

39 hrs lectures, 13 hrs projects

Assessment points

51 exam, 14 half-term test, 35 projects

Department

Lecturer

Instructor

News

  • This course is prepared for incoming Erasmus+ students only, and it is instructed in English.
  • This course will be open if a certain/sure minimum of enrolled students is at least five students.

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

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.

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.

Prerequisite kwnowledge and skills

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.

Study literature

  • Ramakrishnan R.: Database Management Systems. Third edition. McGraw-Hill Science/Engineering/Math, 2000, 1104 p.
  • Date C.J.: An Introduction to Database Systems. Seventh edition. Addison-Wesley, 2000, 838 p.

Fundamental literature

  • Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Fourth Edition. McGRAW-HILL. 2001, 1088 p.
  • On-line help and documentation of Oracle.

Syllabus of lectures

  1. Fundamental concepts of database systems.
  2. Conceptual modeling.
  3. Fundamentals of the relational model.
  4. Transformation of a conceptual model to a relational database schema.
  5. The SQL - data definition.
  6. The SQL - SELECT statement (fundamentals).
  7. The SQL - SELECT statement (extension).
  8. The SQL - other statements for data manipulation. System catalogue.
  9. The SQL - views, missing information, embedded SQL, cursor, dynamic SQL. Query by example (QBE).
  10. The client/server architecture. Database triggers and stored procedures. Data integrity, data security.
  11. Data organization at the internal level - indexing and hashing. Query processing and optimization.
  12. Transaction processing - properties and states of a database transaction.
  13. Introduction to failure recovery and concurrency control.

Syllabus of numerical exercises

  1. Demonstration of a database application development in an environment used for projects in a laboratory (Oracle currently).
  2. Creating an Oracle database.
  3. Screen form development in Oracle Developer.
  4. Report development in Oracle Developer.
  5. Stored procedures and database triggers in Oracle.

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.

Progress assessment

  • Data and use case models - 5 points
  • Building of the database in SQL - 9 points
  • Querying in SQL - 10 points
  • Advanced database objects and documentation - 10 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 outcomes in due dates, and to earn at least 24 points during semester.

Controlled instruction

Mid-term exam passing, realization and presentation/defence of projects in due dates.

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.

Schedule

DayTypeWeeksRoomStartEndLect.grpGroupsInfo
Tueexam2019-05-21 C228 10:0012:50 INTE xx exam (the 3rd term/2nd resit)
Tuelecture1., 3., 4., 5., 9., 10., 11., 12., 13. of lectures C228 11:0013:50 INTE xx lectures (selected weeks only)
Tuecomp.lab1., 2., 3., 4., 7., 8., 10., 11., 13. of lectures N205 12:0013:50 INTE xx self-training/project labs
Tuecomp.lab5., 6., 9., 12. of lectures N205 13:0013:50 INTE xx demo labs (selected weeks only)
Wedexam2019-05-15 C228 10:0012:50 INTE xx exam (the 2nd term/1st resit)
Wedlecture3., 5., 6., 9. of lectures C228 10:0012:50 INTE xx lectures (selected weeks only)
Friexam2019-05-10 C228 10:0012:50 INTE xx exam (the 1st term/regular)
Back to top