It is the best practice for understand relationship between the databases and how it process and work.
Try it your own with MS Access or any other and see the result or download orderprocesing2003 open with MS access 20003 and put relationship between databases (tables) as above and see before and after results(change).
Article source from: About access databases
