157-0340/01 – Fundamentals of Database Systems (ZDBSB)

Gurantor departmentDepartment of Systems EngineeringCredits5
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantordoc. Ing. Ludmila Kalužová, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction2008/2009Year of cancellation2012/2013
Intended for the facultiesEKFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
MAR0011 prof. Ing. Dušan Marček, CSc.
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2

Subject aims expressed by acquired skills and competences

- To interpret a three level conception of data modelling. - To design the data structures in the relational database environment. - To use Oracle database system environment. - To apply SQL definition, manipulation commands. - To use SELECT command for data selection, projection, restriction, join operations.

Teaching methods

Lectures
Tutorials

Summary

The objective of the course is to obtain a basic knowledge of the database design in environment of relational databases. The methodology of a database design comprises a three level conception, i.e. semantic, conceptual and logical level. The course also involves using SQL language as definition, manipulation and query language in the database system.

Compulsory literature:

1.Connolly,T., Begg,C., Holowczak,R. (2008) Business Database Systems. Addison Wesley Publ. Comp., ISBN 978-1-4058-7437-3 2.Loney, K. (2009) ORACLE DATABASE 11g: The Complete Reference. Osborne McGraw-Hill Comp., ISBN 978-0-07-159875-0

Recommended literature:

1.Loney,K., Brylan,B. (2007) Oracle Database 11g DBA Handbook Osborne McGraw-Hill Comp., ISBN 978-0071496636 2.Koch, G., Loney, K. (2004): ORACLE DATABASE 10g The Complete Reference. Osborne McGraw-Hill Comp., Emeryville California, ISBN 0-07-225352-5 3. Date, C. J., (2003) An Introduction to Database Systems. 8th edition: Addison-Wesley Publishing Company, ISBN 0-32-119784-4

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Subject Syllabus 1.Database systems and Features of DBS, the Database architecture. 2.Semantic data modelling, forms of data requirements analysis and their structuring. 3.Conceptual data modelling, ER model – constructs, graphical representation. 4.Conceptual data modelling - generalisation and specialisation. 5.Relational data modelling, basic constructs, definition, entities and relationships modelling. 6.Normalisation of relations - first , second, third normal form, Boyce-Codd normal form. 7.Functions of DBMS, Oracle database10g. 8.SQL – Data Definition Language ,SQL history, table creation, table constraints. 9.SQL – Data Manipulation Language, Inserting data into table, changing data, deleting data. 10.SQL – statement SELECT – From ,Where, Order by, syntax of condition 11.SQL - Select – join operation, inner join, outer join, Cartesian product, natural join. 12.SQL – SELECT- Select – Group by and Having, group functions. 13.SQL – Creating View and Materialized View

Conditions for subject completion

Full-time form (validity from: 2011/2012 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 45  23
        Examination Examination 55  6 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2012/2013 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2012/2013 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 2 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2009/2010 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2008/2009 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2010/2011 Summer