You are here:
- Home
- Industry
- Data Management
- Database Programming
Database Programming/Questions Answered by Expert Reginald Lim
| Subject | Date Asked |
| Design Question | 4/14/2010 |
| Q: Carlson, Trying to design a Star/Snowflake schema for analytical processing with M/S SQL Server ... A: You could do option 1, but that seems to change the grain or the fact definition of visit. For ... | |
| 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 finder | 1/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 attendance | 10/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 ... | |
| DBase | 7/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 record | 6/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 access | 5/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 Programming | 9/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 Tab | 8/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 labnguage | 1/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 database | 7/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 ... | |
| databases | 7/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. RDBMS | 4/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 ERWin | 7/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 Teradata | 7/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 debugging | 6/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 ... | |
Database Programming
Answers by Expert:
Reginald 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. I can answer questions about SQL.
Experience
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
©2012 About.com, a part of The New York Times Company. All rights reserved.