G F

G F

  • NA
  • 44
  • 6.2k

Data Organization/Schema Question

Jan 20 2020 2:49 AM
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.
 
 
 

Answers (1)