aGyaVJ7b

1DROP TABLE IF EXISTS Artist,Customers,Painting_Style,Purchase;
2
3CREATE TABLE Artist(
4        id INT AUTO_INCREMENT,
5        First_Name VARCHAR(25),
6        Last_Name VARCHAR(25),
7        Age VARCHAR(25),
8        dob DATE,
9        Nationality VARCHAR(25),
10        PRIMARY KEY (id)
11);
12
13 CREATE TABLE Customers(
14                id INT AUTO_INCREMENT,
15                Address VARCHAR(50),
16                Name VARCHAR(25),
17                Paintings_Bought VARCHAR(25),
18                PRIMARY KEY (id)
19);
20
21
22CREATE TABLE Painting_Style(
23                id INT AUTO_INCREMENT,
24                Sculpture VARCHAR(25),
25                Oil_Painting VARCHAR(25),
26                Pencil_Drawing VARCHAR(25),
27                Acrylic VARCHAR(25),
28                Artist_id INT,
29                PRIMARY KEY(id),
30                FOREIGN KEY(Artist_id)
31                        REFERENCES Artist(id)
32);
33CREATE TABLE Purchase(
34                id INT AUTO_INCREMENT NOT NULL,
35                Customer_id INT,
36                Painting_Style_id INT,
37                PRIMARY KEY (id),
38                FOREIGN KEY (Customer_id)
39                        REFERENCES Customer(id),
40                FOREIGN KEY (Painting_Style_id)
41                        REFERENCES Painting_Style(id)
42);