Course Details
Databases
Academic Year 2023/24
BEA014 course is part of 1 study plan
BPC-GK Summer Semester 2nd year
Basic concepts of database technology, ANSI/SPARC levels, data models, architecture of database systems (DBS).
Coceptual modelling, E/R diagrams,languges of relation DBS, SQL language.
Relational data model, theory of dependence.
Interior data organization, indexing, hashing.
Security and integrity of data, trigery.
Distributed DBS, architecture client- server, current trends of database technology development, postrelation systems.
Databases in GIS. Database systems Mircosoft Access, Oracle SQL plus.
Coceptual modelling, E/R diagrams,languges of relation DBS, SQL language.
Relational data model, theory of dependence.
Interior data organization, indexing, hashing.
Security and integrity of data, trigery.
Distributed DBS, architecture client- server, current trends of database technology development, postrelation systems.
Databases in GIS. Database systems Mircosoft Access, Oracle SQL plus.
Credits
2 credits
Language of instruction
Czech
Semester
summer
Course Guarantor
Institute
Forms and criteria of assessment
course-unit credit
Entry Knowledge
Handling with personal computers.
Aims
Theory of relation database systems. Creation tables of relations, queries. Basic of SQL language.
Ability to design a single database in MS Access.
Ability to design a single database in MS Access.
Prerequisites
Handling with personal computers.
Specification of controlled instruction, the form of instruction, and the form of compensation of the absences
Extent and forms are specified by guarantor’s regulation updated for every academic year.
Offered to foreign students
Not to offer
Course on BUT site
Exercise
13 weeks, 2 hours/week, compulsory
Syllabus
1. Fundamental terms of database technology.
2. E/R diagrams, relational database languages, SQL.
3. Relational data model, theory of dependence, normal forms.
4. Internal data organization, indexing, hashing.
5. Security and data integrity, triggers, transactions.
6. Database in GIS.
7.–10. Database systems Mircosoft Access, Oracle, SQL plus.
2. E/R diagrams, relational database languages, SQL.
3. Relational data model, theory of dependence, normal forms.
4. Internal data organization, indexing, hashing.
5. Security and data integrity, triggers, transactions.
6. Database in GIS.
7.–10. Database systems Mircosoft Access, Oracle, SQL plus.