lf5/data/data.surrealql

CREATE Address:101 CONTENT {
    street: 'Dorfstraße',
    house_number: '74',
    postal_code: '24354',
    city: 'Weseby'
};

CREATE Address:102 CONTENT {
    street: 'Westerjork 74',
    house_number: '76',
    postal_code: '21635',
    city: 'Jork'
};

CREATE Address:103 CONTENT {
    street: 'Molkereiwegkundekunde',
    house_number: '13',
    postal_code: '19217',
    city: 'Dechow'
};

CREATE Address:2001 CONTENT {
    street: 'Eppendorfer Landstrasse',
    house_number: '104',
    postal_code: '20249',
    city: 'Hamburg'
};

CREATE Address:2002 CONTENT {
    street: 'Ohmstraße',
    house_number: '23',
    postal_code: '22765',
    city: 'Hamburg'
};

CREATE Address:2003 CONTENT {
    street: 'Bilser Berg',
    house_number: '6',
    postal_code: '20459',
    city: 'Hamburg'
};

CREATE Address:2004 CONTENT {
    street: 'Alter Teichweg',
    house_number: '95',
    postal_code: '22049',
    city: 'Hamburg'
};

CREATE Address:2005 CONTENT {
    street: 'Stübels',
    house_number: '10',
    postal_code: '22835',
    city: 'Barsbüttel'
};

CREATE Address:2006 CONTENT {
    street: 'Grotelertwiete',
    house_number: '4a',
    postal_code: '21075',
    city: 'Hamburg'
};

CREATE Address:2007 CONTENT {
    street: 'Küstersweg',
    house_number: '3',
    postal_code: '21079',
    city: 'Hamburg'
};

CREATE Address:2008 CONTENT {
    street: 'Neugrabener Bahnhofstraße',
    house_number: '30',
    postal_code: '21149',
    city: 'Hamburg'
};

CREATE Address:2009 CONTENT {
    street: 'Elbchaussee',
    house_number: '228',
    postal_code: '22605',
    city: 'Hamburg'
};

CREATE Supplier:101 CONTENT {
    name: 'Bio-Hof Müller',
    phone: '04354-9080',
    email: 'mueller@biohof.de',
    address: Address:101
};

CREATE Supplier:102 CONTENT {
    name: 'Obst-Hof Altes Land',
    phone: '04162-4523',
    email: 'info@biohof-altesland.de',
    address: Address:102
};

CREATE Supplier:103 CONTENT {
    name: 'Molkerei Henning',
    phone: '038873-8976',
    email: 'info@molkerei-henning.de',
    address: Address:103
};

CREATE Customer:2001 CONTENT {
    last_name: 'Wellensteyn',
    first_name: 'Kira',
    birth_date: '1990-05-05',
    phone: '040/443322',
    email: 'k.wellensteyn@yahoo.de',
    address: Address:2001
};

CREATE Customer:2002 CONTENT {
    last_name: 'Foede',
    first_name: 'Dorothea',
    birth_date: '2000-03-24',
    phone: '040/543822',
    email: 'd.foede@web.de',
    address: Address:2002
};

CREATE Customer:2003 CONTENT {
    last_name: 'Leberer',
    first_name: 'Sigrid',
    birth_date: '1989-09-21',
    phone: '0175/1234588',
    email: 'sigrid@leberer.de',
    address: Address:2003
};

CREATE Customer:2004 CONTENT {
    last_name: 'Soerensen',
    first_name: 'Hanna',
    birth_date: '1974-04-03',
    phone: '040/634578',
    email: 'h.soerensen@yahoo.de',
    address: Address:2004
};

CREATE Customer:2005 CONTENT {
    last_name: 'Schnitter',
    first_name: 'Marten',
    birth_date: '1964-04-17',
    phone: '0176/447587',
    email: 'schni_mart@gmail.com',
    address: Address:2005
};

CREATE Customer:2006 CONTENT {
    last_name: 'Maurer',
    first_name: 'Belinda',
    birth_date: '1978-09-09',
    phone: '040/332189',
    email: 'belinda1978@yahoo.de',
    address: Address:2006
};

CREATE Customer:2007 CONTENT {
    last_name: 'Gessert',
    first_name: 'Armin',
    birth_date: '1978-01-29',
    phone: '040/67890',
    email: 'armin@gessert.de',
    address: Address:2007
};

