@JaredBusch said in Excel to SQL - Need Some Normalization Tips:
@garak0410 said in Excel to SQL - Need Some Normalization Tips:
So, what I am looking for is the proper way to store these notes in a database and have it tie back to the matching customer. I've imported this into SQL and while it worked, I still have the problem of how to display the data from the columns. Management stills wants one large field that displays the notes, most likely with a vertical scroll bar to through through them.
Do not worry about how to store the data.
Start with what you need to end up with and how it will be entered.
Those are two different things.
But those two will form the basis for what your data will have to be.
So supposing you have these entry fields.
ID
Customer (multiple fields for info, name, account #, etc.)
Note 1
Note 2
Note 3
You were posting about making multiple tables and getting close to 3rd normal form.
Works great, and is good design of course, but you also need to think about the purpose of this application.
But do you need to get that complicated? Any relational database can take all that in a single table with as many columns as needed.
The purpose is to see what special requirements there are for certain customers. We currently have 145 regular customers who have special needs when we design a building for them. We want to be able to display the customers in a cleaner format and also make it easy for a designated person to update as needed.
And I am, for now, going to use Access because I need something quick and within my current skill level. And yes, when my skills expand, I do plan on redesigning this. The main problem I am having is displaying the notes. Each single note per customer is it's own field. For example, look at this wizard:
0_1489002763830_access02.jpg
In creating a form,. it's wants me to select each note field and ends up looking like this:
0_1489002881856_access03.jpg
This isn't want management wants and it will also cause problems for customers who need more than 16 "notes." They want to see the customer name, address, contact number and all notes associated with it. It would be nice to see all notes in a scrollable window. Not sure how easy that would be with Access but I'm thinking it would be. This is where I may be confused if I need normalization or not.