title: Creating and Bridge tables in MySQL query
body: <p>I am working with a basic table design for a MySQL database. This database project was given as an idea, mainly aimed for an educational purpose.  There are a total of 11 tables which 2 are used for bridging purposes. I tried to properly set primary and foreign keys.  I am not sure how to write the query that will create the 11 tables and bridge them all at once.  <a href="http://webprolearner.ueuo.com/table_diagram/" rel="nofollow">HERE</a> I have attached a visual diagram of these tables.</p>
  
  <p>Through basic learning I can create one table but not sure how to advance from here: </p>
  
  <pre><code>CREATE TABLE Course (
            Course_ID INT,
            Course_Abbreviation VARCHAR(5),
        Course_Number INT,
        Section_Number INT,
        Professor_ID INT,
        Status VARCHAR(10)        
          ) TYPE=innodb;
  </code></pre>