The course is included in these curricula and study modules
It 2001 - 2004 - System and application software
Level/category
Teaching language
Swedish
Type of course
Compulsory
Recommended year of study
3
Total number of ECTS
3 cr
Competency aims
This subject will give the students the expertise needed to model, design, implement and manage a relational database. The student will also establish a general understanding of the theory behind relational databases. The course will give students fundamental knowledge of SQL language and multi-user database management systems. Students are also introduced to real database development environment in PC-lab.
Course contents
Database theory:
- definitions, concepts and terminology
- relational database model
- data base management systems and query language
- data integrity
Working with databases in a client-server environment using SQL:
- select queries, data manipulation (DML)
- creation of tables and other database objects (DDL)
Prerequisites and co-requisites
None
Recommended or required reading
Lecturer's material
McCarty-Risch: Databasteknik (elementary part)
Study activities
- Lectures - 15 hours
- Excursions and demonstrations - 3 hours
- Exercise based learning - 20 hours
- Tuition managed by students but supervised by the teacher - 12 hours
- Project work and productions - 15 hours
- Individual studies - 15 hours
Workload
- Total workload of the course: 80 hours
- Of which autonomous studies: 30 hours
- Of which scheduled studies: 50 hours
Mode of Delivery
Participation in tuition
Assessment methods
Reports and productions
Examiner
Karlsson Hanne
Home page of the course
Group size
No limit
Course completion date
Date for course completion will be announced later
Assignments valid until
12 months after course has ended
Assessment methods
2007-04-10 - Reports and productions