The relational database is a combination of the Master spreadsheet table and all of its Slave tables or spreadsheets. For example, your driver’s license is a single record in a flat-file ...

For example, your spreadsheet may contain ... and follow the instructions to create a sample relational database. Single “flat-file” Pivot Table reports Pivot Tables are the “defined as ...

In this flat file database, the data on each member of staff is held together with all data for each department. This is unnecessary as some information is stored more than once (eg the same phone ...