Re: New Database from Excel Data

[Phillip Ward]

Anything that can exist on its own, without reference to anything else, should have its own table:

- Customers
- Depots
- Inspectors
- Dates (calendar tables can be very useful)
- Tests (definitive list of all tests)
- Defects
Each has its own identifier.

Those identifiers appear in additional tables that join things together.

- Inspection (For a Customer, at a Depot, by an Inspector, on a given Date)
- Inspection_Tests (Tests used in a given Inspection)
- Inspection_Test_Defects (Defects raised against each Test in a given Inspection)

So, all the Defects for a Customer on a certain Date?

You'd need the Inspections table, joined to Inspection_Tests, then joined to Inspection_Test_Defects, filtered by Customer id and Inspection date.