Explore BrainMass

Explore BrainMass

    Normalization of an Excel Spreadsheet

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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:


    · 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!

    © BrainMass Inc. brainmass.com March 4, 2021, 9:38 pm ad1c9bdddf


    Solution Preview


    First, see the PDF of an industry-standard table of puppy data (basically) a spreadsheet at

    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.