Information Systems Development
Implementation of Semestral Project
These conditions are set:
- Development Environment: Java a .NET (desktop or web application – J2EE and ASP.NET)
- SŘBD: object-relational database (MS SQL Server nebo Oracle, the minimal variant is to implement triggers and stored procedures)
- Object-relational mapping: it may be written by yourself, or you may use variant frameworks or ORM generators. You have to focus on the efficiency of your implementation, f.e. update will not be executed by universal method, that updates values of all atributes; you will use selection and projection besides not always needed select * from table; usafe of SELECT FOR UPDATE; and so on.
Students may implement IS based on XML as well. In the case, documents will be stored in XML database of in XML files. System for work with XML will use one of these languages: XSLT, XQuery, XQuery Update Facilities.
Other conditions:
- IS should contains also more complicated processes (like transaction) and it should have functions for search as well as printing reports.
- IS will implement whole analysis.
- Values of foreign keys will be not presented neither inserted on the forms (in case that table contains foreign keys), but the records that are assigned to the foreign keys or some values of that record
- Main form will contain table with record; update and insert of records will be executed by form that contains details of record.
- Important part of IS will be documentation (analysis and implementation).
Subject content
Students will analyse selected information system in first part of semester. The analysis has to contain:
- Conceptional and data model
- Process analysis
- Implementation of IS in development tool APEX
Students should choose projects during first two excercises and project has to be consulted with teacher.
Maximal number of points from analysis is 20, minimal 10.
Implementation of IS will be presented in last week of semester. Mainly evaluated will be data layer:
- Entity-relationship model or XML data model usage
- Functionality on server side
- etc...
Projects can be implemented in Java or .NET, Oracle or SQL Server should be used as database system.
Maximal number of points from analysis is 25, minimal 13.
Lectures and Exercises
| Week | Lecture | Exercise |
| 1. | Introduction, architectures of information systems pdf (last change: 10.2.2010) | Selection of the project, Conceptual model tasks (last change: 8.2.2010) |
| 2. | Object-relational data model pdf (last change: 17.2.2010) | Creation of SQL script and indices, process analysis tasks (last change: 16.2.2010) |
| 3. | Apex pdf (last change: 23.2.2010) | Process analysis, Apex |
| 4. | Object-relational data model II pdf (last change: 3.3.2010) | Process analysis, Apex |
| 5. | XML data model pdf (last change: 8.3.2010) Sample example: XML-based information system (last change: 18.3.2010) | Presentation of analysis |
| 6. | XML data model pdf (last change: 8.3.2010) Sample example: XML-based information system (last change: 18.3.2010) | Presentation of analysis |
| 7. | J2EE, Struts2, object-relational mapping pdf (last change: 22.3.2010) Sample Application Struts2 Sample Application (last change: 22.3.2010) | Apex |
| 8. | object-relational mapping, Native XML databases 8a.pdf, 8b.pdf (last change: 2.4.2010) | Consultation of projects |
| 9. | - | Consultation of projects |
| 10. | Security issues in IS; Other database applications pdf (last change: 14.4.2010) | Consultation of projects |
| 11. | - | Project submission |
PL/SQL Documentation