Have you considered some of the points raised below? Spending a few minutes checking off these simple tips before may save you a lot of time later on.
1. IdentifyIdentify your data source
What data do you need to start withand where does it live? Identify your data sources , i.e., where does your data live? Check that your source data and check the quality of the data. You'll get better results if your source data is as 'clean' as possible.
2. ThinkThink about the users
The design of your database affects how your team can use Phocas. To ensure your database is user-friendly, we recommend you take into account the needs and skills of your users, the required data structure, naming conventions and who you want to be allowed to see data.
3. KeepKeep it simple
If you're a beginner at designing databases, make your first one simple. Once you have your first successful build, then add more databases. Phocas offers several simple database templates Depending on your Phocas environment, you may have access to one or more simple database desgins to help get you started.
Excerpt |
---|
Database basics
|
To learn more about how databases are commonly set up, see our information about /wiki/spaces/userdoc/pages/590217 |
|