Databases
Bayani Gaba-gaba
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.
Manufura
- 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
Darasin Sauti
Saurari wannan darasi a cikin manhaja
Taswirar tunani
An zana wannan batu don ka ga yadda ra'ayoyi ke hadewa.
Bude taswirar tunani a cikin manhaja
Katunan tunawa
Gwaji mai sauri kan abin da ake jarraba a wannan batu.
Yi atisayen wadannan katuna a cikin manhaja
Takardar Darasi
Cikakken Bayanin Darasi Yana Kan Manhajar Green Bridge
Sami manhajar Green Bridge CBT a wayarka ko kwamfutarka domin cikakken laburaren IGCSE: takardun jarrabawar baya, tsarin kimantawa, taswirar tunani, katunan karatu da darussan sauti.
Nazarin Darasi
Barka da kammala darasi akan Databases. Yanzu da kuka bincika mahimman raayoyi da raayoyi, lokaci yayi da zaku gwada ilimin ku. Wannan sashe yana ba da ayyuka iri-iri Tambayoyin da aka tsara don ƙarfafa fahimtar ku da kuma taimaka muku auna fahimtar ku game da kayan.
Za ka gamu da haɗe-haɗen nau'ikan tambayoyi, ciki har da tambayoyin zaɓi da yawa, tambayoyin gajeren amsa, da tambayoyin rubutu. Kowace tambaya an ƙirƙira ta da kyau don auna fannoni daban-daban na iliminka da ƙwarewar tunani mai zurfi.
Yi wannan ɓangaren na kimantawa a matsayin wata dama don ƙarfafa fahimtarka kan batun kuma don gano duk wani yanki da kake buƙatar ƙarin karatu. Kada ka yanke ƙauna da duk wani ƙalubale da ka fuskanta; maimakon haka, ka kallesu a matsayin damar haɓaka da ingantawa.
- 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
Yi aikin wadannan tambayoyi a cikin manhaja
Yi aikin wadannan tambayoyi a cikin manhaja
Littattafan da ake ba da shawarar karantawa
Ƙarin koyo daga tushe na buɗe
-
Sashen littafi
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
Wasu ƙungiyoyi ne suka wallafa su ƙarƙashin lasisin buɗe, kuma muna ambaton su yadda suka nema. Hanyoyin suna buɗe shafukansu.
Yi Aikin Tambayoyin Gwaji
Kana son yin aikin tambayoyin gwaji kan Databases? Sauke manhajar Green Bridge CBT don samun tambayoyin gwaji da cikakkun jarrabawa akan wannan batu.
Sauke Manhajar Daga Google Playstore
Duk abin da kake buƙata don yin fice a JAMB, WAEC & NECO.
