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.
Be sure to show proposed:
· keys, and
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!
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:
Description and supporting image of transforming spreadsheet data into a normalized set of database tables.