Bayanin Gida - Kasashe, Mazauna da Yankuna
Wannan samfurin samfurin Microsoft Access yana samar da tanadin bayanai akan ƙasashen duniya, birane, da larduna. An yi amfani da shi don misalai misalai ga wasu shafuka a kan shafin Data Databases kuma yana samar da samfurin mai kyau ga dalibai, masu sana'a da sauransu waɗanda ke koyon Microsoft Access.
Database Tables
Cibiyar ta ƙunshi tebur uku. Tebur na Ƙasar yana ƙunshe da wadannan shafuka:
- Country Name: sunan kasar
- Code: wani ɗan gajeren jerin kalmomi wanda aka yi amfani da shi don yin la'akari da kasar. Wannan filin yana zama maɓallin farko na Tebur na ƙasa.
- Babban birnin: sunan babban birnin kasar
- Province: lardin babban birnin kasar
- Yanki: jimlar yankin ƙasar
- Yawan jama'a: yawan mutanen ƙasar
Tebur na gari ya ƙunshi waɗannan fannoni:
- ID: mai gano mahimmanci wanda aka yi amfani da shi azaman maɓallin farko na teburin
- Sunan birni: sunan birnin
- Ƙasar: lambar ƙasar don birnin. Wannan filin shi ne maɓallin waje na Ƙungiyar Code a Teburin Ƙasar.
- Yawan jama'a: yawan mutanen garin
- Longitude: da longitude na birnin
- Latitude: latitude na birnin
Teburin lardin ya ƙunshi waɗannan fannoni:
- ID: mai gano mahimmanci wanda aka yi amfani da shi azaman maɓallin farko na teburin
- SunanName: sunan lardin
- Ƙasar: lambar ƙasar ga lardin. Wannan filin shi ne maɓallin waje na Ƙungiyar Code a Teburin Ƙasar.
- Yawan jama'a: yawan mutanen lardin
- Yanki: adadin lardin
- Babban birnin: Babban birnin lardin
- CapProv: sunan lardin inda babban birnin ya kasance. Saboda yanayi na musamman a wasu yankuna, wannan filin zai iya bambanta da lardin, duk da cewa yana da yawa.
Abun Hanya
Za'a kwatanta allon zumuntar da aka bayyana a sama a cikin zane mai dangantaka da aka nuna a wannan shafin.
Ana sauke Database
Ana samun bayanai a matsayin sauƙaƙe kyauta a wannan mahadar: MONDIAL.accdb. An ajiye fayil a cikin Microsoft Access 2007 ACCDB tsarin .
Amincewa
Bayanan da ke ƙunshe a cikin wannan tashoshin yana samo daga aikin na MONDIAL, tare da izini.