Software Engineering: Programming, Databases and Digitalization
Syllabus, Bachelor's level, 2IS243
- Code
- 2IS243
- Education cycle
- First cycle
- Main field(s) of study and in-depth level
- Technology G1F
- Grading system
- Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
- Finalised by
- The Department Board, 25 February 2021
- Responsible department
- Department of Informatics and Media
Entry requirements
30 credits in the Bachelor's Programme in Industrial Engineering and Development. Completed course Introduction to Software Engineering.
Learning outcomes
Regarding knowledge and understanding the student is expected to be able to on completion of the
course:
- account for basic concepts regarding programming, databases, and digitalisation,
- account for technologies and models for design of a database,
- describe basic concepts relevant to object-orientation and error handling,
- describe laws and regulations regarding data storage and personal integrity.
Regarding competence and skills the student is expected to be able to on completion of the course:
- design data models based on business needs,
- analyse a conceptual data model and based on that implement a relational database,
- design a relational database and also insert, change and search data from the database,
- improve database design by applying normalisation.
- implement basic algorithms and simple structured object orienter programs,
- document and explain their own and others code.
Regarding judgement and approach the student is expected to be able to on completion of the
course:
- evaluate the quality of data models and programming solutions given different criteria,
- reflect on how the use of databases, data storage and digitalisation can affect an individual, organisation, and society from a social sustainability perspective.
Content
The course covers how structured object-oriented programs. To achieve this, the course covers concepts such as variable, method, selection, iteration and basic algorithms. The course also provides an introduction to object- orientation, where classes, objects, inheritance and composition are central. The theoretical concepts continuously applied in exercises and laboratory sessions.
The course gives an introduction to databases with a focus on design of relational databases. The course includes conceptual data modelling based on ER-diagram and design of databases and work with storing and fetching of data in relational databases with the Structured Query Language (SQL). The course also deals with how the database manager provides services as well as maintains data integrity.
Further, the course deals with safety and the risks with data storage based on both relevant sections of the law and ethical aspects. The course also addresses how the design and use of different forms of databases and data storage affect individuals, organisations and society with a focus on social sustainability.
Instruction
The course is given in the form of lectures, laboratory work, exercises and seminars.
Assessment
The course is examined through laboratory work, assignments, and written exam.
If there are special reasons for doing so, an examiner may make an exception from the method of assessment indicated and allow a student to be assessed by another method. An example of special reasons might be a certificate regarding special pedagogical support from the University's disability coordinator or a decision by the department's working group for study matters.