Databases and modelling

Undergraduate course

Course description

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.

Full-time/Part-time

Full-time

ECTS Credits

10

Level of Study

Bachelor

Semester of Instruction

Spring
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.

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.
Examination Support Material
Legal exam aids will be announced at the start of every semester.
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 Student adviser
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.