Universitet boshqaruv tizimi ma'lumotlar bazasi ishlab chiqish.

[XudayberdiyevB]

Universitet ma'lumotar bazasini ishlab chiqishda Departments, Staffs, Teachers, Students, Groups, Subjects, Regions jadvallari va mos ustunlarini yarating. Har bir jadvalga ma'lumotlar qo'shing.

Example for creating database:

create table Students
(
    id             serial,
    first_name     varchar(100)        not null,
    last_name      varchar(100)        not null,
    username       varchar(100) unique not null,
    phone          varchar(15) unique  not null,
    dob            date,
    date_joined    date,
    date_graduated date,
    is_graduated   boolean default false,
    is_active      boolean default true,
    gpa            real    default 0,
    grade          integer             not null,
    region_id      integer,
    group_id       integer
)

md faylga yozishda table create qilinishi, ma'lumotlar insert bo'lishi va jadval ma'lumotlari skrenshotlari qo'yilishi kerak.

[BunyodNaimov]

https://github.com/BunyodNaimov/issues_37

[OdinaMustafaeva]

https://github.com/OdinaMustafaeva/Database_py/blob/main/Database_2.md

[Otabekismailov]

https://github.com/Otabekismailov/pythonProject/tree/main/Database_task_4

[ierkinov16]

Updating 100 % https://github.com/Saidahror13/Python/blob/main/postgresql/lesson5/table_result.md

[AzizSalimov]

.

[theshag1]

https://github.com/theshag1/new_project/blob/main/modul_4/lesson4/datatype.md

[shoxruxsunnatov]

https://github.com/shoxruxsunnatov/solution-for-lesson-37

[Saidbek101]

https://github.com/Saidbek101/PostgresSQL/blob/main/University_database.md

[alfa77777]

https://github.com/alfa77777/p10-test/tree/main/SQL/tables

[05Muhammadali]

https://github.com/05Muhammadali/P10_SQL/blob/main/Task_5_university.md

[oktamov]

https://github.com/oktamov/SQL/blob/main/task4/task.md

[UmirzakovOzodbek]

https://github.com/UmirzakovOzodbek/TrelloUzBot/blob/main/homeworke/_4m_lesson5.md

[mxcvllx]

https://github.com/Odiljon11/P10_test/tree/master/Lessons%20M4/Lesson%205