№1
import sqlite3
import pprint
conn = sqlite3.connect('TypeBase.sqlite')
c = conn.cursor()
pp = pprint.PrettyPrinter(indent=1, width=60, compact=False)

conn.execute('''
CREATE TABLE IF NOT EXISTS t1 (
t text,
nu numeric,
i integer,
r real,
no blob)''')

#1
c.execute('''
DELETE FROM t1;
''')
conn.commit()

c.execute('''
INSERT INTO t1 VALUES('500.0', '500.0', '500.0', '500.0', '500.0');
''')
conn.commit()

c.execute('''
SELECT typeof(t), typeof(nu), typeof(i), typeof(r), typeof(no)
FROM t1;
''')
pp.pprint(c.fetchall())

#2
c.execute('''
DELETE FROM t1;
''')
conn.commit()

c.execute('''
INSERT INTO t1 VALUES(500.0, 500.0, 500.0, 500.0, 500.0);
''')
conn.commit()

c.execute('''
SELECT typeof(t), typeof(nu), typeof(i), typeof(r), typeof(no)
FROM t1;
''')
pp.pprint(c.fetchall())

#3
c.execute('''
DELETE FROM t1;
''')
conn.commit()

c.execute('''
INSERT INTO t1 VALUES(500, 500, 500, 500, 500);
''')
conn.commit()

c.execute('''
SELECT typeof(t), typeof(nu), typeof(i), typeof(r), typeof(no)
FROM t1;
''')
pp.pprint(c.fetchall())

#4
c.execute('''
DELETE FROM t1;
''')
conn.commit()

c.execute('''
INSERT INTO t1 VALUES(x'0500', x'0500', x'0500', x'0500', x'0500');
''')
conn.commit()

c.execute('''
SELECT typeof(t), typeof(nu), typeof(i), typeof(r), typeof(no)
FROM t1;
''')
pp.pprint(c.fetchall())

#5
c.execute('''
DELETE FROM t1;
''')
conn.commit()

c.execute('''
INSERT INTO t1 VALUES(NULL,NULL,NULL,NULL,NULL);
''')
conn.commit()

c.execute('''
SELECT typeof(t), typeof(nu), typeof(i), typeof(r), typeof(no)
FROM t1;
''')
pp.pprint(c.fetchall())

conn.close()


№2
import sqlite3
import pprint
conn = sqlite3.connect('TypeBase.sqlite')
c = conn.cursor()
pp = pprint.PrettyPrinter(indent=1, width=60, compact=False)

conn.execute('''
CREATE TABLE IF NOT EXISTS t1 (
t text unique,
nu numeric check(nu<100),
i integer default 5000,
r real not null check (r>=200),
no blob
check(r+i>=400))''')

c.execute('''
DELETE FROM t1;
''')
conn.commit()

c.execute('''
INSERT INTO t1 VALUES('abc', 150, 500000, 210, 'первая строка');
''')
conn.commit()

c.execute('''
SELECT *
FROM t1;
''')
pp.pprint(c.fetchall())


conn.close()


№3
import sqlite3
import pprint
conn = sqlite3.connect('Shop3.sqlite')
c = conn.cursor()
pp = pprint.PrettyPrinter(indent=1, width=60, compact=False)

conn.execute('''
create table IF NOT EXISTS customers (
  id_customer integer,
  name char(50) NOT NULL,
  email char(50) NOT NULL UNIQUE,
  PRIMARY KEY (id_customer))''')

conn.execute('''
create table IF NOT EXISTS vendors (
  id_vendor integer,
  name char(50) NOT NULL,
  city char(30) NOT NULL,
  address char(100) NOT NULL,
  PRIMARY KEY (id_vendor))''')

conn.execute('''
create table IF NOT EXISTS sale (
  id_sale integer,
  id_customer int NOT NULL,
  date_sale date NOT NULL DEFAULT GETDATE(),
  PRIMARY KEY (id_sale),
  FOREIGN KEY (id_customer) REFERENCES customers (id_customer))''')

conn.execute('''
create table IF NOT EXISTS incoming (
  id_incoming integer,
  id_vendor int NOT NULL,
  date_incoming date NOT NULL DEFAULT GETDATE(),
  PRIMARY KEY (id_incoming),
  FOREIGN KEY (id_vendor) REFERENCES vendors (id_vendor))''')

conn.execute('''
create table IF NOT EXISTS products (
  id_product integer,
  name char(100) NOT NULL,
  author  char(50) NOT NULL,
  PRIMARY KEY (id_product))''')

conn.execute('''
create table IF NOT EXISTS prices (
  id_product integer,
  date_price_changes date NOT NULL,
  price double NOT NULL CHECK (price>0),
  PRIMARY KEY (id_product, date_price_changes),
  FOREIGN KEY (id_product) REFERENCES products (id_product))''')

conn.execute('''
create table IF NOT EXISTS magazine_sales (
  id_sale int NOT NULL,
  id_product int NOT NULL,
  quantity int NOT NULL,
  PRIMARY KEY (id_sale, id_product),
  FOREIGN KEY (id_sale) REFERENCES sale (id_sale),
  FOREIGN KEY (id_product) REFERENCES products (id_product))''')

