Congratulations and Next Steps

Document your tables - List all tables in your database using:

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'public';

Identify foreign keys - Find all relationships between tables:

SELECT
    tc.table_name AS source_table,
    kcu.column_name AS foreign_key,
    ccu.table_name AS target_table,
    ccu.column_name AS target_column
FROM information_schema.table_constraints tc
JOIN information_schema.key_column_usage kcu
    ON tc.constraint_name = kcu.constraint_name
JOIN information_schema.constraint_column_usage ccu
    ON ccu.constraint_name = tc.constraint_name
WHERE tc.constraint_type = 'FOREIGN KEY';

Categorize your tables using the framework from Lesson 2.2:

Create a visual model using Arrows.app

Define node labels — Use singular PascalCase names such as Customer and Order

Define relationship types — Use UPPER_SNAKE_CASE verbs such as PLACED and CONTAINS

Plan properties - Decide which columns become properties and apply camelCase naming

Identify constraints - Determine unique identifiers for each node type

Create constraints first - Adapt the constraint script from Lesson 2.5:

CREATE CONSTRAINT your_node_id IF NOT EXISTS
FOR (n:YourLabel) REQUIRE n.yourID IS UNIQUE;

Plan import order - Follow the dependency chain:

Connect your relational database or upload CSV files to the Data Importer; see Lesson 1.2

Map tables to nodes following your graph model design

Set unique identifiers for each node type

Create relationships by mapping foreign key columns

Run the import and monitor for errors

Run node count queries - Compare with source table counts

Run relationship count queries - Compare with foreign key counts

Check for orphan nodes - Find nodes missing expected relationships

Spot-check sample records - Verify data accuracy

Test your use case queries - Confirm the graph model supports your requirements