JavaRush /Kurslar /All lectures for UZ purposes /Vazifa - oldindan yaratilgan uchta sxemada 6 ta jadval ya...

Vazifa - oldindan yaratilgan uchta sxemada 6 ta jadval yaratish

All lectures for UZ purposes
Daraja, Dars
Mavjud

Vazifa: Beshinchi daraja oltinchi dars ko'rsatmalariga muvofiq:

  1. 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
  2. library sxemasida yarat:
    1. publisher jadvalini ikkita ustun bilan:
      • id turida INT
      • name turida VARCHAR(100)
    2. author jadvalini to'rtta ustun bilan:
      • id turida INT
      • first_name turida VARCHAR(50)
      • last_name turida VARCHAR(50)
      • full_name turida VARCHAR(100)
    3. 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
  3. lego sxemasida yarat:
    1. part jadvalini to'rtta ustun bilan:
      • id turida INT
      • number turida VARCHAR(25)
      • name turida VARCHAR(100)
      • weight turida FLOAT
    2. lego_set jadvalini beshta ustun bilan:
      • id turida INT
      • number turida INT
      • name turida VARCHAR(100)
      • released turida INT
      • inventory turida INT
Izohlar
TO VIEW ALL COMMENTS OR TO MAKE A COMMENT,
GO TO FULL VERSION