DSP450 Information Systems and CASE Tools

Code DSP450
Name Information Systems and CASE Tools
Status Compulsory/Courses of Limited Choice
Level and type Post-graduate Studies, Academic
Field of study Computer Science
Faculty
Academic staff Jānis Eiduks
Credit points 4.0 (6.0 ECTS)
Parts 1
Annotation System development objectives. Data flows. Designing data storage structures. ER diagrams. Process design. Structure charts. Action diagrams. Quality criteria of models. Designing dialogues. CASE tools. Project management. Strategic planning..
Goals and objectives
of the course in terms
of competences and skills
1. Adoption of database design and development technologies. 2. Adoption of different data conceptual models design. 3. Adoption of data conceptual model transformations to database logical and physical models. 4. CASE tools and its possibilities. 5. Integrated Development Environments database design possibilities. 6. Object – relations mapping facilities. 7. Refactoring facilities. 8. Multicriterial approach to database design. 9. Optimization of SQL queries.
Learning outcomes
and assessment
The student understands how to design of data conceptual model and transform it to logical and physical database model - Total mark = 0.6 * total assessment of practical works + 0.4 * examination mark
The student knows how to use CASE tool for database design - Total mark = 0.6 * total assessment of practical works + 0.4 * examination mark
The student knows how to use IDE for database design and refactoring - Total mark = 0.6 * total assessment of practical works + 0.4 * examination mark
The student knows how to perform SQL queries optimization - Total mark = 0.6 * total assessment of practical works + 0.4 * examination mark
Course prerequisites Fundamentals of relational and object-relational databases.

[Extended course information PDF]