Databases and modelling

ECTS Credits

10

Level of Study

Bachelor

Full-time/Part-time

Full-time

Teaching semester

Spring

Objectives and Content

Objectives and Content

Objectives
The course provides an introduction to methods for organizing, structuring, representing and storing large amounts of information.

Contents
The main emphasis lies on techniques for data modeling, as well as the theory for relational databases. Other important topics are relational algebra, query language, storage media and storage methods. The privacy aspects are addressed in the context of collecting and processing data.

Learning Outcomes

Learning Outcomes
On completion of the course, the student:

Knowledge

• has knowledge of the query language SQL,
• has knowledge of data modeling and ER diagrams,
• can explain important principles of database design,
• can explain the most important parts of relational algebra,
• has knowledge of database administration and database applications,
• has knowledge of the Personal Data law and can discuss ethical aspects of data handling and privacy.

Skills

• can use the query language SQL,
• can use data modeling to propose sensible data structures based on unstructured information about a given problem area,
• can use such data structures using a database tool,
• can design relational databases,
• can create simple web applications.

General competence

• has insight into relevant professional and ethical issues,
• can plan and carry out database projects in teams and in line with ethical requirements and guidelines,
• can convey key subject matter both in writing, orally and through other relevant forms of expression, and
• can exchange views and experiences with others with a background within the subject area and through this contribute to good practice.

Required Previous Knowledge

None

Recommended Previous Knowledge

INF100. INF101 should be taken in parallell.

Credit Reduction due to Course Overlap

INFO122: 5 ECTS

INFO125: 5 ECTS

Access to the Course

Access to the course requires admission to a programme of study at The Faculty of Mathematics and Natural Sciences.

Teaching and learning methods

Up to 6 hours each week for 13 weeks alternating between lectures and time for software projects, in addition 2 hours per week for exercises and team supervision. Expect a total workload in excess of 270 study hours including assignments and self-study.

Compulsory Assignments and Attendance

Project team work and presentations must be passed. Presence at compulsory lectures.

Compulsory assignments are valid for two subsequent semesters.

Forms of Assessment

Written exam (3 hours).

Results from project work and presentations may be taken into account.

Examination Support Material

Legal exam aids will be announced at the start of every semester.

Grading Scale

The grading scale used is A to F. Grade A is the highest passing grade in the grading scale, grade F is a fail.

Assessment Semester

Examination both spring semester and autumn semester. In semesters without teaching the examination will be arranged at the beginning of the semester.

Reading List

The reading list will be available within June 1st for the autumn semester and December 1st for the spring semester.

Course Evaluation

The course will be evaluated by the students in accordance with the quality assurance system at UiB and the department.

Programme Committee

Programstyret har ansvar for fagleg innhald og oppbygging av studiet og for kvaliteten på studieprogrammet og alle emna der.

Course Coordinator

Course coordinator and administrative contact person can be found on Mitt UiB, or contact studieveileder@ii.uib.no

Course Administrator

The Faculty of Mathematics and Natural Sciences represented by the Department of Informatics is the course administrator for the course and study programme.