Transcript Public Reporting on Project Result

Review of Activities of
Working Group for
Database Systems
Prof. Dr Slobodanka Đorđević-Kajan
Activities
Reconstruction of the existing courses


New topics added
New and revised lab practices
New courses
New teaching materials


New textbooks
Teaching material in electronic form
Retraining of teaching staff
Reconstruction of the existing
courses
Courses


Data structures and databases
System software
Databases - reconstruction
New topics added




EER and UML conceptual modeling
Embedded SQL
Dynamic SQL
ODBC, JDBC
New teaching tools



SQL-tutor
KERMIT
NORMIT
New and revised lab practices



EER/UML modeling
Mapping to relational data model
Development DB applications
Student projects
Data Structures - Reconstruction
New topics

Data structures implementation in Java
New teaching tools

Data structures visualization tools
New lab practices

7 new labs: Data structures implementation in
Java
Student projects
System software - Reconstruction
New labs practices

6 new labs in System programming
(Unix/Linux, XP/2000)
Student projects in system
programming
New Courses
Software Engineering
 Elective in 9th semester
 2003/2004
Advance Techniques for Databases
 Elective in 9th semester
 2004/2005
Software Engineering
Course Web site
http://gislab.elfak.ni.ac.yu/sweng
Course Coordinator

Prof. Dr Slobodanka Đorđević-Kajan
Course Assistants



Dr Leonid Stoimenov
Dr Dragan Stojanović
Dr Dejan Rančić
Software Engineering
Textbook
Eric J. Braude, Software Engineering: An ObjectOriented Perspective, John Wiley&Sons, 2001
Course Goals
To provide computer science students with a
practical understanding of software engineering
concepts including the experience of developing
software in teams in accordance to a disciplined
development process
Software Engineering
Major Topics









Background and overview of life cycle models
Software processes
Project management
Software requirements and specifications
Software design and architecture
Detailed Design
Unit Implementation
Software quality assurance and testing
Software maintenance
Software Engineering
Lab Projects (12 weeks)


Students work in teams (7-9 students) developing
a small software product from requirements
elicitation to delivery following a disciplined
software development process with numerous
intermediate deliverables and quality checks
Example of student projects:
 Maltimedia education system for children with harning
impirment
Advance Techniques for Databases
Course Web site
http://gislab.elfak.ni.ac.yu/nbaze
Course Coordinator

Dr Leonid Stoimenov, lecturer
Course Assistant

Dipl. ing. Aleksandar Stanimirović
Advance Techniques for Databases
Textbook
1.
2.
R. Emasri, S. Navathe, Fundamentals of Database
Systems, Addison-Wesley, ISBN 0-201-74153-9, 3rd
edition, 2000
S.Djordjevic-Kajan, Relational Databases, Tutorial,
Faculty of Electronic Engineering Nis, 4th edition,
2001
Course Goals
To provide computer science students with a practical
understanding of advanced database management
systems and database concepts, including the
database security, query optimization and database
recovery
Advance Techniques for Databases
Major Topics











Database management systems
Transactions
Stored procedures
Database security
Database recovery
Query optimization
Client-server architecture
Distributed and mobile databases
Object-oriented and object-relational databases
Integration of information
Other types of databases (active, temporal, scientific, spatial)
Advance Techniques for Databases
Lab Projects (12 weeks)


Students work individual or in teams (2-3
students)
Examples of student projects:
 Postrelational databases - Cache
 Native XML Databases - eXist
 ...
New teaching material
Lab manuals

Databases in Oracle

Data Structures in Java

Data Structures in C++ (in publishing)

System software (Operating Systems and System
programming)

Artificial Intelligence
Teaching material in electronic form

Slides covering all the lessons

Answers to selected exercises

Handouts that contains a summary of lessons, a set of
exercises, etc.

Tutorials

Supplementary material
Databases -Lab manual
6 labs for Database Development
Lab 1: Conceptual and Logical Design


Build Conceptual Data Model (ER/EER modelling)
Build and Validate Logical Data Model (Mapping ER/EER to Relational Data
Model, Normalization)
Lab 2: Physical Database Design (using ORACLE*Plus)



Translate Logical Data Model for ORACLE DBMS
Creating relations
Loading Database
Lab 3: Simple SQL Queries
Lab 4: Complex SQL Queries
Lab 5: Physical Database Design



Update Database
Design File Organization and Indexes
Design User Views
Lab 6: DB applications Development (using Pro*C/C++)
Data Structures in Java/C++
Lab manuals
6 labs for basic data structures implementation
Lab 1: Array
Lab 2: Linked list
Lab 3: Stack, Queue and Deque
Lab 4: Hash table
Lab 5: Tree
Lab 6: Graph
Conclusions
Objectives:

Improve teaching and learning process
Realization:

8 on a scale from 1 to 10