Data Modelling and Back-end Development (5op)

Tavoitteet

Osaat suunnitella, dokumentoida ja toteuttaa tietokannan, palvelinpuolen ohjelmiston sekä siihen liittyvän sovellusrajapinnan skaalautuvaa sovellusta varten.

Sisältö

- Advanced data modelling (conceptual and logical data model)
- Back-end architecture
- Back-end frameworks
- Server-side programming languages
- Scalability
- Application programming interfaces and integration
- Security settings and hack prevention

Oppimateriaalit

There is no public learning material (books, articles, videos, etc.) that are required for passing the course (‘must know’).

Opetusmenetelmät

Project-based learning and online pedagogy: lectures/online lectures, exercises/learning assignments, various methods of online pedagogy (flipped learning)

Opiskelijan ajankäyttö ja kuormitus

One ECTS ~ 27 hours of work. Lectures: 24 h, exercises and assignments: 110 h, code review: 1 h. Total: 135 h.

Arviointikriteerit, tyydyttävä (1)

The assessment is based on 1) Data modelling assignment (20%) and 2) Back-end assignment (80%). The assessment focuses on the following:
1) Data modelling: you can design a conceptual and logical data model (comprising approximately five entities/tables) by applying standard data modelling and design techniques based upon an understanding of requirements (the models may contain some errors, omissions, and/or inconsistencies)
2) Back-end development
- complexity: only a simple back-end solution is presented
- knowledge base and the structure of the implementation: only the knowledge base is presented
- choice of framework and libraries: only the core framework is used
- realisation of the project contains errors, omissions, and/or inconsistencies
- results and their analysis are vague or missing
- reporting and presentation: incomplete (no presentation)

Arviointikriteerit, hyvä (3)

The assessment is based on 1) Data modelling assignment (20%), and 2) Back-end assignment (80%). The evaluation focuses on the following:
1) Data modelling:
- you can design a conceptual and logical data model comprising at least five entities (tables)
- the models are clear, contain metadata, but may contain minor errors, omissions, and/or inconsistencies
2) Back-end development
- complexity: back-end solution contains several endpoints
- choice of framework and libraries: more than one framework or software library is used
- knowledge base and the structure of the implementation show more than just basic knowledge
- realisation of project work is nearly error-free
- results are reported shortly, and their analysis is missing or incomplete
- reporting and presentation may be short and/or quick

Arviointikriteerit, kiitettävä (5)

The assessment is based on 1) Data modelling assignment (20%) and 2) Back-end assignment (80%). The assessment focuses on the following:
1) Data modelling:
- you can design a conceptual and logical data model comprising at least five entities (tables)
- the models are detailed, clear, complete, error-free, and contain metadata
2) Back-end development
- complexity: back-end solution contains several endpoints
- well-argumented choice of framework(s) and libraries
- knowledge base and the structure of the implementation is clear
- realisation of the project work: complete, error-free, consistent
- results and their analysis: in-depth and thorough
- reporting and presentation are excellent

Arviointikriteeri, hyväksytty/hylätty

Pass: You demonstrate skills and knowledge of designing and implementing a back-end solution containing a database, server-side software, and related application programming interface. The results are evaluated during a code and data model review.

Esitietovaatimukset

Tietokantojen perusteet
JavaScript-ohjelmoinnin perusteet

Lisätiedot

Avoin AMK 5