Purchase Solution

Normalization of an Excel Spreadsheet

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

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

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:
...

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Javscript Basics

Quiz on basics of javascript programming language.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • COVID Cases Analysis

    You will begin with an Excel template which has been loaded with cumulative summary data for the 3 northern Virginia counties of Fairfax, Loudoun, and Prince William (the county where Manassas is located).

  • Discussing the Concept of Normalization

    44291 Discussing the Concept of Normalization Question: In your own words, explain the concept of normalization. What does normalization accomplish? What are the advantages of normalization?

  • Is database normalization enough?

    This solution discusses whether or not database normalization is sufficient for creating the best database design for an application. Clear examples are provided.

  • Normalization and Optimization

    Would you describe Normalization as Science or Art? Dedicate your last paragraph to Optimization (de-normalization) Please see the attachment. This solution of 1392 words explains the process of normalization and the usage of anomalies.

  • Database Normalization

    129583 Database Normalization Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information.

  • normalization

    For example, maintaining the medals tally in an international sporting event would involve attributes such as the nationality, age., gender, name, date of birth, country of birth etc. for a sportsman.

  • Diastereoisomers of 3,3,5-trimethylcyclohexanol

    The huge peak appearing within a minute of injection is due to the solvent. [I do not see any standard for normalization, so probably a prior normalization is not expected.] Area under these peaks are also given.

  • Normalization Techniques a Database

    Confusion is always a threat when, for instance, an address for an employee in one table does not match the address of the same employee in another table. Which table is correct? Do you have documentation to verify the employee's current address?

  • Matter wave problem - Normalization constant

    This solution is provided in approximately 477 words in an attached .doc file. It uses step-by-step equations to find the normalization constant and probability.

View More Related Solutions