OPF:INMBADTB Databases - Course Information
INMBADTB Databases
School of Business Administration in KarvinaWinter 2014
- Extent and Intensity
- 2/1/0. 6 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- Mgr. Milena Janáková, Ph.D. (lecturer)
doc. RNDr. František Koliba, CSc. (lecturer)
Mgr. Milena Janáková, Ph.D. (seminar tutor)
doc. RNDr. František Koliba, CSc. (seminar tutor) - Guaranteed by
- Mgr. Milena Janáková, Ph.D.
Department of Informatics and Mathematics – School of Business Administration in Karvina
Contact Person: doc. Mgr. Petr Suchánek, Ph.D. - Prerequisites
- None
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
- fields of study / plans the course is directly associated with
- Managerial Informatics (programme OPF, B_SYSINF)
- Course objectives
- The course acquaints students with the basic knowledge of relational databases and practical implementation of simple problems in the MS ACCESS.
- Syllabus
- 1. Basic concepts and principles.
2. DBS Architecture.
3. The relational data model.
4. DDL.
5. Working with queries.
6. SQL.
7. QBE.
8. Transactions.
9. DBS Objects.
10. Database management.
11. Protection and security.
12. Trends.
13. Semester project.
- 1. Basic concepts and principles.
- Literature
- required literature
- DATE, C.J. Database Design and Relational Theory: Normal Forms and All That Jazz. O'Reilly Media, 2012. ISBN 978-1449328016. info
- recommended literature
- LAMBERT, J., COX, J. Microsoft Access 2010 Step by Step. Microsoft Press, 2010. ISBN 978-0735626928. info
- SCIORE E. Database Design and Implementation. J. Wiley & Sons, 2008. ISBN 978-0-471-75716-0. info
- TANIAR, D., LEUNG, C. H. C., RAHAYU, W., GOEL, S. High Performance Parallel Database Processing and Grid Databases. J. Wiley & Sons Inc., 2008. ISBN 978-0-470-10762-1. info
- GARCIA-MOLINA, H., ULLMAN, J. D., WIDOM, J. systems : the complete book. Upper Saddle River, 2002. ISBN 0-13-031995-3. info
- LORENTS, A. C., MORGAN, J. N. Database systems. Concepts, Managements and Aplications The Dryden, 1999. ISBN 0-15-500029-2. info
- Language of instruction
- English
- Further comments (probably available only in Czech)
- The course can also be completed outside the examination period.
- Teacher's information
- Attendance in seminars 70 %, ongoing test, combined exam
- Enrolment Statistics (Winter 2014, recent)
- Permalink: https://is.slu.cz/course/opf/winter2014/INMBADTB