Course Details
Databases
Academic Year 2024/25
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.
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.