Could you tell how you created and structured the data model in your previous project?

In one of my projects, I created a data model for an order management system. First, I analyzed the requirements and identified the main entities: Order, Customer, Product.

Then, I defined the fields and data types for each entity, considering the relationships between them. For example, Order contained a reference to Customer and a list of Product with quantities.

To structure the model, I used an object-oriented approach with classes and one-to-many and many-to-many relationships. In the database, this was reflected through tables with foreign keys.

Example in Java:

class Customer {
    Long id;
    String name;
    List<Order> orders;
}

class Order {
    Long id;
    Customer customer;
    List<OrderItem> items;
}

class OrderItem {
    Product product;
    int quantity;
}

class Product {
    Long id;
    String name;
    double price;
}

This approach provided a clear data structure and ease of working with it in the application.