# CITS3401/5504 Lab Sheets

Welcome to the CITS3401/5504 lab sheets pages!

This set of lab sheets covers the data warehouse design and graph database exercises using Neo4j.&#x20;

## Lab Structure

<table data-full-width="true"><thead><tr><th width="109">Week #</th><th width="183">Date Starting</th><th width="337">Lab Topic</th><th width="149">Assessment</th><th>Comments</th></tr></thead><tbody><tr><td>Week 2</td><td>03/03/2025</td><td><a href="week-2-software-setup">Software Setup</a></td><td>N/A</td><td>In Week 2, no Monday lab sessions due to Labour Day.</td></tr><tr><td>Week 3</td><td>10/03/2025</td><td><a href="week-3-extract-transform-and-load-etl">Extract, transform, and load (ETL)</a></td><td>N/A</td><td></td></tr><tr><td>Week 4</td><td>17/03/2025</td><td><a href="week-4-designing-a-new-data-warehouse">Designing a New Data Warehouse</a></td><td>N/A</td><td></td></tr><tr><td>Week 5</td><td>24/03/2025</td><td><a href="week-5-mini-end-to-end-data-warehouse-project">Mini End-to-End Data Warehouse Project</a></td><td>Week 5 Lab demo</td><td></td></tr><tr><td>Week 6</td><td>31/03/2025</td><td><a href="week-6-association-rules-mining">Association Rules Mining</a></td><td>Week 5 Lab demo cont'd</td><td></td></tr><tr><td>Week 7</td><td>07/04/2025</td><td>Project 1 Consulation</td><td>N/A</td><td></td></tr><tr><td>Week 8</td><td>14/04/2025</td><td><a href="week-8-neo4j">Neo4j</a></td><td>N/A</td><td>In Week 8, no Friday lab sessions due to Good Friday.</td></tr><tr><td><strong>Study Break</strong></td><td><strong>21/04/2025</strong></td><td></td><td></td><td></td></tr><tr><td>Week 9</td><td>28/04/2025</td><td><a href="week-9-import-data-from-a-relational-database-into-neo4j">Import data from a relational database into Neo4j</a></td><td>N/A</td><td></td></tr><tr><td>Week 10</td><td>05/05/2025</td><td><a href="week-10-cypher-queries">Cypher Queries</a></td><td>N/A</td><td></td></tr><tr><td>Week 11</td><td>12/05/2025</td><td><a href="week-11-advanced-cypher-and-apoc">Advanced Cypher and APOC</a></td><td>N/A</td><td></td></tr><tr><td>Week 12</td><td>19/05/2025</td><td><a href="week-12-graph-data-science">Graph Data Science</a></td><td>N/A</td><td></td></tr></tbody></table>

## **Lab Assessments**

<table data-full-width="true"><thead><tr><th align="center">Assessment Tasks</th><th align="center">Weight	</th><th align="center">Assessment period/date/s</th><th align="center">Submission Procedure</th></tr></thead><tbody><tr><td align="center">Week 1 Online Quiz</td><td align="center">2%</td><td align="center">28/3 11:59 PM</td><td align="center">LMS</td></tr><tr><td align="center">Week 5 Lab Demo</td><td align="center">3%</td><td align="center">4/4 11:59 PM</td><td align="center">During Weeks 5 and 6 labs</td></tr></tbody></table>

Credit to:

* Mr Man Qin and Miss Xia Cheng for updating the lab instructions for the new software environment and descriptions.
* Mr Pascal Sun and Mr Jichungyang Li for re-developing the lab instructions for the new software environment.&#x20;
* [Dr Michael Stewart](https://research-repository.uwa.edu.au/en/persons/michael-stewart) for the initial development of  exercises for the graph database
