Database Systems (in English)
IDSe Acad. year 2018/2019 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, 2000, 1104 p.
- Date C.J.: An Introduction to Database Systems. Seventh edition. Addison-Wesley, 2000, 838 p.
- Silberschatz, A., Korth H.F, Sudarshan, S.: Database System Concepts. Fourth Edition. McGRAW-HILL. 2001, 1088 p.
- On-line help and documentation of Oracle.
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.
- The SQL - data definition.
- The SQL - SELECT statement (fundamentals).
- The SQL - SELECT statement (extension).
- The SQL - other statements for data manipulation. System catalogue.
- The SQL - views, missing information, embedded SQL, cursor, dynamic SQL. Query by example (QBE).
- 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.
- Transaction processing - properties and states of a database transaction.
- Introduction to failure recovery and concurrency control.
Syllabus of numerical exercises
- Demonstration of a database application development in an environment used for projects in a laboratory (Oracle currently).
- Creating an Oracle database.
- Screen form development in Oracle Developer.
- Report development in Oracle Developer.
- Stored procedures and database triggers in Oracle.
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.
- An SQL script with statements for advanced database objects and project documentation.
- Data and use case models - 5 points
- Building of the database in SQL - 9 points
- Querying in SQL - 10 points
- Advanced database objects and documentation - 10 points
- Midterm written exam - 15 points
- Final written examination - 51 points
- To be allowed to sit for written examination student is to present and defend project outcomes in due dates, and to earn at least 24 points during semester.
|Tue||exam||2019-05-21||C228||10:00||12:50||INTE||xx||exam (the 3rd term/2nd resit)|
|Tue||lecture||1., 3., 4., 5., 9., 10., 11., 12., 13. of lectures||C228||11:00||13:50||INTE||xx||lectures (selected weeks only)|
|Tue||comp.lab||1., 2., 3., 4., 7., 8., 10., 11., 13. of lectures||N205||12:00||13:50||INTE||xx||self-training/project labs|
|Tue||comp.lab||5., 6., 9., 12. of lectures||N205||13:00||13:50||INTE||xx||demo labs (selected weeks only)|
|Wed||exam||2019-05-15||C228||10:00||12:50||INTE||xx||exam (the 2nd term/1st resit)|
|Wed||lecture||3., 5., 6., 9. of lectures||C228||10:00||12:50||INTE||xx||lectures (selected weeks only)|
|Fri||exam||2019-05-10||C228||10:00||12:50||INTE||xx||exam (the 1st term/regular)|