From the course: CompTIA Data Systems (DS0-001) Cert Prep

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Tabular data

Tabular data

From the course: CompTIA Data Systems (DS0-001) Cert Prep

Start my 1-month free trial Buy for my team

Tabular data

“

- [Instructor] Spreadsheets may be powerful tools for storing data in tabular form, but they have some limitations that prevent them from being a useful tool in enterprise data management applications. That's where databases come into the picture. Databases extend the concept of storing data in tables from the single table focus spreadsheet model to the relational model, which focuses on how tables interact with each other. Here's another look at the schema diagram for the AdventureWorks database that I showed you earlier. Each one of the boxes on this diagram represents a single table, and each arrow on the diagram represents a relationship between two tables. Now can you imagine trying to track all of this information in a series of spreadsheets? You might be able to do it, but it sure wouldn't be much fun. In the relational model, we still organize our data into tables, and each table contains information about a single subject or topic. Here's an example of a table that we might…

Contents