conn.execute('''
create table IF NOT EXISTS magazine_incoming (
  id_incoming int NOT NULL,
  id_product int NOT NULL,
  quantity int NOT NULL,
  PRIMARY KEY (id_incoming, id_product),
  FOREIGN KEY (id_incoming) REFERENCES incoming (id_incoming),
  FOREIGN KEY (id_product) REFERENCES products (id_product))''')

c.execute('''
INSERT INTO vendors  (name, city, address) VALUES
 ('Вильямс', 'Москва', 'ул.Лесная, д.43'),
 ('Дом печати', 'Минск', 'пр.Ф.Скорины, д.18'),
 ('БХВ-Петербург', 'Санкт-Петербург', 'ул.Есенина, д.5');
 ''')
conn.commit()

c.execute('''
INSERT INTO customers  (name, email) VALUES
 ('Иванов Сергей', 'sergo@mail.ru'),
 ('Ленская Катя', 'lenskay@yandex.ru'),
 ('Демидов Олег', 'demidov@gmail.ru'),
 ('Афанасьев Виктор', 'victor@mail.ru'),
 ('Пажская Вера', 'verap@rambler.ru');
 ''')
conn.commit()

c.execute('''
INSERT INTO products  (name, author) VALUES
 ('Стихи о любви', 'Андрей Вознесенский'),
 ('Собрание сочинений, том 2', 'Андрей Вознесенский'),
 ('Собрание сочинений, том 3', 'Андрей Вознесенский'),
 ('Русская поэзия', 'Николай Заболоцкий'),
 ('Машенька', 'Владимир Набоков'),
 ('Доктор Живаго', 'Борис Пастернак'),
 ('Наши', 'Сергей Довлатов'),
 ('Приглашение на казнь', 'Владимир Набоков'),
 ('Лолита', 'Владимир Набоков'),
 ('Темные аллеи', 'Иван Бунин'),
 ('Дар', 'Владимир Набоков'),
 ('Сын вождя', 'Юлия Вознесенская'),
 ('Эмигранты', 'Алексей Толстой'),
 ('Горе от ума', 'Александр Грибоедов'),
 ('Анна Каренина', 'Лев Толстой'),
 ('Повести и рассказы', 'Николай Лесков'),
 ('Антоновские яблоки', 'Иван Бунин'),
 ('Мертвые души', 'Николай Гоголь'),
 ('Три сестры', 'Антон Чехов'),
 ('Беглянка', 'Владимир Даль'),
 ('Идиот', 'Федор Достоевский'),
 ('Братья Карамазовы', 'Федор Достоевский'),
 ('Ревизор', 'Николай Гоголь'),
 ('Гранатовый браслет', 'Александр Куприн');
 ''')
conn.commit()

c.execute('''
INSERT INTO incoming  (date_incoming) VALUES
 ('2011-04-10'),
 ('2011-04-11'),
 ('2011-04-12');
 ''')
conn.commit()

c.execute('''
INSERT INTO magazine_incoming  (id_incoming, id_product, quantity) VALUES
 ('1', '1', '10'),
 ('1', '2', '5'),
 ('1', '3', '7'),
 ('1', '4', '10'),
 ('1', '5', '10'),
 ('1', '6', '8'),
 ('1', '18', '8'),
 ('1', '19', '8'),
 ('1', '20', '8'),
 ('2', '7', '10'),
 ('2', '8', '10'),
 ('2', '9', '6'),
 ('2', '10', '10'),
 ('2', '11', '10'),
 ('2', '21', '10'),
 ('2', '22', '10'),
 ('2', '23', '10'),
 ('2', '24', '10'),
 ('3', '12', '10'),
 ('3', '13', '10'),
 ('3', '14', '10'),
 ('3', '15', '10'),
 ('3', '16', '10'),
 ('3', '17', '10');
 ''')
conn.commit()

c.execute('''
INSERT INTO prices  (date_price_changes, price) VALUES
 ('2011-04-10', '100'),
 ('2011-04-10', '130'),
 ('2011-04-10', '90'),
 ('2011-04-10', '100'),
 ('2011-04-10', '110'),
 ('2011-04-10', '85'),
 ('2011-04-11', '95'),
 ('2011-04-11', '100'),
 ('2011-04-11', '79'),
 ('2011-04-11', '49'),
 ('2011-04-11', '105'),
 ('2011-04-12', '85'),
 ('2011-04-12', '135'),
 ('2011-04-12', '100'),
 ('2011-04-12', '90'),
 ('2011-04-12', '75'),
 ('2011-04-12', '90'),
 ('2011-04-10', '150'),
 ('2011-04-10', '140'),
 ('2011-04-10', '85'),
 ('2011-04-11', '105'),
 ('2011-04-11', '70'),
 ('2011-04-11', '65'),
 ('2011-04-11', '130');
 ''')
conn.commit()

c.execute('''
INSERT INTO sale  (id_customer, date_sale) VALUES
 ('2', '2011-04-11'),
 ('3', '2011-04-11'),
 ('5', '2011-04-11');
 ''')
conn.commit()

c.execute('''
INSERT INTO magazine_sales  (id_sale, id_product, quantity) VALUES
 ('1', '1', '1'),
 ('1', '5', '1'),
 ('1', '7', '1'),
 ('2', '2', '1'),
 ('3', '1', '1'),
 ('3', '7', '1');
''')
conn.commit()

conn.close()