Databases
Muhtasari
Almost every organisation stores data: a shop's stock, a school's students, a library's books. A database is how that data is kept in a structured way so it can be searched, sorted and totalled in an instant. This topic shows you how a single-table database is built and how to pull exactly the data you want out of it using SQL.
You will learn how to define a single-table database from a set of requirements, choose suitable data types for each field, understand and pick a primary key, and read, complete and write SQL queries using SELECT, FROM, WHERE, ORDER BY, SUM and COUNT. By the end you should be able to design a table and query it confidently, just as the exam expects.
Malengo
- 1 Define a single-table database from given data storage requirements
- 2 Suggest suitable basic data types
- 3 Understand the purpose of a primary key and identify a suitable primary key for a given database table
- 4 Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table
Somo la Sauti
Sikiliza somo hili kwenye programu
Ramani ya mawazo
Mada hii imechorwa ili uone jinsi mawazo yanavyounganika.
Fungua ramani ya mawazo kwenye programu
Kadi za kumbukumbu
Mazoezi ya haraka ya kumbukumbu kuhusu kinachopimwa katika mada hii.
Fanya mazoezi ya kadi hizi kwenye programu
Maelezo ya Somo
Dokezo Kamili la Somo Linapatikana kwenye Programu ya Green Bridge
Pata programu ya Green Bridge CBT kwenye simu au kompyuta yako kwa maktaba kamili ya IGCSE: mitihani ya miaka iliyopita, miongozo ya usahihishaji, ramani za mawazo, kadi za marudio na masomo ya sauti.
Tathmini ya Somo
Hongera kwa kukamilisha somo la Databases. Sasa kwa kuwa umechunguza dhana na mawazo muhimu, ni wakati wa kuweka ujuzi wako kwa mtihani. Sehemu hii inatoa mazoezi mbalimbali maswali yaliyoundwa ili kuimarisha uelewaji wako na kukusaidia kupima ufahamu wako wa nyenzo.
Utakutana na mchanganyiko wa aina mbalimbali za maswali, ikiwemo maswali ya kuchagua jibu sahihi, maswali ya majibu mafupi, na maswali ya insha. Kila swali limebuniwa kwa umakini ili kupima vipengele tofauti vya maarifa yako na ujuzi wa kufikiri kwa makini.
Tumia sehemu hii ya tathmini kama fursa ya kuimarisha uelewa wako wa mada na kubaini maeneo yoyote ambapo unaweza kuhitaji kusoma zaidi. Usikatishwe tamaa na changamoto zozote utakazokutana nazo; badala yake, zitazame kama fursa za kukua na kuboresha.
- In a database, a single row containing all the fields about one object is called a: A. field B. record C. table D. query Answer: B
- Which data type is most suitable for a price such as 3.99? A. integer B. Boolean C. real D. character Answer: C
- What is the main purpose of a primary key? A. to sort the records B. to uniquely identify each record C. to count the records D. to encrypt the data Answer: B
- Which SQL clause is used to return only records that meet a condition? A. ORDER BY B. SELECT C. WHERE D. COUNT Answer: C
- Which SQL function counts how many records meet a condition? A. SUM B. COUNT C. ORDER BY D. TOTAL Answer: B
Fanyia kazi maswali haya kwenye programu
Fanyia kazi maswali haya kwenye programu
Vitabu Vinavyopendekezwa
Jifunze zaidi kutoka vyanzo huria
-
Sehemu ya kitabu
Relational Database Management Systems
"Introduction to Computer Science: Relational Database Management Systems" by OpenStax, OpenStax, Rice University, licensed under CC BY-NC-SA 4.0 (https://creativecommons.org/licenses/by-nc-sa/4.0/). Source: https://openstax.org/books/introduction-computer-science/pages/8-3-relational-database-management-systems. Access for free at https://openstax.org/books/introduction-computer-science/pages/1-introduction
Vimechapishwa na mashirika mengine chini ya leseni huria na vinatajwa kama wanavyoomba. Viungo hufungua tovuti zao.
Fanya Mazoezi ya Maswali ya Majaribio
Ungependa kufanya mazoezi ya maswali ya majaribio kuhusu Databases? Pakua programu ya Green Bridge CBT ili kupata maswali ya majaribio na tathmini kamili za mazoezi kuhusu mada hii.
Pakua Programu Kwenye Google Playstore
Kila kitu unachohitaji ili kufaulu katika JAMB, WAEC & NECO.
