Mile-O
Back once again...
- Local time
- Today, 14:35
- Joined
- Dec 10, 2002
- Messages
- 11,316
Rare87GT said:1. There should be a minimum of FIVE significant tables. A significant table has more than two attributes/columns.
2. All tables will be normalized to at least third normal form to prevent update anomalies.
3. All attributes must have captions and descriptions in the table design form.
4. Use predefined input masks where appropriate e.g. phone numbers, social security numbers, postal codes, etc.
5. Include at least two user defined input masks that you create e.g. an input mask to insure the letters in a state code are all capitalized.
6. There will be at least two lookup tables. Lookups can be done using one ore more of the five significant tables or you can create a table just used for looking up values (e.g. State Code Lookup table) that will be entered in other tables in your database.
7. All primary key fields will be required entries.
8. Non-key fields containing the minimum essential data to make each record meaningful will be required entries.
9. All initial entry tables will have validation criteria included to insure the quality, accuracy, and correct format of the data.
So, this is a school/college project?
Regarding #2 - I've normalised to the best of my ability. The requirement of five 'significant' tables is naive.