sqlite> CREATE TABLE Account
   ...> (
   ...> Account_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Username VARCHAR(20) UNIQUE,
   ...> Password VARCHAR(20),
   ...> Emailaddress VARCHAR(20) UNIQUE
   ...> );
sqlite>
sqlite> CREATE TABLE Seller
   ...> (
   ...> Account_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Name VARCHAR(20),
   ...> Postalcode VARCHAR(20),
   ...> Housenumber INT(5),
   ...> Verified BOOLEAN DEFAULT "FALSE",
   ...> CONSTRAINT Account_id_FK_Buyer FOREIGN KEY (Account_id) REFERENCES Buyer(Account_id)
   ...> );
sqlite>
sqlite> CREATE TABLE Buyer
   ...> (
   ...> Account_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Name VARCHAR(20),
   ...> Postalcode VARCHAR(20),
   ...> Housenumber INT(5),
   ...> CONSTRAINT Account_id_FK_Buyer FOREIGN KEY (Account_id) REFERENCES Buyer(Account_id)
   ...> );
sqlite>
sqlite> CREATE TABLE Product
   ...> (
   ...> Product_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Name VARCHAR(50),
   ...> Description VARCHAR(300)
   ...> );
sqlite>
sqlite> CREATE TABLE Article
   ...> (
   ...> Product_id VARCHAR(15) UNIQUE,
   ...> Seller_id VARCHAR(15) UNIQUE,
   ...> Discount_id VARCHAR(15) UNIQUE,
   ...> Price DOUBLE,
   ...> Used BOOLEAN DEFAULT "FALSE",
   ...> Stock INT NOT NULL,
   ...> CONSTRAINT Article_pk PRIMARY KEY (Product_id, Seller_id),
   ...> CONSTRAINT Product_id_FK_Product FOREIGN KEY (Product_id) REFERENCES Product(Product_id),
   ...> CONSTRAINT Seller_id_FK_Seller FOREIGN KEY (Seller_id) REFERENCES Seller(Account_id),
   ...> CONSTRAINT Used_FK_Seller FOREIGN KEY (Used) REFERENCES Seller(Verified),
   ...> CONSTRAINT Discount_id_FK_Discount FOREIGN KEY (Discount_id) REFERENCES Discount(Discount_id)
   ...> );
sqlite>
sqlite> CREATE TABLE Discount
   ...> (
   ...> Discount_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Expiration_date DATE,
   ...> Amount_Percentage DOUBLE NOT NULL
   ...> );
sqlite>
sqlite> CREATE TABLE ShoppingCart
   ...> (
   ...> Account_id VARCHAR(15) UNIQUE,
   ...> Product_id VARCHAR(15) UNIQUE,
   ...> Seller_id VARCHAR(15) UNIQUE,
   ...> Amount INT,
   ...> CONSTRAINT CHK_Amount CHECK(Article(Stock) > Amount),
   ...> CONSTRAINT ShoppingCart_PK PRIMARY KEY (Account_id, Product_id, Seller_id),
   ...> CONSTRAINT Account_id_FK_Buyer FOREIGN KEY (Account_id) REFERENCES Buyer(Account_id),
   ...> CONSTRAINT Product_id_FK_Article FOREIGN KEY (Product_id) REFERENCES Article(Product_id),
   ...> CONSTRAINT Seller_id_FK_Article FOREIGN KEY (Seller_id) REFERENCES Article(Seller_id)
   ...> );
Error: no such column: Stock
sqlite>
sqlite> CREATE TABLE Transaction
   ...> (
   ...> Transaction_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Account_id VARCHAR(15) UNIQUE,
   ...> Bank_account_number INT(10),
   ...> Postalcode VARCHAR(20),
   ...> Housenumber INT(5),
   ...> Status BOOLEAN DEFAULT "FALSE",
   ...> CONSTRAINT Account_id_FK_Buyer FOREIGN KEY (Account_id) REFERENCES Buyer(Account_id)
   ...> );
Error: near "Transaction": syntax error
sqlite>
sqlite> CREATE TABLE OrderedProduct
   ...> (
   ...> Transaction_id VARCHAR(15) UNIQUE,
   ...> Product_id VARCHAR(15) UNIQUE,
   ...> Seller_name VARCHAR(20),
   ...> Price DOUBLE,
   ...> CONSTRAINT OrderedProduct_PK PRIMARY KEY (Transaction_id, Product_id),
   ...> CONSTRAINT Transaction_id_FK_Transaction FOREIGN KEY (Transaction_id) REFERENCES Transaction(Transaction_id),
   ...> CONSTRAINT Product_id_FK_Article FOREIGN KEY (Product_id) REFERENCES Article(Product_id),
   ...> CONSTRAINT Seller_id_FK_Article FOREIGN KEY (Seller_id) REFERENCES Article(Seller_id)
   ...> );
Error: near "Transaction": syntax error
sqlite>
sqlite> CREATE TABLE Review
   ...> (
   ...> Review_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Account_id VARCHAR(15) UNIQUE,
   ...> Title VARCHAR(20),
   ...> Rating INT NOT NULL,
   ...> Content VARCHAR(300),
   ...> CONSTRAINT Account_id_FK_Account FOREIGN KEY (Account_id) REFERENCES Buyer(Account_id),
   ...> CONSTRAINT CHK_Rating CHECK(Rating < 11)
   ...> );
sqlite>
sqlite> CREATE TABLE ProductReview
   ...> (
   ...> Review_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Product_id VARCHAR(15) UNIQUE,
   ...> CONSTRAINT Review_id_FK_Review FOREIGN KEY (Review_id) REFERENCES Review(Review_id),
   ...> CONSTRAINT Product_id_FK_Product FOREIGN KEY (Product_id) REFERENCES Product(Product_id)
   ...> );
sqlite>
sqlite> CREATE TABLE SellerReview
   ...> (
   ...> Review_id VARCHAR(15) UNIQUE PRIMARY KEY,
   ...> Seller_id VARCHAR(15) UNIQUE NOT NULL,
   ...> CONSTRAINT Review_id_FK_Review FOREIGN KEY (Review_id) REFERENCES Review(Review_id),
   ...> CONSTRAINT Seller_id_FK_Seller FOREIGN KEY (Seller_id) REFERENCES Seller(Account_id)
   ...> );
sqlite>
sqlite> CREATE TABLE FavoriteArticle
   ...> (
   ...> Product_id VARCHAR(15) UNIQUE,
   ...> Seller_id VARCHAR(15) UNIQUE,
   ...> Account_id VARCHAR(15) UNIQUE NOT NULL,
   ...> CONSTRAINT FavoriteArticle_PK PRIMARY KEY (Product_id, Seller_id, Account_id),
   ...> CONSTRAINT Account_id_FK_Account FOREIGN KEY (Account_id) REFERENCES Account(Account_id),
   ...> CONSTRAINT Product_id_FK_Article FOREIGN KEY (Product_id) REFERENCES Article(Product_id),
   ...> CONSTRAINT Seller_id_FK_Article FOREIGN KEY (Seller_id) REFERENCES Article(Seller_id)
   ...> );
sqlite>
sqlite> CREATE TABLE ProductSuggestions
   ...> (
   ...> Product_id VARCHAR(15) UNIQUE,
   ...> Account_id VARCHAR(15) UNIQUE NOT NULL,
   ...> CONSTRAINT ProductSuggestions_PK PRIMARY KEY (Product_id, Account_id),
   ...> CONSTRAINT Account_id_FK_Account FOREIGN KEY (Account_id) REFERENCES Account(Account_id)
   ...> );
sqlite>
sqlite>
sqlite>
sqlite>