We will create a database for Student, Alumni, Board members, and Employee contacts, each category having different fields of information. We need to gather reports like all Alumni who have worked at company x, all employee contacts for company y, etc. Any suggestions or hints when designing the database?
If this is about Rollbase, then at some level, you have a good description of the Objects already in your description. Rollbase natively creates the reports and you can filter and sort on any column.
I would start by protoyping one or two Objects (import data from a Spreadsheet might make your "getting started" experience better. ) and then seeing if the reports you want come naturally. I suspect many will.
Sumit has probably already told you about Easyl and getting more complex datasets and analytics from Rollbase data sources, so I won't belabor that point.
A final suggestion is that if you have Rollbase specific technical questions, you should post those in the Forum under:
- Technical Users (Group)
- Rollbase (Forum)
Good luck.
If you don't have database design expertise in house, hire a consultant.
To clarify, the question is specific to Rollbase around best practices in the design of objects and their relationships for native reporting purposes.
RollBase, OpenEdge, or Access, it is still an issue of database design.
If this is about Rollbase, then at some level, you have a good description of the Objects already in your description. Rollbase natively creates the reports and you can filter and sort on any column.
I would start by protoyping one or two Objects (import data from a Spreadsheet might make your "getting started" experience better. ) and then seeing if the reports you want come naturally. I suspect many will.
Sumit has probably already told you about Easyl and getting more complex datasets and analytics from Rollbase data sources, so I won't belabor that point.
A final suggestion is that if you have Rollbase specific technical questions, you should post those in the Forum under:
- Technical Users (Group)
- Rollbase (Forum)
Good luck.