IDS Acad. year 2010/2011 Summer semester 5 credits
Language of instruction
Subject specific learning outcomes and competences
Generic learning outcomes and competences
Prerequisite kwnowledge and skills
- Ramakrishnan R.: Database Management Systems. Third edition. McGraw-Hill Science/Engineering/Math, 2002, 1104 p.
- Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Sixth Edition. McGraw-Hill. 2010, 1320 p.
- On-line nápověda produktů Oracle, dokumentace dostupná na http://www.oracle.com/pls/db112/homepage.
Syllabus of lectures
- Fundamental concepts of database systems.
- Conceptual modeling.
- Fundamentals of the relational model. Transformation of a conceptual model to a relational database schema.
Introduction to database application development in Oracle products environment.
- The SQL - data definition.
- The SQL - SELECT statement (fundamentals).
- The SQL - SELECT statement (extension).
- The SQL - other statements for data manipulation. System catalogue.
Introduction to PL/SQL.
- The SQL - views, missing information, embedded SQL, cursor, dynamic SQL. Query by example (QBE).
Fundamentals of application development in Oracle Form Builder.
- The client/server architecture. Database triggers and stored procedures. Data integrity, data security.
- Data organization at the internal level - indexing and hashing. Query processing and optimization.
Report development in Oracle Report Builder.
- Introduction to normal forms, the use of normalization in database design.
- Transaction processing - properties and states of a database transaction. Introduction to failure recovery and concurrency control.
- Current trends in database technology. Access to databases from the Web.
Syllabus of numerical exercises
Syllabus - others, projects and individual work of students
- Presentation of a conceptual model (ERD or a class diagram) and a use case model for a given problem (continuation of the project started in the subject Introduction to software engineering).
- An SQL script that creates and populates database tables.
- An SQL script with queries over the database tables.
- Realization of the application.
- Models of requirements analysis - 5 points
- Database design - 5 points
- Queries in SQL - 5 points
- Mid-term written examination - 14 point
- Evaluated project with the defence - 20 points
- Final written examination - 51 points
- To be allowed to sit for written examination student is present and defend outcomes 1 and 4 of the project in due dates, and to earn at least 25 points during semester.
Course inclusion in study plans