ID101104 or ID101405 or IF100305 or ID101505 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
The history of the subject
Database based Information and communication technology projects
Perspectives on information systems design, participation, change processes and organisational development, ethical considerations
Management of information and communication technology projects
System development strategies; methods, description techniques and
tools
Important documents in a project / system life cycle
Database concepts
Relational database systems: datamodelling, design, realisation
Data integrity
SQL Server; components, architecture, installation, configuration and
administration
Database security; Log ins, users, server and database roles, permissions
Use of Transact SQL; definition, manipulating, control and administration
Programming of stored procedures
Development tools, front-end
Transactions and simultaneity
Recent requirements and trends
Database Management System: Microsoft SQL Server
Lectures, practical lab sessions and extensive project work. The course is labor intensive.
Accepted project application - progress reports for exam project and presentations of the project.
A major design and development project – individual or in pairs of two. The project shall reflect independent work by the student(s) and relevant sources shall be clearly stated. The grade is based on a total evaluationof the project. If one fails to pass the project, a completely new project must be delivered within given deadlines. The project can not be adjusted after delivery deadline.
