Programming & Development / April 12, 2025

Enum Representation of Administrative Regions in Tanzania and SQL Table for Storing Region Data

Enum Tanzania Administrative Regions Java SQL Dodoma Dar es Salaam Zanzibar Region Code Mainland Unguja Pemba

✅ Enum Representation in Java

Tanzania is divided into 31 administrative regions, including regions from both Mainland Tanzania and Zanzibar (Unguja and Pemba islands).

Here is the Java enum representing all 31 regions along with commonly used region codes:

java

public enum TanzaniaRegion {
    ARUSHA("AR"),
    DAR_ES_SALAAM("DS"),
    DODOMA("DO"),
    GEITA("GE"),
    IRINGA("IR"),
    KAGERA("KA"),
    KATAVI("KV"),
    KIGOMA("KI"),
    KILIMANJARO("KL"),
    LINDI("LI"),
    MANYARA("MY"),
    MARA("MR"),
    MBeya("MB"),
    MOROGORO("MO"),
    MTWARA("MT"),
    MWANZA("MW"),
    NJOMBE("NJ"),
    PWANI("PW"),
    RUKWA("RK"),
    RUVUMA("RV"),
    SHINYANGA("SH"),
    SIMIYU("SM"),
    SINGIDA("SI"),
    SONGWE("SG"),
    TABORA("TB"),
    TANGA("TN"),
    ZANZIBAR_CENTRAL_SOUTH("ZC"),
    ZANZIBAR_NORTH("ZN"),
    ZANZIBAR_URBAN_WEST("ZU"),
    PEMBA_NORTH("PN"),
    PEMBA_SOUTH("PS");

    private final String code;

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

    public String getCode() {
        return this.code;
    }
}

✅ SQL Representation for Storing Tanzania’s Region Data

Here’s a SQL schema and the INSERT statements for all 31 administrative regions:

sql

-- Table for Tanzania administrative regions
CREATE TABLE tanzania_regions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    code CHAR(3) NOT NULL
);

-- Insert all regions of Tanzania
INSERT INTO tanzania_regions (name, code) VALUES
('Arusha', 'AR'),
('Dar es Salaam', 'DS'),
('Dodoma', 'DO'),
('Geita', 'GE'),
('Iringa', 'IR'),
('Kagera', 'KA'),
('Katavi', 'KV'),
('Kigoma', 'KI'),
('Kilimanjaro', 'KL'),
('Lindi', 'LI'),
('Manyara', 'MY'),
('Mara', 'MR'),
('Mbeya', 'MB'),
('Morogoro', 'MO'),
('Mtwara', 'MT'),
('Mwanza', 'MW'),
('Njombe', 'NJ'),
('Pwani', 'PW'),
('Rukwa', 'RK'),
('Ruvuma', 'RV'),
('Shinyanga', 'SH'),
('Simiyu', 'SM'),
('Singida', 'SI'),
('Songwe', 'SG'),
('Tabora', 'TB'),
('Tanga', 'TN'),
('Zanzibar Central/South', 'ZC'),
('Zanzibar North', 'ZN'),
('Zanzibar Urban/West', 'ZU'),
('Pemba North', 'PN'),
('Pemba South', 'PS');

This setup is ideal for software applications, geographic tools, and government systems that deal with regional data in Tanzania.



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