I enjoyed completing this assignment. As with all of the other assignments, the way that it builds off of one another is clearly evident and a very effective way to layer our lessons in a realistic and practical way.

I really enjoyed creating the relational database schema. As I have a little bit of experience in creating databases, SQL, and the normal forms, this was a natural extension of what I have already learned. Laying it out in this format really helps to clarify the goal and to outline the data in a way that is simple and easy to understand. The next natural step would be to create a diagram that outlined all of the independent relationships between the different tables.

The data access classes section was an interesting section. Having not been exposed to this before I was a little confused at first as to how this helped with the greater picture. But after completing it I can see that these types of flow charts which provide detail into specific use cases are necessary when developing a comprehensive system.

Integrity control was an interesting section that I had to spend a significant amount of time on. It was an interesting exercise due to the fact that I do not have any insight into how to directly implement all of these different controls into the system. Despite this, it forced me to think of all of the different scenarios that could potentially happen and whether or not something could but put in place that would either prevent it from happening or mitigate the damages.

Last was the access security. I found this section to be relatively straightforward and simple but I suspect that this is mainly because the IS system we are working with is not the most complex system. I can see that in large systems which may san across entire large corporations that this exercise would become much less messy. Either way I can really see the advantages in creating something like this.

Jason