Development of a postgresql-based relational database model for automotive data management

Nuraliyev, Faxriddin, Hotamov, Farhod, Muxamedjonova, Zuxra

Al-Farg'oniy avlodlari · 2026-yil

Annotatsiya

The article describes a PostgreSQL-based relational model for organizing automotive data on manufacturers, models, generations and trims. The analysis covers tables, enum types, foreign keys, temporal CHECK constraints for production-year intervals, and a trigger function for automatic update timestamps. The proposed structure is considered as a practical information layer for software systems, service catalogues and project-based learning in database courses.

Maqola ma’lumotlari
MualliflarNuraliyev, Faxriddin, Hotamov, Farhod, Muxamedjonova, Zuxra
JurnalAl-Farg'oniy avlodlari
NashriyotТАТУ Фарғона филиали
ISSN2181-4252
Nashr sanasi2026-06-07
Son2
Betlar303-307
TilIngliz
Ilmiy sohaTexnika
Indeksga qo‘shilgan2026-08-26

Kalit so‘zlar

automotive data, PostgreSQL, relational model, database, normalization, foreign key, trigger, information system, автомобильные данные, PostgreSQL, реляционная модель, база данных, нормализация, внешний ключ, триггер, информационная система, avtomobil maʼlumotlari, PostgreSQL, relyatsion model, maʼlumotlar bazasi, normalizatsiya, tashqi kalit, trigger, axborot tizimi

Ilmiy soha

Iqtibos keltirish

APANuraliyev, Faxriddin, Hotamov, Farhod, & Muxamedjonova, Zuxra (2026). Development of a postgresql-based relational database model for automotive data management. Al-Farg'oniy avlodlari, (2), 303-307. https://al-fargoniy.uz/index.php/journal/article/view/1196
GOST (OAK)Nuraliyev, Faxriddin, Hotamov, Farhod, Muxamedjonova, Zuxra Development of a postgresql-based relational database model for automotive data management // Al-Farg'oniy avlodlari. – 2026. – № 2. – P. 303-307.
MLANuraliyev, Faxriddin, Hotamov, Farhod, and Muxamedjonova, Zuxra. “Development of a postgresql-based relational database model for automotive data management.” Al-Farg'oniy avlodlari, (2), 303-307, 2026. https://al-fargoniy.uz/index.php/journal/article/view/1196
ChicagoNuraliyev, Faxriddin, Hotamov, Farhod, and Muxamedjonova, Zuxra. “Development of a postgresql-based relational database model for automotive data management.” Al-Farg'oniy avlodlari, (2), 303-307 (2026). https://al-fargoniy.uz/index.php/journal/article/view/1196
HarvardNuraliyev, Faxriddin, Hotamov, Farhod, and Muxamedjonova, Zuxra (2026) ‘Development of a postgresql-based relational database model for automotive data management’, Al-Farg'oniy avlodlari, (2), 303-307. https://al-fargoniy.uz/index.php/journal/article/view/1196
BibTeX
@article{nuraliyevfaxriddin2026,
  title = {Development of a postgresql-based relational database model for automotive data management},
  author = {Nuraliyev, Faxriddin and Hotamov, Farhod and Muxamedjonova, Zuxra},
  journal = {Al-Farg'oniy avlodlari},
  year = {2026},
  number = {2},
  pages = {303-307},
  url = {https://al-fargoniy.uz/index.php/journal/article/view/1196}
}

Boshqa maqola uchun iqtibos tayyorlash

Al-Farg'oniy avlodlari jurnalidan boshqa maqolalar

Al-Farg'oniy avlodlari — barcha maqolalar · 2026-yil arxivi

Texnika sohasidagi boshqa maqolalar

Texnika sohasidagi OAK jurnallari