Universitetet for miljø- og biovitenskap (UMB)
Search result
Norsk
| INF130 |
Introduction to Databases |
| Course responsible |
Knut Kvaal |
IMT |
|
|
|
| Number of credits allocated |
10.0 |
| Language |
Norwegian |
| Limits for class size |
- |
| Semester/trimester |
| August block |
Autumn parallel |
January block |
Spring parallel |
June block |
| |
X |
|
|
|
| |
|
|
|
|
| Colour explanation: Red/yellow = teaching periods. The red period indicates when the teaching starts. |
|
|
| Teachers |
- |
| Type of course |
Lectures: 3 hours per week. Exercises: 4 hours per week. |
| Compulsory educational activities |
Compulsory assignments will be given. The assignments will include all areas that are of importance to the study of the subject. A more elaborate exercice will be given in the last part of the course |
| Prerequisites |
INF100. |
| Recommended prerequisites |
Basic programming and some general IT-knowlegde. |
| Exam |
S |
| Assessment methods |
Written examination: 3 hours. Oral examination: 1 hour. The form of the examination will be oral if there are less than 15 registered candidates. |
| Grading |
A-F |
| Examination aids |
A1: not calculator, no other aids. |
| Nominal workload |
300 hours. |
| Course frequency |
Annually |
| Comment on frequency |
- |
| Teaching methods |
1. Lectures. 2. Group work/exercises with teaching assistant present in selected hours. 3. Compulsory problem-solving. 4. Independent study. |
| Teaching support |
Assistant teachers will give professional guidance in groups. There are also fixed times when students can discuss different problems with the teacher responsible. |
| Examiner |
The examiner will participate if there is an oral examination. The examiner will ensure that the written examination, if there is one, is of good quality, and he or she will also assess the answers from a selection of candidates to ensure the right level. |
| Entrance requirements |
Special requirements in Science
|
| |
|
| Note |
|
| - |
| |
|
| Objective of course |
|
1. Be familiar with database handling systems and the theoretical foundation. 2. Master methods and techniques used for structuring data. 3. Be able to model databases and implement models in a relevant database environment. 4. Use language for describing data definitions and operations of databases. 5. Use tools in a client/server environment. After completing the course, students should be able to develop simple database solutions of high quality and have sufficient fundamental knowledge to be able to further develop different solutions. The student should also have been given a theoretical foundation for further studies of databases and related subject fields. Great emphasis is placed on gaining knowledge and understanding of the course through practical exercises. It is important for the further studies of the student to gain a basic understanding of the many applications in different subject fields and different levels of study of database technology. In the course the student is to gain skills through practical exercises that are related to the subject. The student is to have acquired sufficient knowledge to be able to develop database systems with different types of programming tools. Understanding the use of programming tools makes the student capable of implementing different methods for solving problems concerning databases. An important skill learned is the ability to use database technology in different subject fields in his or her studies. This will help the student to see the whole picture and be able to select technology to structure scientific work and make it more efficient. Learning some database technology gives the student a better opportunity to be able to judge advantages and disadvantages of the influence of information technology on the individual. |
| |
|
| Course contents |
|
| The course is under constant development due to the nature of technology and its development. The basic topics of the course are: 1. Introduction to databases. 2. Database environment. 3. The Relational Model. 4. Relational algebra. 5. SQL. 6. ER-Model and modelling. 7. Normalisation. 8. Databases and Internet. 9. Transactions and Concurrency. See the course web pages for updated information. |
| |
|
| Syllabus |
|
| Will be announced at the beginning of the course. |
| |
| Last updated |
2012-04-13 |
|
|
|