CREATE Customer:2008 CONTENT {
    last_name: 'Haessig',
    first_name: 'Jean-Marc',
    birth_date: '1982-08-30',
    phone: '0178-67013390',
    email: 'jm@haessig.de',
    address: Address:2008
};

CREATE Customer:2009 CONTENT {
    last_name: 'Urocki',
    first_name: 'Eric',
    birth_date: '1999-12-04',
    phone: '0152-96701390',
    email: 'urocki@outlook.de',
    address: Address:2009
};

CREATE Ingredient:1001 CONTENT {
    designation: 'Zucchini',
    unit: 'Stück',
    net_price: 0.89,
    stock: 100,
    calories: 19,
    carbohydrates: 2,
    protein: 1.6
};

CREATE Ingredient:1002 CONTENT {
    designation: 'Zwiebel',
    unit: 'Stück',
    net_price: 0.15,
    stock: 50,
    calories: 28,
    carbohydrates: 4.9,
    protein: 1.20
};

CREATE Ingredient:1003 CONTENT {
    designation: 'Tomate',
    unit: 'Stück',
    net_price: 0.45,
    stock: 50,
    calories: 18,
    carbohydrates: 2.6,
    protein: 1
};

CREATE Ingredient:1004 CONTENT {
    designation: 'Schalotte',
    unit: 'Stück',
    net_price: 0.20,
    stock: 500,
    calories: 25,
    carbohydrates: 3.3,
    protein: 1.5
};

CREATE Ingredient:1005 CONTENT {
    designation: 'Karotte',
    unit: 'Stück',
    net_price: 0.30,
    stock: 500,
    calories: 41,
    carbohydrates: 10,
    protein: 0.9
};

CREATE Ingredient:1006 CONTENT {
    designation: 'Kartoffel',
    unit: 'Stück',
    net_price: 0.15,
    stock: 1500,
    calories: 71,
    carbohydrates: 14.6,
    protein: 2
};

CREATE Ingredient:1007 CONTENT {
    designation: 'Rucola',
    unit: 'Bund',
    net_price: 0.90,
    stock: 10,
    calories: 27,
    carbohydrates: 2.1,
    protein: 2.6
};

CREATE Ingredient:1008 CONTENT {
    designation: 'Lauch',
    unit: 'Stück',
    net_price: 1.2,
    stock: 35,
    calories: 29,
    carbohydrates: 3.3,
    protein: 2.1
};

CREATE Ingredient:1009 CONTENT {
    designation: 'Knoblauch',
    unit: 'Stück',
    net_price: 0.25,
    stock: 250,
    calories: 141,
    carbohydrates: 28.4,
    protein: 6.1
};

CREATE Ingredient:1010 CONTENT {
    designation: 'Basilikum',
    unit: 'Bund',
    net_price: 1.3,
    stock: 10,
    calories: 41,
    carbohydrates: 5.1,
    protein: 3.1
};

CREATE Ingredient:1011 CONTENT {
    designation: 'Süßkartoffel',
    unit: 'Stück',
    net_price: 2.0,
    stock: 200,
    calories: 86,
    carbohydrates: 20,
    protein: 1.6
};

CREATE Ingredient:1012 CONTENT {
    designation: 'Schnittlauch',
    unit: 'Bund',
    net_price: 0.9,
    stock: 10,
    calories: 28,
    carbohydrates: 1,
    protein: 3
};

CREATE Ingredient:2001 CONTENT {
    designation: 'Apfel',
    unit: 'Stück',
    net_price: 1.2,
    stock: 750,
    calories: 54,
    carbohydrates: 14.4,
    protein: 0.3
};

CREATE Ingredient:3001 CONTENT {
    designation: 'Vollmilch. 3.5%',
    unit: 'Liter',
    net_price: 1.5,
    stock: 50,
    calories: 65,
    carbohydrates: 4.7,
    protein: 3.4
};

CREATE Ingredient:3002 CONTENT {
    designation: 'Mozzarella',
    unit: 'Packung',
    net_price: 3.5,
    stock: 20,
    calories: 241,
    carbohydrates: 1,
    protein: 18.1
};

CREATE Ingredient:3003 CONTENT {
    designation: 'Butter',
    unit: 'Stück',
    net_price: 3.0,
    stock: 50,
    calories: 741,
    carbohydrates: 0.6,
    protein: 0.7
};

