This is one of the applications that I developed some time back and I am going to use it to demonstrate some of the design patterns.
Basically this is a simplied share trading system. You can have a look at the E-R diagram here.
The MySQL script can be downloaded here.
Using this application, I am going to talk about some of the enterprise architectural patterns
- Table Data Gateway
- Row Data Gateway
- Active Record
- Data Mapper