General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi Alejandro,
>I wouldn't use a DBC. You should design the locking such that related tables are sure to be updated. I would also feel free to break some normalization rules along the way. Think about the way VFP does the PJX or VCX files. The Project file has one HomeDir field--only used by one record. That's wrong--but oh so right for the task. We like having the project in a single (or two with the PJT file) file. The VCX/SCX files have a comment record, dataenvironment record and so on. If VFP normalized these files, each ClassLib would be sourced in a variety of files--but I'm glad they don't.
I appreciate your suggestion about the DBC and will probably do that.
About bending normalization to reduce the number of tables, I got it down to 3 dbf's and 3 cdx's. That is appropriate because this is a simplified freebie meant to lead to full product sales.
Thanks fro your input.
Alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only