You are here:
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.
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 T = Timeliness P = Politeness| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| mique | 09/30/09 | 10 | 10 | 10 | 10 | thank you for your help....god bless ..... |
| Yel | 02/11/09 | 8 | 9 | 8 | 8 | |
| tennis_girl | 01/07/09 | 10 | 10 | 8 | 10 | |
| Richard | 06/27/08 | 10 | 10 | 10 | 10 | |
| Pradeep | 09/05/07 | 10 | 10 | 10 | 10 |
Recent Answers from Carlson Lim
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
2008-06-26 Combining two records from a query into one record:
This is possible if you create a query that will query Expr3 in your example above. The SQL would be something like: select A.column1 || ' and ' || B.column1 from ( select column1, 'X' from Expr3
©2009 About.com, a part of The New York Times Company. All rights reserved.