You are here:
- Home
- Industry
- Data Management
- Database Programming
- Reginald Lim
Database Programming/Expert Profile
Expertise
I can answer questions about database design for OLTP and OLAP. I can can answer questions about logical models and physical star schema models. I can answer questions on ERwin. I can answer questions about SQL.
Experience in the area
I currently work on database design on a day to day basis. I have years of experience with Oracle, SQL Server, and database design tools.
Organizations
DAMA
Education/Credentials
BS Computer Engineering
Multiple Data Warehouse Class Completion Certificates
Hobbies
Playing games at http://www.GameGremlin.com
Average Ratings
Recent Reviews from Users
K = Knowledgeability C = Clarity of Response P = Politeness| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Mike | 03/04/12 | 10 | 10 | 10 | |
| Tim | 02/22/11 | 10 | 10 | 10 | |
| Richard | 04/15/10 | 10 | 10 | 10 | Excellent!! Thanks for the assistance |
| mique | 09/30/09 | 10 | 10 | 10 | thank you for your help....god bless ..... |
| Yel | 02/11/09 | 8 | 9 | 8 |
Recent Answers from Reginald Lim
2010-04-14 Design Question:
You could do option 1, but that seems to change the grain or the fact definition of visit. For option 2 it is similar to using a helper table. Looking in Figure 1 of the link below, the Monthly account
2009-05-12 Database pools?:
Amazon and iTunes have similar functionality. Users can group songs or discs to their liking. If you wanted to create an application from scratch, the database tables could look like the following:
2009-01-02 Excel duplicate finder:
You can use the Control F function to see all of the matches by clicking Control F, then Options, then Find All. That is about the extent of simple built in functions for Excel. If you require a
2008-10-12 Table, query, and relationship design with membership and attendance:
It looks like you have a good start on your project. I see that you have tables set up for members and what groups they belong to. What is missing is the attendance portion. You could have a table
2008-07-29 DBase:
Joe, It depends on what version of dbase you're using. A long long time ago I used dbase III, but that is not a supported product as shown in the manufacturer's website: http://www.dbase.com/dBase_Cust_Ser_Tech_Support
Answers by Expert:
©2012 About.com, a part of The New York Times Company. All rights reserved.