Our next task is to add the ability to assign multiple instructors to a single section. We are going to be making changes not only to the structure of a table, but also to the keys on which tables are related. This is a substantial structural change, so before we modify the existing tables, we will first build the new functionality. This allows us to build the new functionality, then check all of our existing database objects to ensure that they will work with the new structure before completely switching from the old to the new. If we break something, we can simply delete the tables involved with the new functionality and try again. In a sense, the existing tblSections will serve as a backup in case things go wrong.
If you are unsure about the scale of the changes you need to make, it is best to create new functionality and data structures before modifying your existing data structures. This ensures that you will still be able to continue business as usual while the new capabilities are introduced to your database.
Let's create the copy of tblSections that we will use to build the ability to have multiple instructors per section.
Step1. To copy tblSections and paste it with a new name, in the Navigation pane:
press: Control key+c, Control key+v,
type: tblSectionsMultiInst, press: Enter
Step2. Close tblSectionsMultiInst.