Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
guddi1
Starting Member
4 Posts |
Posted - 2006-07-24 : 13:59:07
|
Hi, I'm a new hire. I was hired as a software developer but my company wants me to do data mapping using sql server. I'm given a table in excel containing the data that is to be mapped. But, I've never mapped data before, so I have no clue where to start. If somebody could please guide me to the correct solution, I would really appreciate it. By the way, they want me to map data by creaing tables and relationships in SQL Server. Thanks. |
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-07-24 : 15:26:40
|
Mapping the data implies they want you to correlate columns from the Excel spreadsheet with columns in an existing database structure. But your last sentence seems to indicate that they want you to normalize the spreadsheet data in a new database structure.Which is it? |
|
|
guddi1
Starting Member
4 Posts |
Posted - 2006-07-24 : 15:56:18
|
Hi, Yes, they want me to normalize the data from the excel spreadsheet in a new database structure. Thanks. |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-07-25 : 09:51:12
|
Do you know the principles of database normalization?Basically, you will have to identify the different entities and attributes contained within your spreadsheet, and split these into different tables with foreign key relationships between them.Are you just dealing with a single Excel table? If so, it should not be difficult. Perhaps if you posted the column headers from your Excel table we could give you a head start. |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
|
guddi1
Starting Member
4 Posts |
Posted - 2006-07-26 : 15:51:25
|
Hi Guys, Thank you so much for helping out. It is starting to make sense now. I am familiar with relation database concepts but I just didn't understand what data mapping actually meant. Now I understand that I need to create tables and of course link them using foreign keys. Thanks. |
|
|
|
|
|
|
|