|
|
Main menu for Browse IS/STAG
Course info
KIV / DB1
:
Course description
Department/Unit / Abbreviation
|
KIV
/
DB1
|
Academic Year
|
2023/2024
|
Academic Year
|
2023/2024
|
Title
|
Database Systems 1
|
Form of course completion
|
Exam
|
Form of course completion
|
Exam
|
Accredited / Credits
|
Yes,
6
Cred.
|
Type of completion
|
Combined
|
Type of completion
|
Combined
|
Time requirements
|
Lecture
3
[Hours/Week]
Tutorial
2
[Hours/Week]
|
Course credit prior to examination
|
Yes
|
Course credit prior to examination
|
Yes
|
Automatic acceptance of credit before examination
|
No
|
Included in study average
|
YES
|
Language of instruction
|
Czech
|
Occ/max
|
|
|
|
Automatic acceptance of credit before examination
|
No
|
Summer semester
|
0 / -
|
0 / -
|
0 / -
|
Included in study average
|
YES
|
Winter semester
|
169 / -
|
0 / -
|
0 / 3
|
Repeated registration
|
NO
|
Repeated registration
|
NO
|
Timetable
|
Yes
|
Semester taught
|
Winter semester
|
Semester taught
|
Winter semester
|
Minimum (B + C) students
|
10
|
Optional course |
Yes
|
Optional course
|
Yes
|
Language of instruction
|
Czech
|
Internship duration
|
0
|
No. of hours of on-premise lessons |
|
Evaluation scale |
1|2|3|4 |
Periodicity |
každý rok
|
Evaluation scale for credit before examination |
S|N |
Periodicita upřesnění |
|
Fundamental theoretical course |
Yes
|
Fundamental course |
Yes
|
Fundamental theoretical course |
Yes
|
Evaluation scale |
1|2|3|4 |
Evaluation scale for credit before examination |
S|N |
Substituted course
|
None
|
Preclusive courses
|
KIV/DB1-E
|
Prerequisite courses
|
N/A
|
Informally recommended courses
|
N/A
|
Courses depending on this Course
|
KSO/SBZIM
|
Histogram of students' grades over the years:
Graphic PNG
,
XLS
|
Course objectives:
|
To acquaint students with the designing the data models and their implementation in the chosen database system. Familiar with the principles of the current DBMS, and in particular with the principles of transaction processing data. Explain the relational data model, relational algebra bases, normal forms and learn the basics of SQL.
|
Requirements on student
|
Credit is awarded for a simple database application in the range of at least five tables, submitted no later than the end of January of the current academic year. The application will be implemented in the environment of Oracle DBMS or MariaDB DBMS, the basics of which the student will be explained on the exercise. Along with the presentation of the application, a paper will be presented, the structure of which will be discussed and explained in seminars. The test is organized on the form of a written test to be completed by a short interview.
|
Content
|
1. DBMS, requirements for the DBMS and its properties.
2. Conceptual data model, Entity-Relationship Modeling .
3. Problems wits ER models, fan trap.
4. Loops in ER models, chasm trap, generalizace a specializace in ER models.
5. The relational data model, relational algebra.
6. Basic of language SQL, data definition and data manipulation.
7. Integrity constraints in SQL, access right and authority in SQL.
8. Network data model.
9. Functional dependency of attributes, Armstrong's axioms.
10. Basic normal forms.
11. Advanced normal forms, multivalued dependency.
12. Transaction management, journaling, consistent state of DB.
13. Concurrency control of transaction, locking methods and timestamping methods.
|
Activities
|
|
Fields of study
|
Studentům jsou postupně zpřístupňovány prezentace jednotlivých přednášek. Dále jsou postupně studentům nabízeny praktické návody, jak vytvořit různé typy datových modelů včetně vypracovaných modelů, které jsou vytvořeny podle těchto návodů. Všechny tyto materiály jsou nabízeny v Courseware předmětu, a to na stránkách Přednášky a Cvičení.
|
Guarantors and lecturers
|
-
Guarantors:
Ing. Martin Zíma, Ph.D. ,
-
Lecturer:
Ing. Martin Zíma, Ph.D. (100%),
-
Tutorial lecturer:
Ing. Martin Dostal, Ph.D. (100%),
Ing. Martin Prantl, Ph.D. (100%),
Ing. Jan Rychlík (100%),
Ing. Martin Zíma, Ph.D. (100%),
|
Literature
|
-
Basic:
Connolly, Thomas M.; Begg, Carolyn E. Database systems : a practical approach to design, implementation, and management. 3rd ed. Harlow : Addison-Wesley, 2002. ISBN 0-201-70857-4.
-
Basic:
Pokorný, J., Valenta, M. Databázové systémy. Praha: Česká technika - nakladatelství ČVUT, 2020. ISBN 978-80-01-06696-6.
-
Basic:
Stephens, Ryan K.; Plew, Ronald R.; Jones, Arie. Naučte se SQL za 28 dní. 1. vydání. 2012. ISBN 978-80-251-2700-1.
-
Recommended:
Teorey, Toby. Database modeling and design. Burlington, 2011. ISBN 978-0-12-382020-4.
-
Recommended:
Connolly, Thomas M., Begg, Carolyn E. Database systems : a practical approach to design, implementation, and management. Uttar Pradesh: Pearson India Education Services, 2020. ISBN 978-93-534-3891-3.
-
Recommended:
Pokorný, Jaroslav; Halaška, Ivan. Databázové systémy. Vyd. 2., přeprac. Praha : Vydavatelství ČVUT, 2003. ISBN 80-01-02789-9.
-
Recommended:
Scheber, Anton. Databázové systémy. 1. vyd. Praha : SNTL, 1988.
-
Recommended:
Pokorný, Jaroslav. Databázové systémy 2. Vyd. 1. Praha : Nakladatelství ČVUT, 2007. ISBN 978-80-01-03797-3.
-
Recommended:
Conolly, Thomas; Begg, Carolyn E.; Holowczak, Richard. Mistrovství - databáze : profesionální průvodce tvorbou efektivních databází. Vyd. 1. Brno : Computer Press, 2009. ISBN 978-80-251-2328-7.
-
Recommended:
Pokorný J. Počítačové databáze, Výběr informací z organizační a výpočetní techniky. KS Praha, 1991.
-
Recommended:
Chong, Raul; Hakes, Ian; Ahuja, Rav. Začínáme s DB2 Express-C : kniha od komunity pro komunitu. 3. vyd. Praha : DNS, 2009.
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Preparation for an examination (30-60)
|
40
|
Contact hours
|
65
|
Undergraduate study programme term essay (20-40)
|
40
|
Preparation for formative assessments (2-20)
|
10
|
Total
|
155
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
apply basic knowledge of imperative programming |
apply basic knowledge of operating systems |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
actively program in the imperative programming language |
choose the basic data structures appropriately |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
know the issues of transaction processing and the principles of parallel running of transactions |
to design an entity-relationship model of a simple real situation |
be familiar with database modeling with usage the entity-relational graphical notation |
Skills - skills resulting from the course: |
write simple SQL statements |
create a simple database application |
implement the entity relationship model of a simple real situation in the selected DBMS |
Competences - competences resulting from the course: |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Combined exam |
Test |
Seminar work |
Individual presentation at a seminar |
Skills - skills achieved by taking this course are verified by the following means: |
Written exam |
Skills demonstration during practicum |
Individual presentation at a seminar |
Competences - competence achieved by taking this course are verified by the following means: |
Combined exam |
Seminar work |
Continuous assessment |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
Lecture |
Practicum |
Individual study |
One-to-One tutorial |
Interactive lecture |
Discussion |
Skills - the following training methods are used to achieve the required skills: |
Practicum |
Task-based study method |
Skills demonstration |
Discussion |
Competences - the following training methods are used to achieve the required competences: |
Interactive lecture |
|
|
|
|