title: How do i initialize database in SQLite3 script?
body: <p>I am doing an assignment in which there is a requirement that i have to write a sqlite3 script to initialize database and create tables ... </p>
  
  <p>Now i know how to do all this in SQL but not in lite. 
  Actual statement is as follows</p>
  
  <blockquote>
    <p>2.1. Create an SQL (text) document mandm_setup.sql!that can be executed from the
    SQLite command prompt. This script should include SQL statements that do the
    following:</p>
    
    <p>• Appropriately initialise your database</p>
    
    <p>• Create all of the tables in your database design using appropriate data types and
    constraints, based on your design</p>
  </blockquote>
  
  <p>Please Help me out here.
  I am stuck</p>
  
  <p>Thanks In advance.</p>