Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ecommerce Graph Database System using Neo 4 j . Choice Incorporated is an e - commerce outlet operating in three South African provinces and specializes

Ecommerce Graph Database System using Neo4j.Choice Incorporated is an e-commerce outlet operating in three South African provinces and specializes in daily needs within the provinces. The company has enlisted PnP, Markham, Zara, Edgars, Mr Price as its trusted vendor outlets to cater for the needs of the customers. Each of the customers resides in one of the provinces and can place orders on any products of their choice through any of the listed vendors. The following details of the customers are stored: name, age, and gender while the name and zip code of each province is captured. For each product, the name, vendor, price, and rating are kept. The order type may be categorized as either purchased or Wishlist.Source: Obaro Adewale (2024) For uniformity and correctness of results, the following sample data should be used for each entity. Table/Entity NameSample DataCUSTOMER nameagegenderNgcobo Sibusiso24FemaleThato Hlungwani24FemaleThapelo Mpho28MaleMantasha Natasa25FemaleThokozani Kekana25MaleAdrian Suresh24MaleSambulo Tinashe23FemaleBusisiwe Sharon24FemaleMunyai Maputla28FemaleNoluthando Masego25MaleAnele Radebe25Male PRODUCT namevendorpriceratingWooden Chopping BoardPnP4204.2Leather JacketMarkham3304Men's WalletZara1804.4Crochet SweaterZara8254.4Winter BootsEdgars5404.2Summer ShortsMr Price2154.3Plain BlanketMarkham5404.2 PROVINCE nameZipcodeGauteng7001Eastern Cape8002Kwazulu Natal4004 Questions for Consideration Under Deliverable 3 Use the information provided to answer the following questions: 3.1 Create a database called EcommerceDB using query. (2 Marks)3.2 Using the database created in 3.1, create the nodes of the entity as well as the relationships between the node taking into consideration the following relationship criteria: Ngcobo, Thato, Anele, Thapelo and Sambulo live in Gauteng, Noluthando, Adrian, Busisiwe and Munyai live in KwaZulu Natal while Mantasha, Thokozani live in Eastern Cape.Thapelo and Busisiwe place an order for Plain Blanket, Noluthando, and Munyai place an order for Leather Jacket, Adrian and Mantasha place an order for Winter Boots, Thato and Thokozani place an order for the Wooden Chopping Board, Anele places an order for Crochet Sweater, Sambulo places an order for Men's Wallet while Ngcobo places an order for Summer Shorts.Thapelo, Thokozani and Adrian placed their orders as Wishlist while the remaining customers purchased their products. (17 Marks)3.3 Using the above scenario, design a property graph model indicating all the nodes in the ecommerce graph database. The interconnected graph model should be displayed as shown in the figure below. (7 Marks)3.4 Write a query to display the list of customers who reside in:a) Gauteng (The query must display data nodes as shown the figure below)(2 Marks)b) KwaZulu Nata (The query must display data nodes as shown the figure below)(2 Marks)3.5 Create a query to display all the female customers who reside in Gauteng (Customers who are females and reside in Gauteng). Your output can be displayed in any of the following formats. Graph Output:Table Output format: (4 Marks)3.6 Create a query to display all the female customers who reside in Eastern cape. Your output can be displayed in any of the following formats.Graph output: Text Format output: (4 Marks)3.7 Display the list of customers who ordered Winter Boots or Leather Jacket. Your output can be displayed in any of the following formats. Graph Output:Text Output: (4 Marks)3.8 Display the customers who bought products whose price is greater than 500. Your output can be displayed in any of the following formats. Output in graph format:Result in Text format: (4 Marks)3.9 Display the list of products purchased from both Mr Price or PnP in KwaZulu Natal. Your output can be displayed in any of the following formats. Result in graph format:Result in Table format: (4 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions