CREATE TABLE Staff(
    Firstname VARCHAR(20) NOT NULL,
    Lastname VARCHAR(30) NOT NULL,
    PhoneNumber VARCHAR(10) NOT NULL,
    CONSTRAINT check_phone CHECK (PhoneNumber >=2000000 AND PhoneNumber<=9999999 AND PhoneNumber /10000%100<>11),
    Email VARCHAR(70) NOT NULL,
    TypeJob VARCHAR(20) NOT NULL,
    StaffID VARCHAR(30) NOT NULL,
    PRIMARY KEY (StaffID),
    JobPlace VARCHAR(20) NOT NULL,
    FOREIGN KEY (JobPlace) REFERENCES Facility(TypeFacility)
);

CREATE TABLE Visitor(
    Firstname VARCHAR(20),
    Lastname VARCHAR(30) NOT NULL,
    PhoneNumber VARCHAR(10),
    CONSTRAINT check_phone CHECK (PhoneNumber >=2000000 AND PhoneNumber<=9999999 AND PhoneNumber /10000%100<>11),
    Email VARCHAR(70),
    Address VARCHAR(50),
    City VARCHAR(20),
    Country VARCHAR(20),
    BirthDate DATE,
    VisitorNb VARCHAR(30) NOT NULL,
    PRIMARY KEY (VisitorNb),
    HotelStay VARCHAR(30) NOT NULL,
    FOREIGN KEY (HotelStay) REFERENCES Hotel(HotelName)
);

CREATE TABLE ParkDistrict(
    DistrictName VARCHAR(20) NOT NULL,
    PRIMARY KEY (DistrictName),
    Theme VARCHAR(20) NOT NULL,
    NbRestaurant INTEGER NOT NULL,
    NbAttraction INTEGER NOT NULL,
    NbShop INTEGER NOT NULL
);

CREATE TABLE DisneyCharacter(
    CharacterName VARCHAR(20) NOT NULL,
    PRIMARY KEY (CharacterName),
    DisneyFrom VARCHAR(40 ) NOT NULL,
    OpeningTime TIME NOT NULL,
    ClosingTime TIME NOT NULL,
    DayTour VARCHAR(10) NOT NULL
);


CREATE TABLE ParkTicket(
    TicketNb VARCHAR(30) NOT NULL,
    PRIMARY KEY (TicketNb),
    TypeTicket VARCHAR(10) NOT NULL,
    NbDay INTEGER NOT NULL,
    Price INTEGER NOT NULL,
    VIP VARCHAR(3) DEFAULT "No",
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    CONSTRAINT check_vip CHECK (VIP IN ("Yes", "No")),
    CONSTRAINT check_typeticket CHECK (TypeTicket IN ("one park", "two parks"))
);

CREATE TABLE Facility(
    FacilityName VARCHAR(30) NOT NULL,
    PRIMARY KEY (FacilityName),
    TypeFacility VARCHAR(10) NOT NULL,
    DistrictName VARCHAR(20) NOT NULL,
    FOREIGN KEY (DistrictName) REFERENCES ParkDistrict(DistrictName),
    CONSTRAINT check_typefacility CHECK (TypeFacility IN ("hotel", "restaurant", "shop", "attraction", "other"))
);

CREATE TABLE Attraction(
    AttractionName VARCHAR(30) NOT NULL,
    FOREIGN KEY (AttractionName) REFERENCES Facility(FacilityName),
    MinSizeReq INTEGER DEFAULT 0,
    OpeningTime TIME NOT NULL,
    ClosingTime TIME NOT NULL,
    NbWagon INTEGER
);

