Programming & Development / April 11, 2025

How to Represent Cabo Verde’s Islands in Java and SQL Using ISO 3166-2 Codes

Cabo Verde islands Java enum Cabo Verde ISO 3166-2 CV SQL Cabo Verde islands Cabo Verde administrative divisions Spring Boot enum Cabo Verde islands list CV region codes islands of Cabo Verde

🇨🇻 Java Enum: Cabo Verde’s Islands

Cabo Verde is an archipelago consisting of 10 islands. Here’s the Java enum using the ISO 3166-2:CV codes.

java

public enum CaboVerdeIsland {
    BOGADO("CV-B"),
    BRAVA("CV-BR"),
    FOGO("CV-F"),
    MAIO("CV-MA"),
    SANTIAGO("CV-S"),
    SANTO_ANTAO("CV-SA"),
    SÃO_NICOLAU("CV-SN"),
    SÃO_VICENTE("CV-SV"),
    SAL("CV-SS"),
    TARRAFAL("CV-T");

    private final String code;

    CaboVerdeIsland(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE cabo_verde_islands (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO cabo_verde_islands (name, code) VALUES
('Bogado', 'CV-B'),
('Brava', 'CV-BR'),
('Fogo', 'CV-F'),
('Maio', 'CV-MA'),
('Santiago', 'CV-S'),
('Santo Antao', 'CV-SA'),
('São Nicolau', 'CV-SN'),
('São Vicente', 'CV-SV'),
('Sal', 'CV-SS'),
('Tarrafal', 'CV-T');

✅ Summary

This setup represents Cabo Verde’s 10 islands using the ISO 3166-2:CV codes. It’s great for managing geographic data, administrative divisions, or island-based functionalities in your applications.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex