•   Database Programming ELA18PR02-3004 06.03.2023-30.04.2023  3 credits  (ELA21D-V) +-
    Competence objectives of the study unit
    The student can perform practical database modeling.
    The student can program applications in multi-user environments that read and write relational databases.
    The student can use a framework for database programming.
    Prerequisites
    Courses: Object Oriented Programming, Database Technology
    Content of the study unit
    Rehearsal of SQL
    Database applications with SqlServer, C # and ADO.NET
    Objects of the type: Connections Commands, Parameters and DataReaders
    Transaction Management
    Objects of the types: DataSets, DataAdapters and CommandBuilders
    Object Relational Mapping (ORM)
    Introduction to LINQ and Entity Framework
    Data in xml and json format.
    Assessment criteria
    Failed (0)
    Studeranden uppnår inte kunskaper som motsvarar vitsordet tillfredsställande. (not translated)
    Assessment criteria – satisfactory (1-2)
    The student understands the basic theories of the relational model and can realize a relational model as a physical database.
    The student can program simple database applications that read and write a database, and can use parameterized commands.
    The student knows a framework for reading and writing databases.
    Assessment criteria – good (3-4)
    The student can create simpler conceptual, logical and physical database models.
    The student can program database applications using Object Relational Mapping.
    The student can implement transaction management in his code.
    The student knows about security risks and knows how the risks are handled in program code.
    The student can use a framework to read and write databases.
    Assessment criteria – excellent (5)
    The student can create advanced conceptual, logical and physical database models.
    The student can encode different types of applications that reuse code for data management.
    The student can use a framework for versatile reading and writing of databases.
    Name of lecturer(s)

    Susanne Österholm

    Learning material

    material på Moodle (not translated)

    Learning methods

    föreläsningar, datasalsövningar (not translated)

    Objects, timing and methods of assessment

    tentamen 2/3
    inlämningsuppgift 1/3 (not translated)

    Teaching language

    Swedish

    Timing

    06.03.2023 - 30.04.2023

    Enrollment date range

    01.12.2022 - 05.03.2023

    Group(s)
    • ELA21D-V
    Responsible unit

    Faculty of Technology and Seafaring

    Small group(s)
    • ELA21-I (Size: 30.
    Teachers and responsibilities

    Susanne Österholm

    Degree Programme(s)

    Degree Programme in Electrical Engineering and Automation

    Campus

    Vasa, Wolffskavägen 33

    Assessment scale

    H-5

    Alternative methods of attainment for implementation

    godkänd tentamen
    godkänd inlämningsuppgift (not translated)

    Exam dates and retake possibilities

    tentamen maj 2023
    omtentamen 1 maj-juni 2023
    omtentamen 2 augusti-september 2023 (not translated)

    Timing and attendance

    våren 2023, Vasa (not translated)

    Student's schedule and workload

    närundervisning ca 35 h, eget arbete ca. 45 h (not translated)

    Assessment criteria
    Failed (0)

    Studeranden uppnår inte kunskaper som motsvarar vitsordet tillfredsställande. (not translated)

    Assessment criteria – satisfactory (1-2)

    Studeranden kan producera kod med programmeringsspråket C# som läser och skriver en databas samt kan använda parametriserade kommandon. (not translated)

    Assessment criteria – good (3-4)

    Studeranden kan producera objektorieterad kod med programmeringsspråket C# som läser och skriver en databas samt kan använda parametriserade kommandon samt implementera transaktionshantering. (not translated)

    Assessment criteria – excellent (5)

    Studeranden kan producera kod med Object-Relational-Mapping som läser och skriver en databas samt kan använda parametriserade kommandon samt implementera transaktionshantering. Studeranden kan använda ramverket Entity Framework för detta. (not translated)