A. General Information and Submission
o This is an individual assignment.
o Submission method: Submission is online through Moodle.
o Penalty for late submission: 10% deduction for each day.
o Assignment Coversheet: You will need to sign the assignment coversheet.
B. Background – MAC
Monash University Agriculture Club (MAC) is recently studying the parks and different wildlife habitats across the United States in hopes of finding any links between the parks and wildlife of Australia.
The club has hired your team of Advanced Database Experts to use the following sample data files to help with the parks and wildlife analysis:
Note: These data are raw data that does not follow any particular schema.
MAC previously requested you to build a new database system through the incorporation of MongoDB and Cassandra Technologies. However, due to some budget constraints, MAC has decided to only maintain one database. They recently heard about graph databases and the benefit of having such databases in maintaining data with complex relationships. Therefore, they have contacted you again to build another database system to store their data by using Neo4j.
The assignment is divided into THREE main tasks and ONE optional bonus task:
C.1. Database Design.
As MAC has requested you to build a new database system using Neo4j, you are required to redesign MAC’s database into a graph database design. You should ensure that all of the information that is recorded in the sample data is also recorded in the new graph database.
In this task, you are required to do the following:
● Create a new project called MAC.
● Create a new graph called MACgraph.
● Identify the potential nodes and edges based on the given data (wildlife.csv,parks.csv). You should illustrate your graph to show what nodes and edges are needed to build the MAC database.
● Import data from the CSV files and ensure that the imported data represent your identified nodes and edges.
● Provide some explanations on the graph design (max 150 words).
The script for each task should be kept in a .cypher file called TaskC1.
● Use appropriate data types while inserting/importing the data.
● Use appropriate naming conventions. You may refer to Neo4j official documentation on Cypher Style Guide.
● You should ensure that there are no nodes or edges that have the same property.
本网站支持 Alipay WeChatPay PayPal等支付方式
E-mail: firstname.lastname@example.org 微信号:vipnxx