✅ Enum Representation in Java
Spain is divided into 17 Autonomous Communities and 2 Autonomous Cities (Ceuta and Melilla). Here's a Java enum representation with common region codes:
java
public enum AutonomousCommunity {
ANDALUSIA("AN"),
ARAGON("AR"),
ASTURIAS("AS"),
BALEARES("IB"),
BASQUE_COUNTRY("PV"),
CANARY_ISLANDS("CN"),
CANTABRIA("CB"),
CASTILE_AND_LEON("CL"),
CASTILLA_LA_MANCHA("CM"),
CATALONIA("CT"),
EXTREMADURA("EX"),
GALICIA("GA"),
LA_RIOJA("RI"),
MADRID("MD"),
MURCIA("MU"),
NAVARRE("NC"),
VALENCIAN_COMMUNITY("VC"),
CEUTA("CE"),
MELILLA("ML");
private final String code;
AutonomousCommunity(String code) {
this.code = code;
}
public String getCode() {
return this.code;
}
}
🔹 Notes:
AutonomousCommunity enum includes both communities and autonomous cities.- Codes follow common ISO/INE or administrative practices in Spain.
getCode() is useful for displaying or storing the abbreviation.
✅ SQL Representation for Storing Autonomous Communities
Here's a sample SQL schema and insert statements for Spain's autonomous communities:
sql
-- Table for autonomous communities of Spain
CREATE TABLE autonomous_communities (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
code CHAR(2) NOT NULL
);
-- Insert values for Spain's autonomous communities and cities
INSERT INTO autonomous_communities (name, code) VALUES
('Andalusia', 'AN'),
('Aragon', 'AR'),
('Asturias', 'AS'),
('Balearic Islands', 'IB'),
('Basque Country', 'PV'),
('Canary Islands', 'CN'),
('Cantabria', 'CB'),
('Castile and León', 'CL'),
('Castilla-La Mancha', 'CM'),
('Catalonia', 'CT'),
('Extremadura', 'EX'),
('Galicia', 'GA'),
('La Rioja', 'RI'),
('Madrid', 'MD'),
('Murcia', 'MU'),
('Navarre', 'NC'),
('Valencian Community', 'VC'),
('Ceuta', 'CE'),
('Melilla', 'ML');
This setup helps model Spain’s regional structure in both Java applications and relational databases.