Data Modelling and Back-end DevelopmentLaajuus (5 cr)
Code: YTSP0200
Credits
5 op
Teaching language
- English
Responsible person
- Jouni Huotari
- Pasi Manninen
Objective
Student is able to design, document and implement a database, server-side software, and related application programming interface for a scalable application.
Content
- Advanced data modelling:
- Back-end architecture
- Back-end frameworks
- Server-side programming languages
- Scalability
- Application programming interfaces and integration
- Security settings and hack prevents
Qualifications
Basics of databases
Basics of JavaScript programming
Assessment criteria, satisfactory (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:
- the student can design a conceptual and a logical data model (comprising of approximately 5 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 basic knowledge base is presented
- choice of the framework and libraries: only the core framework is used
- realisation of the project work: contains errors, omissions, and/or inconsistencies
- results and their analysis are vague or missing
- reporting and presentation: incomplete (no presentation)
Assessment criteria, good (3)
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:
- the student can design a conceptual and a logical data model comprising of at least 5 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 contain several end-points
- choice of the framework and libraries: more than one framework or software library is used
- knowledge base and the structure of the implementation shows more than just a basic knowledge
- realisation of the project work is nearly error-free
- results are reported shortly and their analysis might be missing or incomplete
- reporting and presentation may be short and/or quick
Assessment criteria, excellent (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:
- the student can design a conceptual and a logical data model comprising of at least 5 entities (tables)
- the models are detailed, clear, complete containing metadata, and error-free
2) Back-end development
- complexity: back-end solution contain several end-points
- well-argumented choice of the framework 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 is excellent
Assessment criteria, approved/failed
Pass: The student demonstrates skills and knowledge of designing and implementing a back-end solution containing a database, server-side software, and related application programming interface. The result is evaluated during a code and data model review.
Enrollment
20.11.2023 - 04.01.2024
Timing
08.01.2024 - 30.04.2024
Number of ECTS credits allocated
5 op
Virtual portion
3 op
RDI portion
3 op
Mode of delivery
40 % Contact teaching, 60 % Distance learning
Unit
School of Technology
Teaching languages
- English
Seats
20 - 35
Degree programmes
- Master's Degree Programme in Information Technology, Full Stack Software Development
Teachers
- Jouni Huotari
- Pasi Manninen
- Juha Saukkonen
Groups
-
YTS23S1Master of Engineering, Degree Programme in Information Technology, Full Stack Software Development
Objective
Student is able to design, document and implement a database, server-side software, and related application programming interface for a scalable application.
Content
- Advanced data modelling:
- Back-end architecture
- Back-end frameworks
- Server-side programming languages
- Scalability
- Application programming interfaces and integration
- Security settings and hack prevents
Materials
There is no public learning material (books, articles, videos, etc.) that are required for passing the course (‘must know’). Course material is located in the GitLab / LabraNet service.
Teaching methods
Project-based learning and online pedagogy: lectures/online lectures, exercises/learning assignments, various methods of online pedagogy (flipped learning)
Completion alternatives
RPL is in use: the student can show an existing solution made by him- or herself.
Student workload
One ECTS ~ 27 hours of work. Lectures: 23 h, exercises and assignments: 110 h, data model and code review: 1 + 1 h. Total: 135 h.
Content scheduling
The course is held during every spring.
Further information
The assessment is based on the code and data model review.
Evaluation scale
0-5
Assessment criteria, satisfactory (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:
- the student can design a conceptual and a logical data model (comprising of approximately 5 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 basic knowledge base is presented
- choice of the framework and libraries: only the core framework is used
- realisation of the project work: contains errors, omissions, and/or inconsistencies
- results and their analysis are vague or missing
- reporting and presentation: incomplete (no presentation)
Assessment criteria, good (3)
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:
- the student can design a conceptual and a logical data model comprising of at least 5 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 contain several end-points
- choice of the framework and libraries: more than one framework or software library is used
- knowledge base and the structure of the implementation shows more than just a basic knowledge
- realisation of the project work is nearly error-free
- results are reported shortly and their analysis might be missing or incomplete
- reporting and presentation may be short and/or quick
Assessment criteria, excellent (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:
- the student can design a conceptual and a logical data model comprising of at least 5 entities (tables)
- the models are detailed, clear, complete containing metadata, and error-free
2) Back-end development
- complexity: back-end solution contain several end-points
- well-argumented choice of the framework 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 is excellent
Assessment criteria, approved/failed
Pass: The student demonstrates skills and knowledge of designing and implementing a back-end solution containing a database, server-side software, and related application programming interface. The result is evaluated during a code and data model review.
Qualifications
Basics of databases
Basics of JavaScript programming
Enrollment
01.11.2022 - 05.01.2023
Timing
09.01.2023 - 28.04.2023
Number of ECTS credits allocated
5 op
Virtual portion
4 op
Mode of delivery
20 % Contact teaching, 80 % Distance learning
Unit
School of Technology
Campus
Lutakko Campus
Teaching languages
- English
- Finnish
Seats
0 - 35
Degree programmes
- Master's Degree Programme in Information Technology, Full Stack Software Development
Teachers
- Jouni Huotari
- Pasi Manninen
Groups
-
ZJAYTS22S1Avoin amk, Full Stack Software Development , Monimuoto
-
YTS22S1Master of Engineering, Degree Programme in Information Technology, Full Stack Software Development
Objective
Student is able to design, document and implement a database, server-side software, and related application programming interface for a scalable application.
Content
- Advanced data modelling:
- Back-end architecture
- Back-end frameworks
- Server-side programming languages
- Scalability
- Application programming interfaces and integration
- Security settings and hack prevents
Materials
There is no public learning material (books, articles, videos, etc.) that are required for passing the course (‘must know’).
Course material in located in the GitLab / LabraNet service.
Teaching methods
Project-based learning and online pedagogy: lectures/online lectures, exercises/learning assignments, various methods of online pedagogy (flipped learning)
Completion alternatives
RPL is in use: the student can show an existing solution made by him- or herself.
Student workload
One ECTS ~ 27 hours of work. Lectures: 23 h, exercises and assignments: 110 h, data model and code review: 1 + 1 h. Total: 135 h.
Content scheduling
The course is held during every spring.
Further information
The assessment is based on the code and data model review.
Evaluation scale
0-5
Assessment criteria, satisfactory (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:
- the student can design a conceptual and a logical data model (comprising of approximately 5 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 basic knowledge base is presented
- choice of the framework and libraries: only the core framework is used
- realisation of the project work: contains errors, omissions, and/or inconsistencies
- results and their analysis are vague or missing
- reporting and presentation: incomplete (no presentation)
Assessment criteria, good (3)
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:
- the student can design a conceptual and a logical data model comprising of at least 5 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 contain several end-points
- choice of the framework and libraries: more than one framework or software library is used
- knowledge base and the structure of the implementation shows more than just a basic knowledge
- realisation of the project work is nearly error-free
- results are reported shortly and their analysis might be missing or incomplete
- reporting and presentation may be short and/or quick
Assessment criteria, excellent (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:
- the student can design a conceptual and a logical data model comprising of at least 5 entities (tables)
- the models are detailed, clear, complete containing metadata, and error-free
2) Back-end development
- complexity: back-end solution contain several end-points
- well-argumented choice of the framework 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 is excellent
Assessment criteria, approved/failed
Pass: The student demonstrates skills and knowledge of designing and implementing a back-end solution containing a database, server-side software, and related application programming interface. The result is evaluated during a code and data model review.
Qualifications
Basics of databases
Basics of JavaScript programming
Enrollment
01.11.2021 - 09.01.2022
Timing
10.01.2022 - 31.05.2022
Number of ECTS credits allocated
5 op
Virtual portion
4 op
RDI portion
1 op
Mode of delivery
20 % Contact teaching, 80 % Distance learning
Unit
School of Technology
Campus
Lutakko Campus
Teaching languages
- English
Seats
0 - 35
Degree programmes
- Master's Degree Programme in Information Technology, Full Stack Software Development
Teachers
- Jouni Huotari
- Pasi Manninen
Teacher in charge
Jouni Huotari
Groups
-
YTS21K1Master's Degree Programme in Information Technology, Full Stack Software Development
Objective
Student is able to design, document and implement a database, server-side software, and related application programming interface for a scalable application.
Content
- Advanced data modelling:
- Back-end architecture
- Back-end frameworks
- Server-side programming languages
- Scalability
- Application programming interfaces and integration
- Security settings and hack prevents
Materials
There is no public learning material (books, articles, videos, etc.) that are required for passing the course (‘must know’). The lectures are recorded beforehand and all the material resides in https://ytsp0200.pages.labranet.jamk.fi/.
Teaching methods
Project-based learning and online pedagogy: lectures/online lectures, exercises/learning assignments, various methods of online pedagogy (flipped learning)
Completion alternatives
There are mandatory assignments in two topics: 1) Data modelling, and 2) Back-end development. If you already have the required skills, you can ask the teachers to participate 1) a model review and/or 2) back-end code review.
Student workload
One ECTS ~ 27 hours of work. Lectures: 24 h, exercises and assignments: 110 h, code review: 1 h. Total: 135 h.
Further information
This course is aimed for the students participating the second year of the Full Stack Software Development programme.
Evaluation scale
0-5
Assessment criteria, satisfactory (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:
- the student can design a conceptual and a logical data model (comprising of approximately 5 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 basic knowledge base is presented
- choice of the framework and libraries: only the core framework is used
- realisation of the project work: contains errors, omissions, and/or inconsistencies
- results and their analysis are vague or missing
- reporting and presentation: incomplete (no presentation)
Assessment criteria, good (3)
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:
- the student can design a conceptual and a logical data model comprising of at least 5 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 contain several end-points
- choice of the framework and libraries: more than one framework or software library is used
- knowledge base and the structure of the implementation shows more than just a basic knowledge
- realisation of the project work is nearly error-free
- results are reported shortly and their analysis might be missing or incomplete
- reporting and presentation may be short and/or quick
Assessment criteria, excellent (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:
- the student can design a conceptual and a logical data model comprising of at least 5 entities (tables)
- the models are detailed, clear, complete containing metadata, and error-free
2) Back-end development
- complexity: back-end solution contain several end-points
- well-argumented choice of the framework 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 is excellent
Assessment criteria, approved/failed
Pass: The student demonstrates skills and knowledge of designing and implementing a back-end solution containing a database, server-side software, and related application programming interface. The result is evaluated during a code and data model review.
Qualifications
Basics of databases
Basics of JavaScript programming