| |
Contents
Current
status
Current status and innovation
proposals
New course - Software Engineering
Current
status
The
following Database Systems courses are delivered at FEEN:
- Data
Structures and Databases (semester VII - 2+2+1,VIII - 2+2+1)
- Distributed
Databases (semester IX- 2+2+1)
Current
status and innovation proposals
| Data
Structures and Databases
|
semester
VII-2+2+1, VIII-2+2+1 |
|
Data Structures
part
| Prerequisites: |
| • |
Solving
of problems on algorithm level |
| • |
Programming
with C/C++ |
|
| Main
topics: |
| • |
Linear
and non-linear data structures (strings, arrays,
linked lists, stacks, queues, trees, graphs,
tables) |
| • |
Algorithms
that operate on them |
| • |
Representation
in memory |
| • |
Sorting
and searching algorithms |
| • |
File
organization and indexes |
| • |
Practical
laboratory work in programming with data structures |
|
| Outcomes
(to enable students to) : |
| • |
Identify
data structures that could be used to represent
specific types of information |
| • |
Write
programs with C/C++ that use the data structures |
|
Databases part
| Prerequisites: |
| • |
Data
structures |
| • |
Programming
with C/C++ |
|
| Main
topics: |
| • |
Database
systems |
| • |
Data
models (ER/EER, Relational) and data modeling |
| • |
Mapping
ER/EER to relational schema |
| • |
Relational
query languages (algebra, calculus, SQL) |
| • |
Relational
database design |
| • |
Transaction
processing (concurrency control, crash recovery) |
| • |
ORACLE
(SQL*Plus, Pro*C) |
|
| Outcomes
(to enable students to) : |
| • |
Design
database |
| • |
Use
relational algebra and calculus to query DBs |
| • |
Use
SQL to query, define, load, update and manage
relational databases |
| • |
Understand
the functionality of RDBMSs |
|
|
| Labs
(for Databases): |
| • |
Lab1:
ER modeling and ER-to-Relational mapping |
| • |
Lab2:
SQL (Create and loading) |
| • |
Lab3:
SQL (Queries) |
| • |
Lab4:
SQL (Update and Delete) |
| • |
Lab5:
SQL (Views and Indexes) |
| • |
Lab6:
Pro*C |
| • |
Lab test |
|
| Lab
Platform : |
| • |
Oracle
7.3 (Server) |
| • |
Oracle
8 (clients) |
| • |
Pro*C, SQL*Plus |
|
| Text
books: |
| • |
R.
Elmasri, S. Navathe, “Fundamentals of
Database Systems”,2nd (1994), 3rd (2000) |
| • |
Handouts
(in Serbian) |
|
| Innovation
proposal: |
| • |
New
topic (embedding SQL queries into C++ and JAVA) |
| • |
New
Lab platform (Oracle 9i, Oracle Designer, Oracle
Developer) |
| • |
New
teaching tools (ITS SQL-tutor, KERMIT) |
| • |
Text
book in Serbian |
|
|
| |
|
| Distributed
Databases |
semester
IX-2+2+1 |
|
| Prerequisites: |
| • |
Databases |
| • |
C/C++, Java |
| • |
Computer network |
|
| Main
topics: |
| • |
Distributed
DBMS architecture |
| • |
Distributed
data storage |
| • |
Distributed
query processing |
| • |
Distributed
transaction model |
| • |
Distributed
database design |
| • |
Practical
laboratory work in DDB design and application |
|
| Outcomes
(be familiar with) : |
| • |
Design
distributed database |
| • |
Understand
the functionality of RDDBMS |
| • |
Use SQL to query, define, load, update and
manage distributed databases |
|
|
| Innovation
proposal: |
| • |
New
topics (distributed object database management,
database interoperability, data warehousing, www
database access) |
| • |
New
Lab platform (Oracle 9i, Oracle Designer, Oracle
Developer) |
|
|
| |
|
Object-Based Databases (new course proposal) |
2+1+2 |
|
| Prerequisites: |
| • |
Data
Structures and Databases |
| • |
C++,
Java, XML, HTML |
|
| Main
topics: |
| • |
OO
data model |
| • |
Mapping
ER to OO and OO to relational schema |
| • |
Object-Oriented Databases |
| • |
Object-Relational
Databases |
| • |
Web-based
Databases |
| • |
Management
of XML data with database technique |
| • |
Object-Relational database HTML pages, querying |
|
| Outcomes
(be familiar with) : |
| • |
Object-oriented
model and modeling |
| • |
Using OO queries into C++ and Java |
| • |
Building applications on an ORDBMS/OODBMS |
|
|
|
|