CREATE Ingredient:4001 CONTENT {
    designation: 'Ei',
    unit: 'Stück',
    net_price: 0.4,
    stock: 300,
    calories: 137,
    carbohydrates: 1.5,
    protein: 11.9
};

CREATE Ingredient:4002 CONTENT {
    designation: 'Wiener Würstchen',
    unit: 'Paar',
    net_price: 1.8,
    stock: 40,
    calories: 331,
    carbohydrates: 1.2,
    protein: 9.9
};

CREATE Ingredient:5001 CONTENT {
    designation: 'Tofu-Würstchen',
    unit: 'Stück',
    net_price: 1.8,
    stock: 20,
    calories: 252,
    carbohydrates: 7,
    protein: 17
};

CREATE Ingredient:6408 CONTENT {
    designation: 'Couscous',
    unit: 'Packung',
    net_price: 1.9,
    stock: 15,
    calories: 351,
    carbohydrates: 67,
    protein: 12
};

CREATE Ingredient:7043 CONTENT {
    designation: 'Gemüsebrühe',
    unit: 'Würfel',
    net_price: 0.2,
    stock: 4000,
    calories: 1,
    carbohydrates: 0.5,
    protein: 0.5
};

CREATE Ingredient:6300 CONTENT {
    designation: 'Kichererbsen',
    unit: 'Dose',
    net_price: 1.0,
    stock: 400,
    calories: 150,
    carbohydrates: 21.2,
    protein: 9
};

CREATE Order:3001 CONTENT {
    invoice_amount: 25.50,
    order_date: "2024-02-08T10:00:00",
    customer: Customer:2001,
};

CREATE Order:3002 CONTENT {
    invoice_amount: 35.80,
    order_date: "2024-02-08T11:30:00",
    customer: Customer:2002,
};

CREATE Order:3003 CONTENT {
    invoice_amount: 42.60,
    order_date: "2024-02-08T13:15:00",
    customer: Customer:2003,
};

CREATE Order:3004 CONTENT {
    invoice_amount: 18.90,
    order_date: "2024-02-08T14:45:00",
    customer: Customer:2004,
};

CREATE Order:3005 CONTENT {
    invoice_amount: 50.25,
    order_date: "2024-02-08T16:20:00",
    customer: Customer:2005,
};


CREATE Recipe:4001 CONTENT {
    preparation_time: 30,
    name: 'Zucchini Pasta',
    description: 'A delicious and healthy pasta dish made with fresh zucchini and flavorful ingredients.',
    instructions: '1. Spiralize the zucchini into noodles. 2. Heat olive oil in a pan and sauté minced garlic until fragrant. 3. Add the zucchini noodles and cook until tender. 4. Season with salt, pepper, and any desired herbs. 5. Serve hot with grated Parmesan cheese on top.',
};

CREATE Recipe:4002 CONTENT {
    preparation_time: 45,
    name: 'Tomato Basil Salad',
    description: 'A refreshing salad bursting with flavors of ripe tomatoes and fragrant basil.',
    instructions: '1. Slice the tomatoes into thin rounds and arrange them on a serving platter. 2. Tear fresh basil leaves and scatter them over the tomatoes. 3. Drizzle with extra virgin olive oil and balsamic vinegar. 4. Season with salt and pepper to taste. 5. Let the salad marinate for at least 30 minutes before serving.',
};

CREATE Recipe:4003 CONTENT {
    preparation_time: 40,
    name: 'Roasted Vegetable Medley',
    description: 'A colorful and nutritious medley of roasted vegetables, perfect as a side dish or main course.',
    instructions: '1. Preheat the oven to 400°F (200°C). 2. Chop assorted vegetables such as carrots, bell peppers, and onions into bite-sized pieces. 3. Toss the vegetables with olive oil, minced garlic, and your favorite herbs. 4. Spread the vegetables on a baking sheet in a single layer. 5. Roast in the oven for 25-30 minutes or until tender and caramelized. 6. Serve hot and enjoy!',
};

