Godkendelsesopgave E

Opgave 1

a)  CREATE TABLE restaurants (rid int PRIMARY KEY AUTO_INCREMENT, restaurant VARCHAR(100) NOT NULL);
# Du skal muligvis lave din rid værdi "UNIQUE" for at sørge for der ikke kan eksistere to restauranter med samme rid

b)  CREATE TABLE michelin (rid int NOT NULL, star int NOT NULL);
# du kan også bruge denne her "rid INT NOT NULL, FOREIGN KEY(rid) REFERENCES restaurants(rid)" for at sikre dig
# at restauranten findes. Den tjekker bare om rid er i restaurants. Hvis ikke kan man ikke lave en bedømmelse

Opgave 2

a)  INSERT INTO restaurants (restaurant) VALUES ("AOC");
INSERT INTO restaurants (restaurant) VALUES ("EatIt");
INSERT INTO restaurants (restaurant) VALUES ("Era Ora");
INSERT INTO restaurants (restaurant) VALUES ("Geranium");
INSERT INTO restaurants (restaurant) VALUES ("Kadeau");
INSERT INTO restaurants (restaurant) VALUES ("Maharaja");
INSERT INTO restaurants (restaurant) VALUES ("Noma");


b)  INSERT INTO michelin (rid, star) VALUES ("4","3");
INSERT INTO michelin (rid, star) VALUES ("1","2");
INSERT INTO michelin (rid, star) VALUES ("3","1");
INSERT INTO michelin (rid, star) VALUES ("5","1");
INSERT INTO michelin (rid, star) VALUES ("2","0");
INSERT INTO michelin (rid, star) VALUES ("6","0");
INSERT INTO michelin (rid, star) VALUES ("7","0");

Opgave 3

a)  SELECT*FROM restaurants;
b)  SELECT*FROM michelin WHERE star > 0 ORDER BY rid;
# i b opgaven vælger du alle felter hvor stjernerne er over 0 men du mangler et statement der afgrænser det så
# du ikke får værdierne når den er over 3 hint: "AND"

Opgave 4

a)  SELECT restaurant,star FROM restaurants,michelin WHERE restaurants.rid = michelin.rid AND star > 0;
b)  SELECT restaurant FROM restaurants,michelin WHERE restaurants.rid = michelin.rid AND star = 0;