Create Database, Create Tables,....

Homework_3.3_Losty.sql

CREATE DATABASE "Losty";

CREATE TABLE "Customer" (
	"ID"	INTEGER PRIMARY KEY AUTOINCREMENT,
	"First_name"	TEXT,
	"Last_name"	TEXT,
	"Email"	TEXT,
	"Phone_number"	TEXT
);

CREATE TABLE "Guide" (
	"ID"	INTEGER PRIMARY KEY AUTOINCREMENT,
	"First_name"	TEXT,
	"Last_name"	TEXT,
	"Email"	TEXT,
	"Phone_number"	TEXT
);

CREATE TABLE "Tour" (
	"ID"	INTEGER PRIMARY KEY AUTOINCREMENT,
	"Title"	TEXT,
	"Start_date"	TEXT,
	"End_date"	TEXT,
	"Price"	REAL
);

CREATE TABLE "GuideTour" (
	"ID"	INTEGER PRIMARY KEY AUTOINCREMENT,
	"GuideID"	INTEGER FOREIGNKEY,
	"TourID"	INTEGER FOREIGNKEY,
	"Guide_fee"	REAL
);

CREATE TABLE "Invoice_CustomerTour" (
	"ID"	INTEGER PRIMARY KEY AUTOINCREMENT,
	"CustomerID"	INTEGER FOREIGNKEY,
	"TourID"	INTEGER FOREIGNKEY,
	"Price"	REAL DATE TEXT
);