I am doing a project of converting a spreadsheet to database. Currently the spreadsheet contains 12 pages of general information (attribute) as follows:

ImageShack® - Online Photo and Video Hosting

Each table represents a page

I am not too sure how to approach converting this into a database. My first attempt was putting everything into one table but this solution hasn't worked.

Any help would be great.

Upload the data directly to tables. One table per page/dataset.

This may lead to redundancy an inconsistency as many attribute would be repeated among tables.... is there a more efficient way of doing this?

If you want to redesign your database to implement foreign keys, constraints, normalization, etc, do it after you have the data loaded into your tables.

I rather redesign the database to implement foreign keys, constraints, normalization before I attempting anything else.


What I am asking is how to organise the tables and develop a ERD.

If you redesign your database first, then:
1) You are going to be doing it without the benefit of looking directly at the actual data.
2) You are going to need to create additional staging tables or transformation processes to convert your old schema to your new one.

So unless uploading this data needs to be a repeatable process, if you have a green field development project why would you create additional work for yourself?

I understand your point now...thanks for the help. I will directly upload the data to tables and take it from there. I will keep this thread updated if I come across any problems.

Glad to help.