from sqlite3 import *

with connect("uni.db") as con:
    cursor = con.cursor()
    sql = """CREATE TABLE student
             (MatrNr INTEGER PRIMARY KEY, 
              Name VARCHAR)"""  
    cursor.execute(sql)
    sql = """CREATE TABLE vorlesung
             (VorlNr INTEGER PRIMARY KEY, 
              Titel VARCHAR,
              PersNr VARCHAR)"""  
    cursor.execute(sql)      
    sql = """CREATE TABLE professor
             (PersNr INTEGER PRIMARY KEY, 
              Name VARCHAR)"""  
    cursor.execute(sql)         
          
                    
print "Done"