EBA 3420 Databases

EBA 3420 Databases

Course code: 
EBA 3420
Department: 
Data Science and Analytics
Credits: 
7.5
Course coordinator: 
Magdalena Ivanovska
Course name in Norwegian: 
Databases
Product category: 
Bachelor
Portfolio: 
Bachelor of Data Science for Business - Programme Courses
Semester: 
2023 Spring
Active status: 
Active
Level of study: 
Bachelor
Teaching language: 
English
Course type: 
One semester
Introduction

The course provides a hands-on introduction to using SQL databases and covers the basics of database modelling and design. Throughout the course we use dynamic webpages as an example application, which allows us to work with data extraction from databases and data input from webpages, as well as to present data from databases through online pages showing key numbers and graphs. A blended learning-by-doing approach is taken throughout the course. The course aims at being a general introduction to applied work with databases, illustrated through a simple application field. This means that, for example, webpage design is kept to an extreme minimum, and the technical focus is instead on themes that are of general value in the industry.

Learning outcomes - Knowledge

During the course students shall:

  • Acquire the basics of the relational database model and the main principles and techniques of database modelling.
  • Develop understanding for the syntax and semantics of SQL and its use for database management in relational databases.
  • Acquire understanding of how information moves from one data source to another.
  • Understand the architecture of database-driven web applications.
Learning outcomes - Skills

After completed course students will be able to:

  • Use SQL to retrieve, define, and manipulate data in a relational database.
  • Design and implement a simple database.
  • Connect to and use a relational database with Python programming language.
  • Develop basic web applications that use relational databases.
General Competence

The course will strengthen the analytical abilities of the students and improve their technical skills and general information literacy. The students will improve their understanding of how the modern information-driven society functions from a technical perspective, and how databases are essential to many industries. The students will gain experience in working in teams on technical problems, and will understand the possibilities and risks associated with digitally stored information as they will gain hands-on experience on how easy it now is to process, extract and present individual-level details from big datasets.

Course content
  • Introduction to relational databases.
  • SQL for defining, manipulating, and querying a database. 
  • Basics of database modelling and design: ER diagrams and normalization. 
  • Accessing and analysing data from a database with Python. 
  • Introduction to web programming.
  • The basics of dynamic webpages, implemented using Python and SQL.
  • Frameworks for database-driven web applications.
  • Using web applications to collect, store, analyse, and visualise data from web forms.
Teaching and learning activities

The course consists of 72 hours and will be a combination of lectures and web-resources, and a high emphasis on student projects done under supervision.

Software tools
Software defined under the section "Teaching and learning activities".
Qualifications

Higher Education Entrance Qualification

Disclaimer

Deviations in teaching and exams may occur if external conditions or unforeseen events call for this.

Required prerequisite knowledge

EBA3400 or equivalent knowledge or background in Python programming.

Assessments
Assessments
Exam category: 
Submission
Form of assessment: 
Written submission
Weight: 
70
Grouping: 
Group (1 - 3)
Duration: 
2 Week(s)
Comment: 
All exams must be passed to obtain a final grade in the course.
Exam code: 
EBA 34201
Grading scale: 
ECTS
Resit: 
Examination every semester
Exam category: 
Submission
Form of assessment: 
Written submission
Invigilation
Weight: 
30
Grouping: 
Individual
Support materials: 
  • Bilingual dictionary
Duration: 
2 Hour(s)
Comment: 
27/09/2022 School exam - Will be changed to a home exam with the same duration if a third-party program for writing and running code is still not available in WiseFlow spring 2023.
All exams must be passed to obtain a final grade in the course.
Exam code: 
EBA 34202
Grading scale: 
ECTS
Resit: 
Examination every semester
Type of Assessment: 
Ordinary examination
All exams must be passed to get a grade in this course.
Total weight: 
100
Student workload
ActivityDurationComment
Teaching
42 Hour(s)
Seminar groups
30 Hour(s)
Problem solving in class using SQL

Ved godkjenning av studieplanen med utkast til kursbeskrivelser, Undervisningsutvalget 27.09.2018, sto om dette kurset følgende om ressursbruk:

"Blended learning, with a few lectures/web-resources, but with a high emphasis on student projects done under supervision. Note this requires more teaching resources than standard lecturing, but is absolutely necessary: there is not much theory, the emphasis on the course is on doing".

Godkjent av Dean Lars Olsen 23.04.2019.
Student's own work with learning resources
86 Hour(s)
Examination
42 Hour(s)
One group asssignment and an individual written exam. Approxemately 42 hours in total.
Sum workload: 
200

A course of 1 ECTS credit corresponds to a workload of 26-30 hours. Therefore a course of 7,5 ECTS credit corresponds to a workload of at least 200 hours.