1.

Solve : ms access relationships diagram?

Answer»

Hi i am new to ms access databases, really struggling with my tables relationships

my database has more than one many-to-many relationships, for example one instructor can have many classes, one CLASS can have different instructors, one client could have different instuctors, one instructor could have many clients and all at different times, on different days

eg: 18/06/2013 Time: 8:00, Instructor: Steven, Class :Pilates, Clients: Bob,
Andrew,
Jess,
Alex

Time: 9:30, Instructor: Thomas, Class :Yoga, Clients: Alexis,
Kerry,
Alex,
Bob

22/06/2013 Time: 10:00, Instructor: Greg, Class :REFORMER, Clients: Bob,
Harry,
Jess,
Alex

Time: 16:30, Instructor: FRED, Class :Yoga, Clients: Alexis,
Kerry,
Alex,
ALEXANDRA
(Each day can have many of these at any times)

really struggling on this one, its probably really though any help on relationship DIAGRAM would be greatly appreciatedyou need another relation table.

that will contain the instructor id, the time and the class id.

based on that you will have 3 tables. one for class, one for instructor and one for the relation between them.



Discussion

No Comment Found