SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Data Mapping Using Tables And Relationships
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

guddi1
Starting Member

4 Posts

Posted - 07/24/2006 :  13:59:07  Show Profile
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
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 07/24/2006 :  15:26:40  Show Profile
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?
Go to Top of Page

guddi1
Starting Member

4 Posts

Posted - 07/24/2006 :  15:56:18  Show Profile
Hi,
Yes, they want me to normalize the data from the excel spreadsheet in a new database structure.

Thanks.
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 07/25/2006 :  09:51:12  Show Profile
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.
Go to Top of Page

RyanRandall
Flowing Fount of Yak Knowledge

United Kingdom
1074 Posts

Posted - 07/25/2006 :  10:14:53  Show Profile
If you want to read up on normalization and data modelling, here are some links to get you started...

http://en.wikipedia.org/wiki/Database_normalization
http://www.agiledata.org/essays/dataModeling101.html
http://www.datamodel.org/NormalizationRules.html


Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

guddi1
Starting Member

4 Posts

Posted - 07/26/2006 :  15:51:25  Show Profile
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000