Databases and modelling
Undergraduate course
- ECTS credits
- 10
- Teaching semesters
- Spring
- Course code
- INF115
- Number of semesters
- 1
- Teaching language
- Norwegian.
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
ECTS Credits
Level of Study
Semester of Instruction
Required Previous Knowledge
Credit Reduction due to Course Overlap
INFO122: 5 ECTS
INFO125: 5 ECTS
Access to the Course
Teaching and learning methods
Compulsory Assignments and Attendance
Project team work and presentations must be passed. Presence at compulsory lectures.
The course will have compulsory assignments. The assignments are valid two semesters: the semester when they are approved and the succeeding semester.
Forms of Assessment
Portfolio assessment. The portfolio consist of hand-ins and written on-campus exam (3 hours).
Hand-ins and on-campus exam must be passed as both elements assess the course's learning outcome. The weighting is announced on Mitt UiB at the start of the semester. In semester with no teaching, the exam will be early in the semester. The results from portfolio will be included.