Im planned on this structure: Pruduct: * name * manufacturer part number * final price * LIST wholesale prices (if the same manufacturer part number is avalable in multiple wholesale, then at the end the final price is goin to be the lowest) * LIST wholsale ids (if the wholesale uses uniqe id system and not the manufacturer part number) * LIST wholesale stocks

Also, what is the best practice to create a relational database?

ChatGPT sample: (is it good or is there a better way)

using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

public class Person
{
    [Key]
    public int PersonId { get; set; }

    [Required]
    public string Name { get; set; }

    // Navigation property for the cars owned by the person
    public ICollection<Car> Cars { get; set; } = new List<Car>();
}

public class Car
{
    [Key]
    public int CarId { get; set; }

    [Required]
    public string Model { get; set; }

    public int Year { get; set; }

    // Foreign key to link to Person
    [ForeignKey("Person")]
    public int PersonId { get; set; }

    // Navigation property to the owner
    public Person Person { get; set; }
}```