SI4SAB - Database Software Tools
| Course specification | ||||
|---|---|---|---|---|
| Course title | Database Software Tools | |||
| Acronym | SI4SAB | |||
| Study programme | Software Engineering | |||
| Module | ||||
| Type of study | bachelor academic studies | |||
| Lecturer (for classes) | ||||
| Lecturer/Associate (for practice) | ||||
| Lecturer/Associate (for OTC) | ||||
| ESPB | 6.0 | Status | elective | |
| Condition | ||||
| The goal | An introduction to software tools for database development. An introduction to software tools for database maintenance and usage. An introduction to the programming environment for databases. | |||
| The outcome | Knowledge on using software tools for database development. Knowledge on using software tools for database maintenance and usage. Knowledge on the programming environment for databases. | |||
| Contents | ||||
| Contents of lectures | SOFTWARE TOOLS FOR DATABASE DEVELOPMENT: Development by using the IE notation. Development by using the modified ERM notation. Tool implementation details. SOFTWARE TOOLS FOR DATABASE MAINTENANCE AND USAGE: Creation and administration. Report generation. Event handling. PROGRAMMING ENVIRONMENT FOR DATABASES: Database level programming. Application level programming. Object-relational mapping. | |||
| Contents of exercises | Creating data models using the IE notation. Creating stored SQL procedures. Creating Java programs that use JDBC for database acess. | |||
| Literature | ||||
| ||||
| Number of hours per week during the semester/trimester/year | ||||
| Lectures | Exercises | OTC | Study and Research | Other classes |
| 2 | 2 | 1 | ||
| Methods of teaching | Lectures. Exercises. Laboratory exercises. Homework. | |||
| Knowledge score (maximum points 100) | ||||
| Pre obligations | Points | Final exam | Points | |
| Activites during lectures | 0 | Test paper | 70 | |
| Practical lessons | 10 | Oral examination | 0 | |
| Projects | 0 | |||
| Colloquia | 20 | |||
| Seminars | 0 | |||