ID101101 or ID101301 or equivalent
The student will gain comprehensive knowledge of information systems design, of modern database systems and application development, to enable him/her to design and implement semi-complex databases and applications.
The course shall enable students to:
- Carry out problem definition and analysis
- Plan activities in a project
- Use common methods / techniques for systems design and database systems development
- Produce necessary documentation for the various phases of a project
- Activities in information system design and development projects
- Important documents in a project / system life cycle
- Different development strategies and philosophies
- Methods / phases- Analysis of change / organisational development
- Common techniques and documentation
- Evolutionary, Experimental, User Driven and Socio-Technical system development
- Quality Assurance / Quality Development
Overview of database systems
- Application areas, models and concepts
- Hierarchical databases
- Network database systems
- Relational database systems
- Object oriented systems
Relational database systems
- Relational model / theory
- Data structures / Tables
- The SQL-language
- Integrity / Consistency
- Relational algebra
- Retrieval and simultaneity
RDBM systems
- installation, configuration, administration, security
- n-tier / transactions / recovery
- tools / software for server and application development
- web access / web front
Lectures, practical lab sessions and extensive project work - business related workshops
Accepted project application - completed progress reports for exam project.
Familiarity with current software products : Microsoft SQL Server, E-R tools, MS Access, Visual Basic, MS InterDev.
A major design and development project – individual or in groups of two. The project shall reflect independant work and relevant sources shall be clearly stated. Graded.
