Course template
Order system with user DB implementation
This project deals with the development of an order system that gradually includes the administration of articles, customers and orders. It conveys basic database operations, price calculations, invoice creation as well as the analysis and visualization of sales data.
Didactic objective
This course template gradually leads to the implementation of an order system, in which article data is processed, customers are managed, and orders are stored and evaluated. In this process, central concepts such as object-oriented modeling, data persistence via API and data-based evaluation are linked in a cohesive application scenario. The sequence supports the systematic connection of data model, service structure and implementation by building each extension on the previous component. From a technical perspective, the template is located in the area of modeling and implementing application-oriented information systems.
Competence focal points
- Load article data from an API, transfer it to class objects, and output it in a structured manner.
- Convert prices from string formats to numerical values and implement category-dependent price calculations.
- Model customer data as objects, generate them randomly, and store them persistently in a user database.
- Combine orders with customer and article data, including quantities and date values, and save them as data sets.
- Load data specifically via filter queries and combine it from multiple sources for invoice generation.
- Aggregate profits by category and day, and output them in tabular reports.
- Visualize aggregated key figures in line and bar charts and scale values to fixed pixel ranges.
Structure of the modules
Order system: article management
This module establishes the data basis by loading articles from an API, object modeling, and category-dependent price calculation for a sorted console output.
Order system: customer management
This module extends the system with a customer model and a service layer that generates random data and persistently manages customers via an API-based user database.
Order system: generating orders
This module connects article and customer data by generating orders with positions, quantities, and dates, and storing them in a collection of the user database for filtering and reading.
Order System: Invoice Creation
This module focuses on targeted reloading of individual data sets per query, bringing order, customer, and article together into a consistently formatted invoice for console output.
Order System: Evaluations and Reports
This module develops an evaluation logic that aggregates orders from a month, providing profit and order numbers per category and per day as tabular reports.
Order System: Data Visualization with Charts
This module visualizes the previously aggregated evaluations as line diagrams and bar charts, handling the scaling of key figures to fixed graphic areas.
Through the clearly defined modules, learning objectives, data flows, and evaluations can be transparently integrated into a lesson series and professionally justified.
Use the demo access to test the template and adapt the modules to framework conditions and student groups.