Share
Explore BrainMass

Normalization of an Excel Spreadsheet

Analyze samples of RoboBoys current Excel spreadsheets (click here to download) and draft a description of how it can be converted into a RDBMS. You can use words, graphics, or a combination, but it must be understandable by Jim and Tim, who do not have a database background and are just beginning to learn from you.

Please submit your assignment.

For more information on creating PowerPoint Presentations, please visit the Microsoft Applications Lab.

Instructor Comments:

Be sure to show proposed:

tables

· fields

· keys, and

· relationships
NOTE: An Entity Relationship Diagram (ERD) works best for this; no need to write a lot of text.
NO references required for this task :-)

How do you convert excel spreadsheets into an RDBMS? along with an erd diagram?

i am stumped!

I NEED examples using the supplied excel spreadsheets!

Attachments

Solution Preview

Student,

First, see the PDF of an industry-standard table of puppy data (basically) a spreadsheet at
http://filedb.experts-exchange.com/incoming/2009/02_w06/102071/rettigNormalizationPoster.pdf

Here is the process that was taken to take that table (spreadsheet) and convert it into a RDBMS, from an IBM source:
...

Solution Summary

Description and supporting image of transforming spreadsheet data into a normalized set of database tables.

$2.19