CREATE Recipe:4004 CONTENT {
    preparation_time: 20,
    name: 'Caprese Skewers',
    description: 'A simple and elegant appetizer featuring fresh mozzarella, cherry tomatoes, and basil leaves.',
    instructions: '1. Thread cherry tomatoes, fresh mozzarella balls, and basil leaves onto skewers. 2. Drizzle with balsamic glaze and olive oil. 3. Season with salt and pepper to taste. 4. Serve immediately and enjoy!',
};

CREATE Recipe:4005 CONTENT {
    preparation_time: 60,
    name: 'Vegetarian Paella',
    description: 'A hearty and flavorful vegetarian version of the classic Spanish rice dish, loaded with vegetables and fragrant spices.',
    instructions: '1. Heat olive oil in a large paella pan over medium heat. 2. Add chopped onions, bell peppers, and garlic, and sauté until softened. 3. Stir in Arborio rice and cook for 2-3 minutes. 4. Add vegetable broth, saffron, diced tomatoes, and a pinch of salt. 5. Bring to a simmer and cook for 20-25 minutes, stirring occasionally. 6. Add cooked vegetables such as peas, artichoke hearts, and roasted red peppers. 7. Cook for an additional 5-10 minutes until the rice is tender and the vegetables are heated through. 8. Garnish with chopped parsley and lemon wedges before serving.',
};

CREATE Supplier:101 CONTENT {
    name: 'Bio-Hof Müller',
    phone: '04354-9080',
    email: 'mueller@biohof.de',
    address: Address:101
};

CREATE Supplier:102 CONTENT {
    name: 'Obst-Hof Altes Land',
    phone: '04162-4523',
    email: 'info@biohof-altesland.de',
    address: Address:102
};

CREATE Supplier:103 CONTENT {
    name: 'Molkerei Henning',
    phone: '038873-8976',
    email: 'info@molkerei-henning.de',
    address: Address:103
};

CREATE Address:101 CONTENT {
    street: 'Dorfstraße',
    house_number: '74',
    postal_code: '24354',
    city: 'Weseby'
};

CREATE Address:102 CONTENT {
    street: 'Westerjork 74',
    house_number: '76',
    postal_code: '21635',
    city: 'Jork'
};

CREATE Address:103 CONTENT {
    street: 'Molkereiwegkundekunde',
    house_number: '13',
    postal_code: '19217',
    city: 'Dechow'
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 4.0,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:1002
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 6.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1003
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 3.5,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:1004
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 4.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1005
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 3.0,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:1006
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1007
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 4.5,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:1008
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 3.5,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:1009
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.5,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1010
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 6.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1011
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:1012
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 7.0,
    delivery_time: 4,
    supplier: Supplier:102,
    ingredient: Ingredient:2001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.0,
    delivery_time: 3,
    supplier: Supplier:103,
    ingredient: Ingredient:3001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 6.5,
    delivery_time: 4,
    supplier: Supplier:103,
    ingredient: Ingredient:3002
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 7.0,
    delivery_time: 4,
    supplier: Supplier:103,
    ingredient: Ingredient:3003
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 4.5,
    delivery_time: 3,
    supplier: Supplier:102,
    ingredient: Ingredient:4001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 6.0,
    delivery_time: 4,
    supplier: Supplier:101,
    ingredient: Ingredient:5001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 3.5,
    delivery_time: 2,
    supplier: Supplier:103,
    ingredient: Ingredient:6408
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 2.0,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:7043
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 2.5,
    delivery_time: 2,
    supplier: Supplier:101,
    ingredient: Ingredient:6300
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 2,
    order: Order:3001,
    ingredient: Ingredient:1001
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 3,
    order: Order:3001,
    ingredient: Ingredient:1002
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 1,
    order: Order:3002,
    ingredient: Ingredient:1003
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 1,
    order: Order:3003,
    ingredient: Ingredient:1004
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 2,
    order: Order:3004,
    ingredient: Ingredient:1005
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 1,
    order: Order:3005,
    ingredient: Ingredient:1006
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 3,
    order: Order:3005,
    ingredient: Ingredient:1007
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 2,
    order: Order:3005,
    ingredient: Ingredient:1008
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 1,
    order: Order:3005,
    ingredient: Ingredient:1009
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 2,
    order: Order:3005,
    ingredient: Ingredient:1010
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 1,
    order: Order:3005,
    ingredient: Ingredient:1011
};

