Explore BrainMass
Share

Explore BrainMass

    Normalization of an Excel Spreadsheet

    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:

    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!

    © BrainMass Inc. brainmass.com October 9, 2019, 11:33 pm ad1c9bdddf
    https://brainmass.com/computer-science/memory-management/normalization-of-an-excel-spreadsheet-260334

    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