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:
The student will design and implement a database of at least five tables with illustrative data and queries submitted with documentation no later than the last day of December.
Examination:
The student will pass a written test, which a short interview may supplement. No later than the last day of January.
Notice:
The dates and form may be adjusted concerning the measures announced regarding the epidemiological situation in the Czech Republic.
|
Content
|
DBMS, requirements and properties.
Conceptual data model.
Entity-Relationship and Entity-Relationship-Attribute Modeling.
Problems with ER models.
The relational data model, relational algebra. Terms relation, entity, file and table.
Functional dependency of attributes, normalization.
Basics of the SQL, data definition and data manipulation.
Embedded SQL, ODBC.Integrity constraints in SQL. Triggers, Access rights and authority in SQL.
Transaction management, journaling, and consistent state of the database.
Concurrency control of the transaction, locking methods and timestamping methods.
|
Activities
|
|
Fields of study
|
Studentům jsou k dispozici všechny podstatné informace a materiály v elektronické podobě prostřednictvím CourseWARE integrovaného do univerzitního portálu.
|
Guarantors and lecturers
|
|
Literature
|
-
Basic:
Database eLearning
(RUSSELL, Gordon)
-
Basic:
CONNOLLY, Thomas; BEGG, Carolyn; HOLOWCZAK, Richard. Database Systems: A Practical Approach to Design, Implementation and Management. Pearson, 2014. ISBN 978-1-292-06118-4.
-
Extending:
CHOPRA Rajiv. Database Management System (DBMS): A Practical Approach. S. Chand Publishing, 2016. ISBN 978-93-856-7634-5.
-
Extending:
PANNEERSELVAM, R. Database Management Systems. PHI Learning, 2018. ISBN 978-93-874-7210-5.
-
Extending:
TALE, Steve. SQL: The Ultimate Beginners Guide: Learn SQL Today. 2016. ISBN 978-15-336-0456-9.
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Preparation for formative assessments (2-20)
|
10
|
Contact hours
|
65
|
Undergraduate study programme term essay (20-40)
|
40
|
Preparation for an examination (30-60)
|
40
|
Total
|
155
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
to apply basic knowledge of imperative programming |
to 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 an imperative programming language |
appropriately select basic data structures |
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: |
to design an E-R-A model of a simple real situation |
to be familiar with data modeling using E-R-A graphical notation |
to know the issues of transaction processing and the principles of parallel transactions |
Skills - skills resulting from the course: |
to design an E-R-A model of a real situation |
to implement a database in a selected DBMS |
to write SQL statements |
|
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 |
|
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 |
|