Database Best Practice (patterns)
Posted on 2004-04-16
Well, this is more of a best practice question then actually how to do something.
I am developing an app (practice) where it is talking to a database. Everything is working fine.
The database consist of 3 tables, personnel, course_xref, and course. As you can guess, the course_xref table consists of personnel with many courses.
I am creating a class within VB that would concidered a personnel record, with many of the same fields within the personnel table. Now....
Should I create a course class and have an array of courses within my Employee class OR should I dynamically create the list of classes when it is needed. (If I am displaying information regarding an Employee and I want to see all courses this person has taken, do I want to display it as text or store each one into an array of objects and display each one that way. )
Thanks for your help.