You are here:
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 currently work on database design on a day to day basis. I have years of experience with Oracle, SQL Server, and database design tools.
DAMA
BS Computer Engineering
Multiple Data Warehouse Class Completion Certificates
Hobbies
Playing games at http://www.GameGremlin.com
| 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 |
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:
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
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
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
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.