ID101104 or ID101405 or IF100305 or ID101505 or equivalent
The student will gain comprehensive knowledge of information systems design, of modern database systems and applications development, to enable him/her to design and implement semi-complex databases and applications, and develop basic aplications using modern developing tools
The course shall enable students to:
- Carry out problem definition and analysis
- Plan activities in a project
- Apply common methods 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.
Handing in of project aplication subject to further agreement. Handing in of process reports related to work on ones project. Presentations of the project according to set deadlines. Further instructions regarding minimum requirements of contents and deadlines regarding the project will be presented by subject teacher at the beginning of the course.
A major individual project following written application and subject teachers regulations. The project shall reflect independent work by the student and relevant sources shall be clearly stated. The grade is based on a total evaluation of the project. The project can not be adjusted after date of delivery. If one fails to pass the project special regualtions apply.
Unless other written agreements, project application must be handed in not later than six weeks after beginning of the course.
