1 / 19

Review of Activities of Working Group for Database Systems

This review covers the reconstruction of existing courses, addition of new topics, revised lab practices, and development of new teaching materials in database systems at Niš University. The focus is on modernizing curriculum, introducing advanced techniques, and enhancing learning resources to support students in software engineering and database management. Professor Dr. Slobodanka Đorđević-Kajan leads the efforts, collaborating with a dedicated team to elevate the quality of education in these crucial fields.

darrend
Download Presentation

Review of Activities of Working Group for Database Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Prof. Dr Slobodanka Đorđević-Kajan Review of Activities of Working Group for Database Systems

  2. 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

  3. Reconstruction of the existing courses Courses Data structures and databases System software

  4. 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

  5. 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

  6. System software - Reconstruction • New labs practices • 6 new labs in System programming (Unix/Linux, XP/2000) • Student projects in system programming

  7. New Courses Software Engineering Elective in 9th semester 2003/2004 Advance Techniques for Databases Elective in 9th semester 2004/2005

  8. 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ć

  9. Software Engineering Textbook Eric J. Braude, Software Engineering: An Object-Oriented 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

  10. 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

  11. 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

  12. 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ć

  13. Advance Techniques for Databases • Textbook • 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, 4thedition, 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

  14. 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)

  15. 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 • ...

  16. 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

  17. 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++)

  18. 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

  19. Conclusions • Objectives: • Improve teaching and learning process • Realization: • 8 on a scale from 1 to 10

More Related