Vazifa: Beshinchi daraja oltinchi dars ko'rsatmalariga muvofiq:
- space sxemasida object jadvalini beshta ustun bilan yarat:
- id turida INT
- name turida VARCHAR(100)
- type turida VARCHAR(50)
- discoverer turida VARCHAR(100)
- discovery_date turida DATE
- library sxemasida yarat:
- publisher jadvalini ikkita ustun bilan:
- id turida INT
- name turida VARCHAR(100)
- author jadvalini to'rtta ustun bilan:
- id turida INT
- first_name turida VARCHAR(50)
- last_name turida VARCHAR(50)
- full_name turida VARCHAR(100)
- book jadvalini oltita ustun bilan:
- id turida INT
- title turida VARCHAR(100)
- author_id turida INT
- publisher_id turida INT
- publication_year turida INT
- isbn turida BIGINT
- publisher jadvalini ikkita ustun bilan:
- lego sxemasida yarat:
- part jadvalini to'rtta ustun bilan:
- id turida INT
- number turida VARCHAR(25)
- name turida VARCHAR(100)
- weight turida FLOAT
- lego_set jadvalini beshta ustun bilan:
- id turida INT
- number turida INT
- name turida VARCHAR(100)
- released turida INT
- inventory turida INT
- part jadvalini to'rtta ustun bilan:
GO TO FULL VERSION