AllExperts > Database Programming 
Search      
Database Programming
Volunteer
Answers to thousands of questions
 Home · More Database Programming Questions · Question Library  · Free Encyclopedia ·
More Database Programming Answers
Question Library

Ask a question about Database Programming
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
About Carlson Lim
(Top Expert on this page)

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
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
   

You are here:  Experts > Industry > Data Management > Database Programming

Questions Answered By Expert  Carlson Lim 
In Category  Database Programming

SubjectDate Asked

Database pools?5/12/2009
  Q: Does there exist a database application that will pool together similar files of your choice? For ...
  A: Amazon and iTunes have similar functionality. Users can group songs or discs to their liking. If ...
Excel duplicate finder1/2/2009
  Q: I want free software for checking duplicate words in Excel (Deduplication check Software). I have ...
  A: You can use the Control F function to see all of the matches by clicking Control F, then Options, ...
Table, query, and relationship design with membership and attendance10/12/2008
  Q: I'm trying to design a database for an organization that will record membership in groups and track ...
  A: It looks like you have a good start on your project. I see that you have tables set up for members ...
DBase7/29/2008
  Q: do you know anything about dbase or Dos? We have old system and don't know how back-up discs would ...
  A: Joe, It depends on what version of dbase you're using. A long long time ago I used dbase III, but ...
Combining two records from a query into one record6/26/2008
  Q: e. the table has colour information say 30 different colours each with a pattern size. I then get ...
  A: This is possible if you create a query that will query Expr3 in your example above. The SQL would ...
ms access5/5/2007
  Q: I have an access database and I'm stuck with how to rank records. What i did was place a rank field ...
  A: Let's say the table for this is named Task, with columns TaskID, TaskName and RankNumber. I'm not ...
Relational Database...11/30/2005
  Q: I have two txt files with the following fields in each. These are very large files with information ...
  A: Shannon, It looks like you've got a great start on normalizing the text files. Without a sample ...
Database Programming9/29/2005
  Q: 1. What is database programming? 2. History of database programming? 3. Developer of database ...
  A: A database is a collection of data. Answers to your questions: 1. Using programming to retrieve ...
Adding an button and its event to save the bank(records of bank)9/26/2005
  Q: Hello.I wish that your doing well. I have created a wizard from VB.Net program environment(with an ...
  A: I'm sorry I am not an expert VB programmer. As stated in my profile: I can answer questions about ...
Crystal Report Cross Tab8/19/2005
  Q: I have a problem with a crystal reports cross tab report.... I have made a usual cross tab report ...
  A: I'm sorry I am not an expert on the Crystal Reports application. I can help with SQL and database ...
databese labnguage1/1/2005
  Q: but i dont know where i must start? sql?visual c++?delphi? i konw some c programming. please guide ...
  A: The first place to start is learning SQL. SQL is a standard interactive and programming language ...
I need help!11/8/2004
  Q: Hey there, My name is Ronda and I'm working on a children's project for the churches in my area, I ...
  A: The easiest way to do this is to put your data in 2 tables. The CHURCH table may look like: ...
New database7/29/2004
  Q: For years I have used a real estate program called Top Producer which has an excellent database that ...
  A: Walt, I'm not familiar with Top Producer. However, if there is a way to get the main fields from ...
databases7/26/2004
  Q: My question is actually about MS Outlook and databases. I work for a non-profit organization that ...
  A: Joanna, Here is a quote from a link on the Microsoft support site that may help: ...
OODBMS Vs. RDBMS4/8/2004
  Q: I am involved in an educational research team. We are looking at upgrading our database and wanted ...
  A: Naveen, Here is a link that compares OODBMSs to RDBMSs: ...
two questions about ERWin7/11/2003
  Q: 1/What does ModelMart do? 2/What do Domains, Model Sources, Validation rules and Default Values do ...
  A: ModelMart allows centralizid sharing of models. Domain - A group of predefined logical and physical ...
Oracle vs DB2 vs Teradata7/17/2002
  Q: Given the following scenario: Join two tables -- each containing approximately 30 million rows -- ...
  A: Being realistic, everyone will have have a platform bias, whether they know it or not. It naturally ...
Software debugging6/7/2002
  Q: I would like to know the difference between taking a trace and a dump with respect to debugging ...
  A: Here are some general definitions: A trace is when a program execution is followed instruction by ...

All Questions in This Category

Email this page
     
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2006 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.