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
Nashr sanasi2026-06-07
Son2
Betlar303-307
TilRus

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

Al-Farg'oniy avlodlari jurnalidan boshqa maqolalar

Al-Farg'oniy avlodlari — barcha maqolalar