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.

Lab Structure

Week #	Date Starting	Lab Topic	Assessment	Comments
Week 2	03/03/2025	Software Setup	N/A	In Week 2, no Monday lab sessions due to Labour Day.
Week 3	10/03/2025	Extract, transform, and load (ETL)	N/A
Week 4	17/03/2025	Designing a New Data Warehouse	N/A
Week 5	24/03/2025	Mini End-to-End Data Warehouse Project	Week 5 Lab demo
Week 6	31/03/2025	Association Rules Mining	Week 5 Lab demo cont'd
Week 7	07/04/2025	Project 1 Consulation	N/A
Week 8	14/04/2025	Neo4j	N/A	In Week 8, no Friday lab sessions due to Good Friday.
Study Break	21/04/2025
Week 9	28/04/2025	Import data from a relational database into Neo4j	N/A
Week 10	05/05/2025	Cypher Queries	N/A
Week 11	12/05/2025	Advanced Cypher and APOC	N/A
Week 12	19/05/2025	Graph Data Science	N/A

Lab Assessments

Assessment Tasks	Weight	Assessment period/date/s	Submission Procedure
Week 1 Online Quiz	2%	28/3 11:59 PM	LMS
Week 5 Lab Demo	3%	4/4 11:59 PM	During Weeks 5 and 6 labs

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.

• Dr Michael Stewart for the initial development of exercises for the graph database