A database is made up primarily of tables, a table is made up of columns and rows and each row contains data for each column. When creating or modifying your database structure there are a few things that may save you time.
Here are some tips for when you are creating or modifying tables:
When adding fields to a table the following may be of help:
That’s it for this post. Thinking about the table structures also helps you think about how your solution is going to use the data and what requirements it may need. Remember, a good solid database structure will save you loads of time when creating your Data Access Layer and Business Objects within your solution. We hope this post is helpful and as usual, constructive criticism and suggestions are welcome.
We'd love to welcome you into our office! We're only 20 miles north of Peterborough, conveniently just off the A16.
Apex Court, Elsoms Way