Introduction to Programming and Databases
Programmeringsteknik och databaser, grundkurs

EDAA90, 9.0 credits, G1 (First Cycle)

Valid for: 2024/25
Faculty: Faculty of Engineering LTH
Decided by: PLED C/D
Date of Decision: 2024-04-16
Effective: 2024-05-08

General Information

Main field: Technology Depth of study relative to the degree requirements: First cycle, in-depth level of the course cannot be classified
Mandatory for: L1
Language of instruction: The course will be given in Swedish

Aim

The goal of the course is to give students an introduction to programming, especially as a way to solve problems from different application areas. The focus is on programming skills with problem solving and step-by-step development. The students shall also gain basic practical knowledge of relational databases.

Learning outcomes

Knowledge and understanding
For a passing grade the student must

• explain basic concepts in imperative and object-oriented programming
• explain and give examples of the use of basic data types and simple algorithms
• choose basic data types appropriate for solving given problems
• interpret (well-written) program code to correctly describe what happens when it is executed
• use ER models and UML notations to describe smaller information systems
• use the SQL query language to retrieve information from databases

Competences and skills
For a passing grade the student must

• independently implement programs to solve problems in different application domains
• independently create algorithms that use basic data types and collections (lists, sets and key-value tables)
• construct program code, given a simpler algorithm formulated in human language
• construct and structure programs consisting of several classes, methods and functions
• incrementally develop, test and debug programs
• use a database manager to implement a simple database

Judgement and approach
For a passing grade the student must

• assess which basic data types and algorithms are suitable for solving different problems
• evaluate existing code to find and fix simple programming errors

Contents

• Basic program constructs such as functions, iteration, and conditional statements.
• Basic values and types such as integers, floats, booleans, and strings.
• Variables and assignment.
• Basic data types for composite values, such as lists, tuples, sets, and key-value tables.
• Input, printing and files.
• Simple algorithms for searching, sorting and the like.
• Using existing libraries and classes.
• Basic knowledge of object-oriented programming, classes and methods.
• Orientation on inheritance.
• Basic execution model with function calls, parameter passing, objects and method calls
• Basic programming methodology with step-by-step development, testing and debugging
• Basic use of programming tools
• Introduction to databases
• Basic knowledge of the relational model, SQL, ER- and UML-diagrams
• Python 3 is used as the programming language.

Examination details

Grading scale: TH - (U, 3, 4, 5) - (Fail, Three, Four, Five)
Assessment: For final grades, passed database assignments, passed programming assignments and a passed exam are required. In order to participate in the exam, passed programming assignments are required. The final grade for the course is based on the grade of the exam.

The examiner, in consultation with Disability Support Services, may deviate from the regular form of examination in order to provide a permanently disabled student with a form of examination equivalent to that of a student without a disability.

Modules
Code: 0123. Name: Exam.
Credits: 3.0. Grading scale: TH - (U, 3, 4, 5). Assessment: Approved examination. The module includes: Written digital examination.
Code: 0223. Name: Programming Assignments.
Credits: 4.5. Grading scale: UG - (U, G). Assessment: Approved programming assignments. The module includes: Programming assignments
Code: 0323. Name: Introduction to Databases.
Credits: 1.5. Grading scale: UG - (U, G). Assessment: Approved database assignments The module includes: Database assignments.

Admission

The number of participants is limited to: No
Kursen överlappar följande kurser: EDAA20 EDA010 EDA015 EDA016 EDA017 EDA390 EDA500 EDA501 EDA616 EDA618 EDAA10 EDAA50 EDAA55 EDAA65 EDAA45 EDAA70 EDAA80 EDAA85

Reading list

• Allen B. Downey: Think Python - How to Think Like a Computer Scientist. O'Reilly, 2015, ISBN: 9781491939369. E-book available at https://greenteapress.com/wp/think-python-2e.

Contact

Course coordinator: Patrik Persson, patrik.persson@cs.lth.se
Course homepage: https://cs.lth.se/edaa90/