--create database ASCON

create table Customers(
	ID int,
	Liason_First_Name varchar(30), 
	Liason_Middle_Name varchar(30),
	Liason_Surname varchar (30), 
	School_Name varchar (30),
	Road_Address varchar (50),
	Town varchar (50), 
	Postcode varchar (30), 
	Acedemic_Level varchar(30), 
	Quantity_purchased int, 
	Income int
	);

Create table Products(
	Book_Name varchar(30),
	Book_Author_First_Name varchar(30), 
	Book_Author_Middle_Name varchar(30),
	Book_Author_Surname varchar(30),
	Publication_Year int,
	Genre varchar(30),
	Cost_Price int, 
	Retail_Price int, 
	Book_Weight varchar(30),
	Quantity_Stored int
	);