Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3 . 1 Create a database called EcommerceDB using query. ( 2 Marks ) 3 . 2 Using the database created in 3 . 1

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 to Expert-Tailored 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

Recommended Textbook for

Graph Databases In Action

Authors: Dave Bechberger, Josh Perryman

1st Edition

1617296376, 978-1617296376

More Books

Students also viewed these Databases questions