zHSawxqC

1DROP DATABASE IF EXISTS hunting;
2CREATE DATABASE hunting;
3
4use hunting;
5
6CREATE TABLE Animals(
7	id INT NOT NULL AUTO_INCREMENT,
8	weight INT,
9	PRIMARY KEY(id)
10);
11
12CREATE TABLE Dogs(
13	id INT NOT NULL,
14	name varchar(255),
15	breed varchar(255),
16  FOREIGN KEY (id) REFERENCES Animals(id)
17);
18
19CREATE TABLE Foxes(
20	id INT NOT NULL,
21	color varchar(255),
22  FOREIGN KEY (id) REFERENCES Animals(id)
23);
24
25CREATE TABLE Birds(
26	id INT NOT NULL,
27	wingspan INT,
28  FOREIGN KEY (id) REFERENCES Animals(id)
29);
30
31CREATE TABLE hunters(
32	id INT NOT NULL AUTO_INCREMENT,
33	PRIMARY KEY(id)
34);
35
36create table kills(
37	animalID int not null,
38	hunterID int not null,
39	foreign key (animalID) references Animals(id),
40	foreign key (hunterID) references hunters(id),
41	primary key(animalID, hunterID)
42);
43
44create table OwnerShip(
45	dogID int not null ,
46	hunterID int not null ,
47	foreign key (dogID) references Dogs(id),
48	foreign key (hunterID) references hunters(id),
49	primary key(dogID, hunterID)
50);