TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
G F
NA
44
6.3k
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.
G
Reply
Answers (
1
)
Update And Upgrade difference
update an xml node