CREATE TABLE Shop(
    ShopName VARCHAR(30) NOT NULL,
    FOREIGN KEY (ShopName) REFERENCES Facility(FacilityName),
    NbProduct INTEGER,
    TypeProduct VARCHAR(30) NOT NULL,
    CONSTRAINT check_typeproduct CHECK (TypeProduct IN ("Fashion and "accessories", "cosplay", "memories", "game", "gift"))
);

CREATE TABLE Restaurant(
    RestaurantName VARCHAR(30) NOT NULL,
    FOREIGN KEY (RestaurantName) REFERENCES Facility(FacilityName),
    TypeService VARCHAR(20) NOT NULL,
    TypeRest VARCHAR(20) NOT NULL,
    FoodType VARCHAR(20) NOT NULL,
    PriceRange VARCHAR(6) NOT NULL,
    CONSTRAINT check_typeservice CHECK (TypeService IN ("buffet", "walk-in service", "table service")),
    CONSTRAINT check_typerest CHECK (TypeRest IN ("bar", "café", "restaurant")),
    CONSTRAINT check_foodType CHECK (FoodType IN ("snack", "fast food", "international Food", "american dinner", "italian food", "french food", "steak house")),
    CONSTRAINT check_pricerange CHECK (PriceRange IN ("low", "medium", "high"))
);

CREATE TABLE Hotel(
    HotelName VARCHAR(30) NOT NULL,
    FOREIGN KEY (HotelName) REFERENCES Facility(FacilityName),
    NbStar INTEGER NOT NULL,
    RangePrice VARCHAR(6) NOT NULL,
    CONSTRAINT check_pricerange CHECK (PriceRange IN ("low", "medium", "high"))
    );

CREATE TABLE `Show`(
    ShowName VARCHAR(25) NOT NULL,
    TypeShow VARCHAR(20) NOT NULL,
    ShowID INT NOT NULL,
    PRIMARY KEY (ShowID),
    OpeningTime TIME NOT NULL,
    Location VARCHAR(20) NOT NULL,
    DistrictName VARCHAR(20) NOT NULL,
    FOREIGN KEY (DistrictName) REFERENCES ParkDistrict(DistrictName),
    CONSTRAINT check_typeshow CHECK (TypeShow IN ("entertainment", "stageshow", "parade", "nightshow"))
);

CREATE TABLE Purchase(
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    ShopName VARCHAR(20) NOT NULL,
    FOREIGN KEY (ShopName) REFERENCES Shop(ShopName),
    PRIMARY KEY (VisitorNb, ShopName),
    BillDate DATE NOT NULL,
    BillTime TIME NOT NULL,
    BillPrice FLOAT NOT NULL
);

CREATE TABLE PlayAttraction(
    AttractionName VARCHAR(30) NOT NULL,
    FOREIGN KEY (AttractionName) REFERENCES Attraction(AttractionName),
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    PRIMARY KEY (VisitorNb, AttractionName),
    DatePlay DATE,
    TimePlay TIME
);

CREATE TABLE StaffShow(
    StaffID INTEGER NOT NULL,
    FOREIGN KEY (StaffID) REFERENCES Staff(StaffID),
    ShowName VARCHAR(25) NOT NULL,
    FOREIGN KEY (ShowID) REFERENCES `Show`(ShowID),
    PRIMARY KEY (ShowName, StaffID)
);

CREATE TABLE MeetingCharacter(
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    CharacterName VARCHAR(20) NOT NULL,
    FOREIGN KEY (CharacterName) REFERENCES DisneyCharacter(CharacterName),
    PRIMARY KEY (CharacterName, VisitorNb),
    Time TIME
);

CREATE TABLE Meal(
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    RestaurantName VARCHAR(30) NOT NULL,
    FOREIGN KEY (RestaurantName) REFERENCES Restaurant(RestaurantName),
    PRIMARY KEY (RestaurantName, VisitorNb),
    NbPerson INTEGER,
    BillPrice FLOAT NOT NULL,
    TimeMeal TIME NOT NULL,
    DateMeal DATE NOT NULL
);

CREATE TABLE Accomodation(
    HotelName VARCHAR(30) NOT NULL,
    FOREIGN KEY (HotelName) REFERENCES Hotel(HotelName),
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    PRIMARY KEY (VisitorNb, HotelName),
    RoomNumber INTEGER NOT NULL,
    BillPrice FLOAT NOT NULL,
    DateFirst DATE NOT NULL,
    DateLast DATE NOT NULL
);

CREATE TABLE ShowAttended(
    VisitorNb INTEGER NOT NULL,
    FOREIGN KEY (VisitorNb) REFERENCES Visitor(VisitorNb),
    ShowID INTEGER NOT NULL,
    FOREIGN KEY (ShowID) REFERENCES `Show`(ShowID),
    PRIMARY KEY (ShowID,VisitorNb),
    ShowDate DATE NOT NULL
);

INSERT INTO `Show` VALUES ("Disney's Christmas Parade", "parade", "P1", "11:50", "Parade Route", "Parade Route");
INSERT INTO `Show` VALUES ("Disney's Christmas Parade", "parade", "P2", "13:15", "Parade Route", "Parade Route");
INSERT INTO `Show` VALUES ("Mickey's Anniversary Cupcake Celebration", "parade", "P3", "16:45", "Parade Route", "Parade Route");
INSERT INTO `Show` VALUES ("Disney Stars on Parade", "parade", "P4", "17:00", "Parade Route", "Parade Route");
INSERT INTO `Show` VALUES ("Mickey's Magical Christmas Lights", "nightshow", "N1", "18:30", "Town Square", "Main Street");
INSERT INTO `Show` VALUES ("Celebrate! 90 of Mickey", "nightshow", "N2", "19:50", "Central Plaza", "Main Street");
INSERT INTO `Show` VALUES ("Disney Illuminations", "nightshow", "N3", "20:00", "Central Plaza" "Main Street");
INSERT INTO `Show` VALUES ("Let's Sing Chritmas!", "stageshow", "S1", "12:15", "Videopolis Theatre", "DiscoverLand");
INSERT INTO `Show` VALUES ("Let's Sing Chritmas!", "stageshow", "S2", "13:30", "Videopolis Theatre", "DiscoverLand");
INSERT INTO `Show` VALUES ("A Merry Stitchmas", "stageshow", "S3", "13:50", "Royal Castle Stage", "Fantasyland");
INSERT INTO `Show` VALUES ("A Merry Stitchmas", "stageshow", "S4", "14:30", "Royal Castle Stage", "Fantasyland");
INSERT INTO `Show` VALUES ("A Merry Stitchmas", "stageshow", "S5", "15:10", "Royal Castle Stage", "Fantasyland");
INSERT INTO `Show` VALUES ("Mickey's PhilharMagic", "entertainment", "E1", "11:00", "Discoveryland Theatre", "Discoveryland");
INSERT INTO Show VALUES ("Mickey's PhilharMagic", "entertainment", "E2", "17:00", "Discoveryland Theatre", "Discoveryland");

INSERT INTO Hotel VALUES ("Disneyland Hotel", 5, "high");
INSERT INTO Hotel VALUES ("Disney's Hotel New York", 4, "high");
INSERT INTO Hotel VALUES ("Disney's Newport Bay Club", 4, "high");
INSERT INTO Hotel VALUES ("Disney's sequoia lodge", 3, "medium");
INSERT INTO Hotel VALUES ("Disney's Hotel Cheyenne", 2, "medium");
INSERT INTO Hotel VALUES ("Disney's Hotel Santa Fe", 2, "medium");

INSERT INTO Restaurant VALUES ("Auberge de Cendrillon", "table service", "restaurant", "american dinner", "high");
INSERT INTO Restaurant VALUES ("Au chalet de la marionette", "walk-in service", "restaurant", "fast food", "low");
INSERT INTO Restaurant VALUES ("Café Hyperion", "walk-in service", "cafe", "fast food", "low");
INSERT INTO Restaurant VALUES ("California grill", "table service", "restaurant", "steak house", "high");
INSERT INTO Restaurant VALUES ("cape cod", "buffet", "restaurant", "international Food", "high");
INSERT INTO Restaurant VALUES ("Captain's Quarters", "walk-in service", "bar", "snack", "medium");
INSERT INTO Restaurant VALUES ("Pizzeria Bella notte", "walk-in service", "restaurant", "italian food", "low");
INSERT INTO Restaurant VALUES ("Walt's", "table service", "restaurant", "french food", "high");

INSERT INTO Shop VALUES ("Disney Fashion", NULL, "Fashion and accessories");
INSERT INTO Shop VALUES ("Disneyana collectibles", 63, "memories");
INSERT INTO Shop VALUES ("Emporiem",42, "cosplay");
INSERT INTO Shop VALUES ("La boutique de chateau", NULL, "gift") ;
INSERT INTO Shop VALUES ("La chaumiere des sept nains", 56, "game") ;
INSERT INTO Shop VALUES ("Le coffre du capitaine", 78, "game") ;
INSERT INTO Shop VALUES ("Lilly's Boutique", NULL, "gift");
INSERT INTO Shop VALUES ("Main street motors", 82, "Fashion and accessories");


INSERT INTO Attraction VALUES ("it's a small world", 0, "10:00", "18:0"0,4);
INSERT INTO Attraction VALUES ("Big Thunder Mountain", 102, "10:30", "17:00", 8);
INSERT INTO Attraction VALUES ("Crush's Coaster", 107, "10:00", "19:00", 4);
INSERT INTO Attraction VALUES ("Indiana Jones", 140, "10:00", "19:00", 7);
INSERT INTO Attraction VALUES ("Peter pan's flight", 0, "10:30", "18:00", 6);
INSERT INTO Attraction VALUES ("Pirates of the caribbean", 0, "10:00", "19:00", 2);
INSERT INTO Attraction VALUES ("RC Racer", 120, "10:30", "19:00", 10);
INSERT INTO Attraction VALUES ("Rock"n"Roller Caster", 120, "10:00", "19:00", 12);

INSERT INTO Facility VALUES("Rock"n"Roller Caster", "attraction", "Adventureland");
INSERT INTO Facility VALUES("it's a small world", "attraction", "Fantasyland");
INSERT INTO Facility VALUES("Big Thunder Mountain", "attraction", "Discoverland");
INSERT INTO Facility VALUES("Crush's Coaster", "attraction", "Adventureland");
INSERT INTO Facility VALUES("Indiana Jones", "attraction", "Frontierland");
INSERT INTO Facility VALUES("Peter pan's flight", "attraction", "Fantasyland");
INSERT INTO Facility VALUES("Pirates of the caribbean", "attraction", "Discoverland");
INSERT INTO Facility VALUES("RC Racer", "attraction", "Frontierland");
INSERT INTO Facility VALUES("Auberge de Cendrillon", "restaurant", "Main street");
INSERT INTO Facility VALUES("Au chalet de la marionette", "restaurant", "Discoverland");
INSERT INTO Facility VALUES("Café Hyperion", "restaurant", "Fantasyland");
INSERT INTO Facility VALUES("California grill", "restaurant", "Frontierland");
INSERT INTO Facility VALUES("cape cod", "restaurant", "Adventureland");
INSERT INTO Facility VALUES("Captain's Quarters", "restaurant", "Main street");
INSERT INTO Facility VALUES("Pizzeria Bella notte", "restaurant", "Main street");
INSERT INTO Facility VALUES("Walt's", "restaurant", "Main street");
INSERT INTO Facility VALUES("Main street motors", "shop", "Main street");
INSERT INTO Facility VALUES("Disney Fashion", "shop", "Main street");
INSERT INTO Facility VALUES("Disneyana collectibles", "shop", "Discoverland");
INSERT INTO Facility VALUES("Emporiem", "shop", "Frontierland");
INSERT INTO Facility VALUES("La boutique de chateau", "shop", "Fantasyland");
INSERT INTO Facility VALUES("La chaumiere des sept nains", "shop", "Fantasyland");
INSERT INTO Facility VALUES("Le coffre du capitaine", "shop", "Adventureland") ;
INSERT INTO Facility VALUES("Lilly's Boutique", "shop", "Discoverland");
INSERT INTO Facility VALUES("Disneyland Hotel", "hotel", "Hotel area");
INSERT INTO Facility VALUES("Disney's Hotel New York", "hotel", "Hotel area");
INSERT INTO Facility VALUES("Disney's Newport Bay Club", "hotel", "Hotel area");
INSERT INTO Facility VALUES("Disney's sequoia lodge", "hotel", "Hotel area");
INSERT INTO Facility VALUES("Disney's Hotel Cheyenne", "hotel", "Hotel area");
INSERT INTO Facility VALUES("Disney's Hotel Santa Fe", "hotel", "Hotel area");

INSERT INTO DisneyCharacter VALUES ("Stitch", "Lilo&Stitch", "14:00", "16:00", "Wednesday");
INSERT INTO DisneyCharacter VALUES ("Anna", "Frozen", "10:00", "11:30", "Monday");
INSERT INTO DisneyCharacter VALUES ("Jack Sparrow", "Pirates of the caribean", "14:00", "15:15", "Tuesday");
INSERT INTO DisneyCharacter VALUES ("Mickey", "Mickey mouse", "15:00", "16:00", "Friday");
INSERT INTO DisneyCharacter VALUES ("Jack Skellington", "The Nightmare before christmas", "11:30", "12:30", "Wednesday");
INSERT INTO DisneyCharacter VALUES ("Aladdin", "Aladdin", "15:00", "15:45", "Thursday");

INSERT INTO Staff VALUES("Ines", "goncalves", "0617524903", "goncalvesi@disneyparis.fr", "waitress", "DS1", "restaurant");
INSERT INTO Staff VALUES("Thomas", "guillard", "0602041578", "guillardt@disneyparis.fr", "cashier", "DS2", "shop");
INSERT INTO Staff VALUES("thomas", "dupuis", " 0675352111", "dupuist@disneyparis.fr", " cleaner", "DS3", "hotel");
INSERT INTO Staff VALUES("elvina", "ferreta", "0689896260", "ferretae@disneyparis.fr", "maintenance person", "DS4", "attraction");
INSERT INTO Staff VALUES("kimberly", "piejak", "0601514289", "piejakk@disneyparis.fr", "receptionist", "DS5", "hotel");
INSERT INTO Staff VALUES("dorian", "raoux", "0628453710", "raouxd@disneyparis.fr", "barman", "DS6", "restaurant");
INSERT INTO Staff VALUES("zoe", "delrio", "0612514287", "delrioz@disneyparis.fr", "dancer", "DS7", "other");
INSERT INTO Staff VALUES("clara", "roux", "0614253698", "rouxc@disneyparis.fr", "dancer", "DS8", "other");
INSERT INTO Staff VALUES("damien", "marsilla", "0602320232", "marsillad@disneyparis.fr", "dancer", "DS9", "other");
INSERT INTO Staff VALUES("jean", "chini", "0678541236", "chinij@disneyparis.fr", "dancer", "DS10", "other");
INSERT INTO Staff VALUES("louise", "gontier", "0678521469", "gontierl@disneyparis.fr", "dancer", "DS11", "other");


INSERT INTO Visitor VALUES("Remi", "Lemonnier", "0684175234", "remil@gmail.com", "3 rue des tournesols", "Toulouse", "France", "1968-06-19", "DV1", "Disney's Newport Bay Club");
INSERT INTO Visitor VALUES("Tristan", "Cureau", "0676514892", "tristan.cureau@gmail.com", "114 chemin des cigales", "Paris", "France", "1999-09-20", "DV2", "Disney's Newport Bay Club");
INSERT INTO Visitor VALUES("Marion", "Perez", "0625841794", "perezzz@gmail.com", "Impasse Charles de Gaules", "Nice", "France", "2000-03-17", "DV3", "Disney's sequoia lodge");
INSERT INTO Visitor VALUES("Juliette", "Jeanin", "0601541298", "2jeaninJ@gmail.com", "44 Rue de la Victoire", "Lille", "France", "1982-12-12", "DV4", "Disneyland Hotel");
INSERT INTO Visitor VALUES("Melissa", "Bidois", "0628761485", "melissa.bidois@gmail.com", " 12 Impasse Gaston Berger", "Marseille", "France", "1967-01-04", "DV5", "Disneyland Hotel");
INSERT INTO Visitor VALUES("Maxime", "Monroi", "0624856175", "monroim@gmail.com", "1 rue des Antonins", "Lyon", "France", "1984-07-14", "DV6", "Disney's Hotel Santa Fe");

INSERT INTO ParkDistrict VALUES ("Fantasyland", "imagination", 3, 9, 6);
INSERT INTO ParkDistrict VALUES ("Main street", "disney world", 11, 0, 16);
INSERT INTO ParkDistrict VALUES ("Discoverland", "new ewperiences", 4, 10, 4);
INSERT INTO ParkDistrict VALUES ("Adventureland", "adventure", 3, 11, 3);
INSERT INTO ParkDistrict VALUES ("Frontierland", "magic", 4, 12, 6);
INSERT INTO ParkDistrict VALUES ("Hotel Area", "chill", 0, 0, 0);

INSERT INTO ParkTicket VALUES ("DT1", "two parks", 3, 201 , "No", "DV1");
INSERT INTO ParkTicket VALUES ("DT2", "two parks", 4, 239 , "No", "DV2");
INSERT INTO ParkTicket VALUES ("DT3", "two parks", 1, 73 , "Yes", "DV3");
INSERT INTO ParkTicket VALUES ("DT4", "one parks", 1, 53 , "Yes", "DV4");
INSERT INTO ParkTicket VALUES ("DT5", "one parks", 2, 112 , "No", "DV5");
INSERT INTO ParkTicket VALUES ("DT6", "two parks", 3, 201 , "No", "DV6");


INSERT INTO Purchase VALUES ("Disneyana collectibles", "DV1", "2018-11-25", "17:11",35.55);
INSERT INTO Purchase VALUES ("Disney Fashion", "DV2", "2018-11-12", "11:20",14.95);
INSERT INTO Purchase VALUES ("Disney Fashion", "DV5", "2018-11-28", "10:04",25.95);
INSERT INTO Purchase VALUES ("Le coffre du capitaine", "DV5", "2018-11-28", "17:54",72.00) ;
INSERT INTO Purchase VALUES("Main street motors", "DV6", "2018-11-14", "12:10", 33.78);
INSERT INTO Purchase VALUES ("Emporiem", "DV6", "2018-11-13", "18:23",104.20);

INSERT INTO PlayAttraction VALUES ("it's a small world", "DV1", "2018-11-25", "16:01");
INSERT INTO PlayAttraction VALUES ("Peter pan's flight", "DV2", "2018-11-11", "11:14");
INSERT INTO PlayAttraction VALUES ("RC Racer", "DV5", "2018-11-28", "17:48");
INSERT INTO PlayAttraction VALUES ("Rock'n'Roller Caster", "DV5", "2018-11-28", "15:18");
INSERT INTO PlayAttraction VALUES("Rock'n'Roller Caster", "DV6", "2018-11-14", "10:22");
INSERT INTO PlayAttraction VALUES ("Indiana Jones", "DV6", "2018-11-13", "16:35");

INSERT INTO StaffShow VALUES ("DS7", "P1");
INSERT INTO StaffShow VALUES ("DS10", "P1");
INSERT INTO StaffShow VALUES ("DS11", "P1");
INSERT INTO StaffShow VALUES ("DS9", "P1");
INSERT INTO StaffShow VALUES ("DS8", "P4");
INSERT INTO StaffShow VALUES ("DS9", "E2");
INSERT INTO StaffShow VALUES ("DS10", "N1");
INSERT INTO StaffShow VALUES ("DS11", "S3");

INSERT INTO MeetingCharacter VALUES ("DV2", "Stitch", "14:34");
INSERT INTO MeetingCharacter VALUES ("DV2", "Mickey"", "15:50");
INSERT INTO MeetingCharacter VALUES ("DV4", "Mickey", "15:44");
INSERT INTO MeetingCharacter VALUES ("DV6", "Jack Sparrow", "14:22");
INSERT INTO MeetingCharacter VALUES ("DV6", "Aladdin", "15:11");
INSERT INTO MeetingCharacter VALUES ("DV3", "Stitch", "15:03");

INSERT INTO Meal VALUES ("DV1", "cape cod", 3, 80.78, "14:02", "2018-11-25");
INSERT INTO Meal VALUES ("DV1", "California grill", 3, 79.30, "13:50", "2018-11-26");
INSERT INTO Meal VALUES ("DV3", "captain's Quarters", 1, 8.50, "16:34", "2018-11-02");
INSERT INTO Meal VALUES ("DV5", "Auberge de Cendrillon", 2, 52.10, "13 :46", "2018-11-28") ;
INSERT INTO Meal VALUES ("DV6", "Au chalet de la marionette", 4, "54.40, "12 :58", "2018-11-13") ;
INSERT INTO Meal VALUES ("DV2", "Au chalet de la marionette", 2, 33.99, "14 :13", "2018-11-11") ;

INSERT INTO Accomodation VALUES ("Disney's Newport Bay Club", "DV1", 4, 154.95, "2018-11-24", "2018-11-27");
INSERT INTO Accomodation VALUES ("Disney's Newport Bay Club", "DV2", 17, 99.98, "2018-09-16", "2018-09-18");
INSERT INTO Accomodation VALUES ("Disney's Newport Bay Club", "DV"2, 9, 204.50, "2018-11-10", "2018-11-15");
INSERT INTO Accomodation VALUES ("Disney's sequoia lodge", "DV3", 1, 46.00, "2018-11-02", "2018-11-03");
INSERT INTO Accomodation VALUES ("Disneyland Hotel", "DV4", 4, 77.96, "2018-10-10, "2018-10-11");
INSERT INTO Accomodation VALUES ("Disney's Hotel Santa Fe", "DV6", 6, 187.23, "2018-11-11", "2018-11-15");

INSERT INTO ShowAttended VALUES ("DV1", "P1", "2018-11-24");
INSERT INTO ShowAttended VALUES ("DV1", "N3", "2018-11-24");
INSERT INTO ShowAttended VALUES ("DV1", "S5", "2018-11-26");
INSERT INTO ShowAttended VALUES ("DV6", "E2", "2018-11-24");
INSERT INTO ShowAttended VALUES ("DV4", "P1", "2018-11-24");
INSERT INTO ShowAttended VALUES ("DV2", "P4", "2018-11-24");