Creating Relationships Between Tables

The first step in creating relationships in Access is to display the Relationship window, by selecting Relationships from the Tools menu.
You will be propted to add classes. Select all the classes that have relationships and add all. You will see this window with not relations designated.
You want to associate each Section with a professor and a course. First select the _professor field of the Section table and drag it to the Id filed of the Professor table. You will be prompted by the dialog box shown here (with appropriate fields displayed). Click on Enforce Referencial Integrity box and the the create button.
After you have created each reference, it will appear in the reference window. Notice that the is a small infinity sign where you had the filled circle in your diagram (compair the Reference window with your design diagram below).
Back to design in c++ Back to design in Java .