title: How to create multiple tables in Android studio database
body: <p>Currently I'm following tutorial for android database creation on youtube at channel ProgrammingKnowledge, however, it works only for one table, while I need to have 3 tables in the database, and can't get my way around it.</p>
  <p>This is the code I currently have.</p>
  <pre><code>public class DatabaseHelper extends SQLiteOpenHelper {
  
      //database name declaration
      public static final String DATABASE_NAME = &quot;museum.db&quot;;
      public static final String TABLE_NAME = &quot;exponent_table&quot;;
      public static final String COL_1 = &quot;ID&quot;;
      public static final String COL_2 = &quot;TITLE&quot;;
      public static final String COL_3 = &quot;STORY&quot;;
      public static final String COL_4 = &quot;AUTHOR&quot;;
      public static final String COL_5 = &quot;DATE&quot;;
  
      public DatabaseHelper(Context context) {
          super(context, DATABASE_NAME, null, 1);
          SQLiteDatabase db= this.getWritableDatabase(); //will create database and table, just for checking, will be replaced
      }
  
      @Override
      public void onCreate(SQLiteDatabase db) {
          //creating tables ???
            db.execSQL(&quot;create table &quot;+TABLE_NAME+&quot; (ID INTEGER PRIMARY KEY AUTOINCREMENT, TITLE TEXT, STORY TEXT, AUTHOR TEXT, DATE STRING)&quot;);
            
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int i, int i1) {
          db.execSQL(&quot;DROP TABLE IF EXISTS &quot;+TABLE_NAME);
          onCreate(db);
      }
  }
  </code></pre>
  <p>I have seen something similar on the link:
  <a href="https://stackoverflow.com/questions/21779772/multi-table-database-sqlite-android">Multi-table database SQLite android</a></p>
  <p>But still do not understand.</p>