Chevrolet Express Conversion Van

SCHEME LOGIC RELATIONS IN QUESTIONS

CREATE TABLE SPECIES (IDS auto increment integer,
NAME varchar (10) not null,
image_link varchar (50),
INFO varchar (50),
primary_key (IDS));

CREATE TABLE PLANTS (IDP auto increment integer,
NAME varchar (10) not null,
varchar (10) not null,
PRICE integer not null,
STAGIONE_FIORITURA varchar (10) not null,
NUMERO_ESEMPLARI integer not null,
IDS integer not null,
IDPE integer not null,
primary_key (IDP),
FOREIGN KEY (IDS) references SPECIES (IDS)
FOREIGN KEY (IDPE) references SPECIES (IDPE));

CREATE TABLE CUSTOMERS (IDC auto increment integer,
varchar (10) not null,
NAME varchar (10) not null,
PHONE varchar (10) not null ,
GIORNO_PRENOTAZIONE integer not null,
MESE_PRENOTAZIONE varchar (10) not null,
ANNO_PRENOTAZIONE integer not null,
DATA_INTERVENTO varchar (10),
EVASION varchar (10) not null,
primary_key (IDC));

CREATE TABLE STAFF (IDPE auto increment integer,
NAME varchar (10) not null,
SURNAME varchar (10) not null,
DATA_NASCITA varchar (10 ) not null,
STATUS varchar (10) not null,
ANNO_ASSUNZIONE integer not null,
PRIMATY_KEY (IDPE));

CREATE TABLE OUTDOOR ACTIVITIES (IDA auto increment integer,
NAME varchar (10) not null, varchar
CODE (10) not null,
COST integer not null,
primary_key (IDA));

CREATE TABLE REQUIRES (IDC integer not null,
IDP integer not null,
FOREIGN KEY (IDC) references CUSTOMERS (IDC),
FOREIGN KEY (IDP) references PLANTS (IDP));



CREATE TABLE PLACE (IDA integer not null,
IDPE integer not null,
FOREIGN KEY (IDA) references external activities (IDA),
FOREIGN KEY (IDPE) PERSONAL references (IDPE));

CREATE TABLE REQUEST (IDC integer not null,
IDA integer not null,
FOREIGN KEY (IDC) references CUSTOMERS (IDC),
FOREIGN KEY (IDA) references external activities (IDA));