sql - Question about creating table, relation and cardinality

Question

I have a problem creating a database (I am still learning). I need to create a database for a company that generates a report like the one in the image.

Report to reply

I have the tables created as follows, but I have a problem in the t_stack with the t_tracking_number.

DB model and Relationship

The part that I don′t know how to do, is create the t_stack table, to register an id_stack, an id_driver, and then insert many tracking_numbers. at this moment according to the image, I should register for every track_number, an id_stack and an id_driver.

If someone can give me an idea of ??how to do it, or if I must change whatever in the database it doesn't matter. Sorry if I didn't make myself clear, this is my first project and I want to do my best.
Thank you.

question from:https://stackoverflow.com/questions/65649723/question-about-creating-table-relation-and-cardinality

Answer 1

You have to add in your t_stack table an id (ID_stack), identity increment as a PrimaryKey. Then you can have all tracking_numbers and combinations you need.