Usage of SQL Server 2008 R2 Express. Please Advise
I believe Express should be more than adequate. Once your database is larger than 1GB it won't all fit in memory, but unless your hard drive is 5400 RPM and your users are very particular it is quite unlikely they would ever know the difference. It doesn't sound like you'll get past 1GB in any feasible time frame anyway...