So if you nine records in your Widgets table, they must represent nine unique and distinct widgets. Each record in a database represents ONE INSTANCE of the thing that the table is about. Records are a bit like rows in a spreadsheet, but again, they're only "like" rows - they aren't rows. Finally, once you've defined tables and fields, you enter data into records. So if the logical properties of a widget are a name, a widget number, and a unit cost, those might be likely fields in the Widgets table. Tables are made up of "fields" that represent the properties of the thing the table is about. Databases are made of tables (each of which represents a specific kind of thing, like Customers or Widgets or Students or Invoices).
In some ways, a spreadsheet is kind of like a word processing document, but for numbers.ĭatabases on the other hand are rigidly and comprehensively structured. It's part of what makes spreadsheets so good with hypotheticals. The freedom you have with a spreadsheet is one of its strengths. But if you wanted to put the annual gross income of Mauritania in cell A35, there's nothing to stop you. You could for example create a nice list of names and phone numbers in cells A2 to B30 (assuming A1 = "Names" and B1 = "Phone Numbers"). Of course people DO tend to use spreadsheets in a way that organizes the cells - but the organizational structures so created are all ad hoc. Beyond that, spreadsheets are a total free-for-all. Every cell is addressable that is it has an address that can be used to refer to it. Spreadsheets are simply massive grids of rows and columns that define cells. Airtable is a database platform Sheets like Excel is a spreadsheet platform.
0 kommentar(er)
