Faculty of Information Technology, BUT

Course details

Data Modelling and Database Design

DSI Acad. year 2004/2005 Winter semester 6 credits

Current academic year

Fundamentals of database systems (DBS). Relational database design from a conceptual model. SQL language. Fundamentals of the relational model. Normalization-based design of a relational database. Organization of data at an internal level. Data security and integrity. Introduction to query optimization. Transaction processing - database recovery, concurrency control. Introduction to DBS architectures: client/server, multi-tier architectures, distributed DBS. Introduction to postrelational DBS. Access to databases from WWW. Project - development of a database application in modern development and database environment.

Guarantor

Language of instruction

Czech

Completion

Credit+Examination (written)

Time span

39 hrs lectures, 6 hrs pc labs, 20 hrs projects

Assessment points

50 exam, 15 half-term test, 35 projects

Department

Lecturer

Instructor

Bartík Vladimír, Ing., Ph.D. (DIFS FIT BUT)
Heckel Martin, Ing. (DIFS FIT BUT)
Ráb Jaroslav, Ing. (DIFS FIT BUT)

Subject specific learning outcomes and competences

Students are able to develop conceptual models of an application domain for database applications and have knowledge of relational database management system fundamentals.

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.

Study literature

  • Ramakrishnan, R.: Database Management Systems. WCB/McGraw-Hill, 1998, 741 p.
  • Date, C.J.: An Introduction to Database Systems. Sixth edition. Addison-Wesley, 1995, 839 p.

Fundamental literature

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

Syllabus of lectures

  • Fundamental concepts of database systems. Introduction to products used for projectsin a laboratory (Oracle and Centura at present).
  • Conceptual modelling. Transformation of an ER diagram and a class diagram a relational database schema.
  • SQL language, data definition. SELECT statement (fundamentals).
  • SQL language: SELECT statement (extension), other statements for data manipulation. System catalogue.
  • SQL language: embedded SQL, cursor, dynamic SQL. Query by example (QBE).
  • The relational model: data structure, data integrity in the relational model, relational algebra, relational calculus.
  • Schema normalization: introduction to dependency theory, normal forms.
  • Data organization at the internal level, indexing, B+ tree, hashing.
  • Data security and integrity. Using declarative integrity constraints, stored procedures and triggers. Query optimization.
  • Transaction processing. Failure recovery.
  • Concurrency control - serialization, locking, timestamping, isolation levels of transactions. Transaction processing in SQL.
  • Client/server and multi-tier architectures. Introduction to distributed database systems: problems, data fragmentation and replication, distributed transaction processing.
  • Current trends in database technology: postrelational database systems (mainly object-oriented and object-relational), access to databases from WWW.

Syllabus of computer exercises

  • Demonstration of a database application development in database and development environments of Oracle and Gupta products.
  • Creating an Oracle and SQL Base database.
  • Screen form development in Oracle Developer a SQL Windows.
  • Screen form development in Oracle Developer a SQL Windows.
  • Report development in Oracle Developer a SQL Windows
  • Stored procedures and database triggers in Oracle and SQL Base.

Syllabus - others, projects and individual work of students

  • Presentation of a conceptual model (a class diagram and a use case diagram) from Software engineering modified with respect to the extent of realization.
  • Realization of the database application in one of the two development and databaze environments.

Progress assessment

Written mid-term exam, presentation of the first project and defence of the second one in due dates.

Controlled instruction

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

Exam prerequisites

Duty credit consists of mid-term exam passing, presentation of the first project and defence of the second one in due dates, and of obtaining at least 25 points for activities during semester (a mid-term exam, a project).

Course inclusion in study plans

  • Programme EI-BC-3, field VTB, 3rd year of study, Compulsory
  • Programme EI-MSC-3, field VTN, 1st year of study, Compulsory
  • Programme EI-MSC-5, field VTI, 3rd year of study, Compulsory
Back to top