Toshkent axborot texnalogiyalari unversiteti Farg’ona filiali Dasturiy injinering va raqamli iqtisodiyot

2 amaliy topshiriq

• 
  Mavzu: : Ma’lumotlar bazasini loyihalash, mohiyat – aloqa diagrammasini qurish.
  
• 
  Maqsad: Tayyor mahsulotlarni sotish ma’lumotlar bazasini yaratish mavzusida mohiyat – aloqa diagrammasini tuzishni o’rganish
  

• 
  
  
• 
  mysql> show create table mahsulotlar;
  
• 
  +-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  
• 
  | Table | Create Table |
  
• 
  +-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  
• 
  | mahsulotlar | CREATE TABLE `mahsulotlar` (
  
• 
  `Mahsulot_kodi` int NOT NULL,
  
• 
  `Nomi` varchar(25) DEFAULT NULL,
  
• 
  `Ulgurji_narxi` varchar(15) DEFAULT NULL,
  
• 
  `Chakana_Narxi` varchar(15) DEFAULT NULL,
  
• 
  `Tavsifi` varchar(30) DEFAULT NULL,
  
• 
  PRIMARY KEY (`Mahsulot_kodi`),
  
• 
  UNIQUE KEY `Mahsulot_kodi` (`Mahsulot_kodi`)
  
• 
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
  
• 
  +-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  
•