1. Fuqaro(id, ism, yosh, tel) va Manzil(id, mahalla, ko’cha, uy) jadvallarini tuzing. Bitta manzilda bir nechta fuqaro yashashi mumkin, shundan kelib chiqib bog’lanishni amalga oshiring

HomeWork#3.4
1.Fuqaro(id, ism, yosh, tel) va Manzil(id, mahalla, ko’cha, uy) jadvallarini tuzing. Bitta manzilda bir nechta fuqaro yashashi mumkin, shundan kelib chiqib bog’lanishni amalga oshiring.

2. Xodim(id, ism, kasb) va Korxona(id, nom, soha) jadvallarini tuzing. Bitta korxonadabir nechta xodim ishlashi mumkin, shundan kelib chiqib bog’lanishni amalga oshiring.

3. Talaba(id, ism, student_raqam, kurs) va Grant(id, nom, yil, summa) jadvallarini tuzing. Bitta talaba bor grantlardan faqat bittasini qabul qila oladi xolos, shundan kelib chiqib bog’lanishni amalga oshiring.

4. Uy(id, maydon, hovli_uy) va Oila(id, familiya, son) jadvallarini tuzing. Bitta oila bor uylardan faqat bittasida yashay oladi xolos, shundan kelib chiqib bog’lanishni amalga oshiring.

Nazariy: Many-To-Many bog’lanish haqida o’rganib, misollar topishga harakat qiling.