Create A Database Structure
Gbogbo ọrọ náà
Behind almost every app you use sits a database: the contacts on a phone, the stock in a shop, the members of a club. A database only works well if its structure is right from the start. Choose the wrong field type and a price loses its pennies; forget a key and two people with the same name become impossible to tell apart. Getting the structure right is the quiet skill that makes everything else, the searches, the calculations and the reports, possible later.
In this lesson you will learn how data is organised into fields and records, the difference between a flat file and a relational database, and how to pick the correct data type for every field. You will meet primary and foreign keys and see how they link two tables together, and you will design a clear data entry form. These are the foundations of the practical database papers, so master them and the rest of the Databases unit falls into place.
Ebumnobi
- Create an appropriate database structure.
- Import data from existing files (including .csv, .txt) using specified field names to create tables Set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical Set sub-types of numeric data including percentage, number of decimal places Set display format of Boolean/logical field (yes/no, true/false, checkbox) Set display format of date/time data Create and edit primary and foreign keys Create relationships between tables.
- Create and use a data entry form.
- Create a data entry form including specified fields, appropriate font styles and sizes, appropriate spacing between fields, character spacing of individual fields, use of white space, radio buttons, check boxes, drop down menus.
- Types of database.
- Characteristics, uses, advantages and disadvantages of a flat file and a relational database.
- Primary and foreign keys.
- Characteristics of primary key and foreign keys.
- Form design.
- Characteristics of good form design.
Nkuzi Olu
Gee ntị na nkuzi a na ngwa
Maapụ uche
E seela isiokwu a ka ị hụ otu echiche si ejikọta.
Mepee maapụ uche na ngwa
Kaadị ncheta
Omume ncheta ngwa ngwa n'ihe a na-anwale n'isiokwu a.
Mee omume kaadị ndị a na ngwa
Akwụkwọ Ọmụmụ
Ndetu Nkuzi Zuru Ezu di na Ngwa Green Bridge
Nweta ngwa Green Bridge CBT na ekwenti gi ma o bu kompiuta maka ulo akwukwo IGCSE zuru oke: akwukwo ule ndi gara aga, usoro nyocha, eserese uche, kaadi omumu na nkuzi olu.
Nnyocha Ọmụmụ
Ekele diri gi maka imecha ihe karịrị na Create A Database Structure. Ugbu a na ị na-enyochakwa isi echiche na echiche ndị dị mkpa, ọ bụ oge iji nwalee ihe ị ma. Ngwa a na-enye ụdị ajụjụ ọmụmụ dị iche iche emebere iji kwado nghọta gị wee nyere gị aka ịmata otú ị ghọtara ihe ndị a kụziri.
Ị ga-ahụ ngwakọta nke ụdị ajụjụ dị iche iche, gụnyere ajụjụ chọrọ ịhọrọ otu n’ime ọtụtụ azịza, ajụjụ chọrọ mkpirisi azịza, na ajụjụ ede ede. A na-arụpụta ajụjụ ọ bụla nke ọma iji nwalee akụkụ dị iche iche nke ihe ọmụma gị na nkà nke ịtụgharị uche.
Jiri akụkụ a nke nyocha ka ohere iji kụziere ihe ị matara banyere isiokwu ahụ ma chọpụta ebe ọ bụla ị nwere ike ịchọ ọmụmụ ihe ọzọ. Ekwela ka nsogbu ọ bụla ị na-eche ihu mee ka ị daa mba; kama, lee ha anya dị ka ohere maka ịzụlite onwe gị na imeziwanye.
- In a database table, a single column of one type of data is called a: A. Record B. File C. Field D. Key Answer: C
- Which data type is most suitable for a field that stores a telephone number? A. Numeric integer B. Text (alphanumeric) C. Currency D. Boolean Answer: B
- A field that holds unique data and identifies each record is the: A. Foreign key B. Primary key C. Index field D. Validation field Answer: B
- Which statement about a relational database is correct? A. It stores all data in one single table B. It always searches faster than a flat file C. It stores each item of data once and links tables with relationships D. It cannot use primary keys Answer: C
- A validation check that makes sure a required field has not been left empty is a: A. Range check B. Length check C. Format check D. Presence check Answer: D
Rue ajuju ndi a n'ime ngwa ahu
Rue ajuju ndi a n'ime ngwa ahu
Akwụkwọ A Na-atụ Aro
Mụtakwuo ihe site na isi mmalite mepere emepe
-
Akụkụ akwụkwọ
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
Ndị otu ndị ọzọ bipụtara ha n'okpuru ikike mepere emepe, anyị na-ekele ha dị ka ha si chọọ. Njikọ na-emepe saịtị ha.
Meecha Ajụjụ Ule Ọmarịcha
Ị chọrọ ime ajụjụ ule ọmarịcha gbasara Create A Database Structure? Budata ngwa Green Bridge CBT iji nweta ajụjụ ule ọmarịcha na nyocha zuru ezu gbasara isiokwu a.
Budata Ngwa Ahụ Na Google Playstore
Ihe nile ichoro iji nwee ihe ịga nke ọma na JAMB, WAEC & NECO.