CREATE OrderContainsIngredients CONTENT {
    quantity: 3,
    order: Order:3005,
    ingredient: Ingredient:1012
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 3,
    recipe: Recipe:4001,
    ingredient: Ingredient:1001,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 2,
    recipe: Recipe:4001,
    ingredient: Ingredient:1002,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4001,
    ingredient: Ingredient:1003,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4001,
    ingredient: Ingredient:1004,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4001,
    ingredient: Ingredient:1005,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4002,
    ingredient: Ingredient:1003,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 2,
    recipe: Recipe:4002,
    ingredient: Ingredient:1004,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4002,
    ingredient: Ingredient:1005,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4003,
    ingredient: Ingredient:1002,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 2,
    recipe: Recipe:4003,
    ingredient: Ingredient:1004,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 2,
    recipe: Recipe:4003,
    ingredient: Ingredient:1005,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4003,
    ingredient: Ingredient:1006,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4003,
    ingredient: Ingredient:1007,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4003,
    ingredient: Ingredient:1008,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4003,
    ingredient: Ingredient:1009,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4004,
    ingredient: Ingredient:1003,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 2,
    recipe: Recipe:4004,
    ingredient: Ingredient:1007,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4004,
    ingredient: Ingredient:1010,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4005,
    ingredient: Ingredient:1005,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4005,
    ingredient: Ingredient:1006,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4005,
    ingredient: Ingredient:1007,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 2,
    recipe: Recipe:4005,
    ingredient: Ingredient:1008,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4005,
    ingredient: Ingredient:1009,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4005,
    ingredient: Ingredient:1011,
};

CREATE RecipeContainsIngredients CONTENT {
    amount: 1,
    recipe: Recipe:4005,
    ingredient: Ingredient:1012,
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 4.0,
    delivery_time: 2,
    supplier: Supplier:102,
    ingredient: Ingredient:3003
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 3.0,
    delivery_time: 2,
    supplier: Supplier:102,
    ingredient: Ingredient:6408
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.0,
    delivery_time: 3,
    supplier: Supplier:102,
    ingredient: Ingredient:7043
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 6.0,
    delivery_time: 4,
    supplier: Supplier:102,
    ingredient: Ingredient:6300
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 5.0,
    delivery_time: 3,
    supplier: Supplier:103,
    ingredient: Ingredient:4001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 6.0,
    delivery_time: 4,
    supplier: Supplier:103,
    ingredient: Ingredient:5001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 7.5,
    delivery_time: 4,
    supplier: Supplier:103,
    ingredient: Ingredient:9001
};

CREATE SupplierContainsIngredients CONTENT {
    delivery_cost: 4.0,
    delivery_time: 3,
    supplier: Supplier:101,
    ingredient: Ingredient:3002
};

CREATE Customer:2012 CONTENT {
    last_name: 'Wong',
    first_name: 'Emily',
    birth_date: '1990-03-15',
    phone: '040/555555',
    email: 'emily.wong@example.com',
    address: Address:2012
};

CREATE Address:2012 CONTENT {
    street: 'Rose Street',
    house_number: '8',
    postal_code: '22000',
    city: 'Berlin'
};

CREATE Customer:2013 CONTENT {
    last_name: 'Müller',
    first_name: 'Andreas',
    birth_date: '1983-12-04',
    phone: '030/123456',
    email: 'andreas.mueller@example.com',
    address: Address:2013
};

CREATE Address:2013 CONTENT {
    street: 'Lindenallee',
    house_number: '12',
    postal_code: '22333',
    city: 'Berlin'
};

CREATE Customer:2014 CONTENT {
    last_name: 'Jansen',
    first_name: 'Sophie',
    birth_date: '1978-06-22',
    phone: '030/987654',
    email: 'sophie.jansen@example.com',
    address: Address:2014
};

CREATE Address:2014 CONTENT {
    street: 'Birkenweg',
    house_number: '3',
    postal_code: '22666',
    city: 'Berlin'
};

CREATE Customer:2015 CONTENT {
    last_name: 'Schmidt',
    first_name: 'Marcel',
    birth_date: '1995-08-10',
    phone: '030/112233',
    email: 'marcel.schmidt@example.com',
    address: Address:2015
};

CREATE Address:2015 CONTENT {
    street: 'Ahornstraße',
    house_number: '17',
    postal_code: '22999',
    city: 'Berlin'
};