Høgskolen i Ålesund
Larsgårdsvegen 2, N-6025 Ålesund – Tlf. +47 70 16 12 00 – Fax. +47 70 16 13 00
Studiehandbok
Til norsk

2006-2007 / Course descriptions / ID302305 Database development  

ID302305 Database development

Course Code
ID302305

Course Name
Database development

Credits
15.00

Target Audience
Bachelor in Engineering - Information and Communication technology studies

Prerequisites
ID101104 or ID101405 or IF100305 or ID101505 or equivalent
Objectives

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

Topics

The history of the subject
Database based Information and communication technology projects
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

Instruction

Lectures, practical lab sessions and extensive project work. The course is labor intensive.

Mandatory Assignments

Submitting of project application, submitting of process reports related
to the project and presentations of the project within given deadlines.

Unless other written agreements, project application must be handed in not later than six weeks after beginning of the course.

Evaluation

A major individual design and development project. 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. 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.
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.

Grades
ABCDEF

Revised date
2005.04.01

Revised by
Anniken Karlsen