Data Organization/Schema Question

Good Day,

I'm new to c# and database programming and I've run into a technical problem and would like to get some input.

My project is using c# (obviously) with MariaDB on the network.

I'm in the early stages of the application.

My issue is, I have a form that collects Customer Information (Name , # , email etc) and puts it into a table/db.

However, some Customers have agreements (Name, #, date etc) with them.

I don't want to create one big table, since I don't know how many agreements some customers have, some have zero, others have 20 or more.

So I thought about creating an associated table, and I would join the records using an INNER Join Query.

But I'm thinking that might not work because all agreements are uniqure to individual customers.

So I was wondering what is the best way to collect and store the agreements for each customer. Is the associated table still the best way to go? Or should I just have a seperate agreements table and query it for customer name or Id each time instead?

Thank you for any input.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ashutosh Gupta6y ago
Accepted answer
Multiple ways to achieve it 1. As you mentioned create agreement as separate table and create association with customer that would be faster as well. 2.you can also implement some kind of what loading , that means do not load agreement table data until it ask for..
0