organizing fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to avoid repeated fields in a database I've been asked to build to
track class attendance.
I have a list of courses and a list of applications. Some applications are
taught in multiple classes. Example: Excel Level 1, Excel Level 2 both cover
Excel.
However, some classes cover more than one application. Example: New Hire
training covers our MS Office templates, our intranet, and Lotus Notes.
How can I design the tables to accommodate this? If anyone has advice or a
resource for table design, I would appreciate it.
 
I'm trying to avoid repeated fields in a database I've been asked to build to
track class attendance.
I have a list of courses and a list of applications. Some applications are
taught in multiple classes. Example: Excel Level 1, Excel Level 2 both cover
Excel.
However, some classes cover more than one application. Example: New Hire
training covers our MS Office templates, our intranet, and Lotus Notes.
How can I design the tables to accommodate this? If anyone has advice or a
resource for table design, I would appreciate it.
Click to expand...

This is a pretty standard "Many to Many" relationship. You need three
tables:

Classes
ClassID <Primary Key>
ClassName
<other info about the class, e.g. InstructorID>

Applications
ApplicationID <Primary Key>
ApplicationName
<info about the application if needed>

ClassCoverage
ClassID <link to Classes>
ApplicationID <link to Applications>
Comments <e.g. about what portions of the application this class
covers>


John W. Vinson[MVP]
 
Thanks, John. One more part is still tripping me up. The classes taught are
based on what we call "Courses". I guess a course is best described as the
contents to be taught while a class would be the course materials delivered
on a specific day to specific people by an instructor.
Two problems pop up.
I'm trying to figure out how to connect my Course list to my Class list.
But, the applications taught in some of the Courses may change through time.

Any thoughts?
 
Back
Top