|
|
Main menu for Browse IS/STAG
Course info
KPV / DBC
:
Course description
Department/Unit / Abbreviation
|
KPV
/
DBC
|
Academic Year
|
2023/2024
|
Academic Year
|
2023/2024
|
Title
|
Database Systems in CIM
|
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
2
[Hours/Week]
Tutorial
4
[Hours/Week]
|
Course credit prior to examination
|
Yes
|
Course credit prior to examination
|
Yes
|
Automatic acceptance of credit before examination
|
Yes in the case of a previous evaluation 4 nebo nic.
|
Included in study average
|
YES
|
Language of instruction
|
Czech, English
|
Occ/max
|
|
|
|
Automatic acceptance of credit before examination
|
Yes in the case of a previous evaluation 4 nebo nic.
|
Summer semester
|
0 / -
|
0 / -
|
0 / -
|
Included in study average
|
YES
|
Winter semester
|
22 / -
|
0 / -
|
0 / -
|
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, English
|
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 |
No
|
Fundamental theoretical course |
Yes
|
Evaluation scale |
1|2|3|4 |
Evaluation scale for credit before examination |
S|N |
Substituted course
|
KPV/DBC*
|
Preclusive courses
|
N/A
|
Prerequisite courses
|
N/A
|
Informally recommended courses
|
N/A
|
Courses depending on this Course
|
N/A
|
Histogram of students' grades over the years:
Graphic PNG
,
XLS
|
Course objectives:
|
The course is intended to give students a good insight and knowledge into areas of database processing, function and data analysis and to apply this knowledge for usage of data structures and algorithms of their processing in mechanical engineering. The course is focused in specific tasks in mechanical engineering and economics and design of industrial databases.
|
Requirements on student
|
Continuous assessment:
- test of theory 10 pts.
- semester project 20 pts
- SQL Test 20 pts
The minimal sum is 31 pts. The assessment evaluates student's activity during the semester and it not possible to repeat it. Points from the continuous assessment are added to the final examination.
Final assessment:
combined examination (written and oral)
Only those who have successfully met the continuous assessment requirements will be permitted to take the examination.
Written part: 20 pts. (minimum is 12)
Oral part: 30 pts
Total assessment:
> 85 excellent
75 to 84 very good
61 to 74 good
< 61 failed
|
Content
|
The course is intended to give students a good insight into the following areas:
data and information in compurer integrated manufacturing, logical data structure (linear, hierarchical, network, relational), physical data structure (organization of storage disk, data storing, data access, data searching), data organization, data definition languages, data manipulation languages, SQL, multi-user access, architecture of database systems (client - server), examples of database systems (Informix, Oracle, MS SQL serve, dBase), data modelling, E-R-A Diagrams, principle of distributed database systems. During their training in the laboratory students gain experience of a selected database system.
1. Introduction. Basic concepts. Data, information and database systems.
2. Data structures. Objects. Components.
3. Building IS using database technology. Conceptual modeling, functional and data modeling, conceptual and database schema.
4. E-R conceptual model, data normalization.
5. Database models. Relational model - RDBS. Transformation of KS to RDBS.
6. Relational algebra. SQL.
7. Data structures in engineering and SQL (eg BOM).
8. Multidimensional database modeling. Data warehouses. Denormalization of data. OLAP.
9. Knowledge discovery in databases. Datamining in marketing.
10. Data organization. Multi-user data access. Transactions, data locking.
11. Database system architecture (File-Server, Client Server, Distributed Databases, Application Integration)
12. Object-relational, object-oriented and special database systems. Web databases, XML databases.
13. Characteristics and brief characteristics of some commercially used DBMS.
|
Activities
|
|
Fields of study
|
Studenti mají k dispozici Moodle e-learningový kurz pro část přednášek a pro část cvičení je k dipozici e-kniha.
|
Guarantors and lecturers
|
|
Literature
|
-
Basic:
Rauch, Jan; Šimůnek, Milan. Dobývání znalostí z databází, LISp-Miner a GUHA. Vydání první. 2014. ISBN 978-80-245-2033-9.
-
Basic:
Stanek, William R. Microsoft SQL Server 2012 : kapesní rádce administrátora. 1. vyd. Brno : Computer Press, 2013. ISBN 978-80-251-3797-0.
-
Basic:
Holub, Vojtěch; Kopeček, Pavel. Objektové myšlení a objektová analýza. [Plzeň] : SmartMotion, 2013. ISBN 978-80-87539-52-1.
-
Basic:
Laurenčík, Marek. SQL : podrobný průvodce uživatele. Praha : Grada Publishing, 2018. ISBN 978-80-271-0774-2.
-
Basic:
Tvorba databázové aplikace Sklad
(Hořejší, P.)
-
Extending:
Lacko, Luboslav. Databáze: datové sklady, OLAP a dolování dat : s příklady v SQL Serveru a Oracle. Vyd. 1. Brno : Computer Press, 2003. ISBN 80-7226-969-0.
-
Recommended:
Ulrych, Zdeněk. Databázové programování ve VB.NET. [Plzeň] : SmartMotion, 2013. ISBN 978-80-87539-48-4.
-
Recommended:
e-kurs: Databázové systémy ve strojírenství: přednášky
(Kopeček, P.)
-
Recommended:
e-kurs: Příklady z datové analýzy
(Kopeček, P.)
-
Recommended:
e-kurs: Úvod do zpracování dat
(Kopeček,P., Holub, V.)
-
Recommended:
Hotek, Mike. Microsoft SQL Server 2008 : krok za krokem. Vyd. 1. Brno : Computer Press, 2009. ISBN 978-80-251-2466-6.
-
Recommended:
Počítačová podpora ve strojírenství 2
(Ulrych, Z.)
-
On-line library catalogues
|
Time requirements
|
All forms of study
|
Activities
|
Time requirements for activity [h]
|
Contact hours
|
78
|
Undergraduate study programme term essay (20-40)
|
30
|
Preparation for an examination (30-60)
|
30
|
Preparation for formative assessments (2-20)
|
20
|
Total
|
158
|
|
Prerequisites
|
Knowledge - students are expected to possess the following knowledge before the course commences to finish it successfully: |
understand what algorithmization is |
have basic knowledge of working with files |
master any 3rd generation procedural language |
understand what object-oriented programming technology is |
Skills - students are expected to possess the following skills before the course commences to finish it successfully: |
be able to work with MS Office tools (Word, Excel, Access) |
control PC work |
be able to write and debug a simple form program application in a higher language |
be able to create simple SQL queries in Access |
Competences - students are expected to possess the following competences before the course commences to finish it successfully: |
N/A |
N/A |
N/A |
|
Learning outcomes
|
Knowledge - knowledge resulting from the course: |
know what data warehouses, data markets, and what knowledge is |
know the principle of electronic signature and data encryption |
know methods of ensuring program reliability and data security |
know the basic architectures of database management systems |
Skills - skills resulting from the course: |
design data models based on data analysis |
to implement a simple database system |
create programs in C # environment with SQL server in the background |
manipulate databases using SQL |
Competences - competences resulting from the course: |
N/A |
N/A |
N/A |
|
Assessment methods
|
Knowledge - knowledge achieved by taking this course are verified by the following means: |
Combined exam |
Test |
Individual presentation at a seminar |
Skills - skills achieved by taking this course are verified by the following means: |
Seminar work |
Competences - competence achieved by taking this course are verified by the following means: |
Combined exam |
|
Teaching methods
|
Knowledge - the following training methods are used to achieve the required knowledge: |
E-learning |
Individual study |
One-to-One tutorial |
Interactive lecture |
Skills - the following training methods are used to achieve the required skills: |
Laboratory work |
Individual study |
Competences - the following training methods are used to achieve the required competences: |
One-to-One tutorial |
Interactive lecture |
|
|
|
|