Database Design
Gbogbo ọrọ náà
Nobody ever writes a database twice. The design decisions made in the first hour, which tables exist, what each field holds and which field identifies a record, are the ones everything afterwards is built on, and they are the ones that are painful to change once there is real data in the system. Getting them right is a skill, and it is a skill made of three specific choices rather than of general good taste.
This lesson teaches those three choices: picking an appropriate data type, and a length where a length is called for; selecting a suitable primary key; and turning a paragraph describing a situation into a set of linked tables. You will also learn the exact notation this specification uses to write a design down, which is worth knowing precisely, because a design written in the expected form is quick to mark and a design sketched informally is not.
Ebumnobi
- Be able to choose appropriate data types and (where appropriate) lengths for fields in a table. Be able to select a suitable primary key for a table. Be able to produce a design for a relational database from a description of a scenario.
Maapụ uche
E seela isiokwu a ka ị hụ otu echiche si ejikọta.
Mepee maapụ uche 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 Database Design. 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.
- Which data type is most appropriate for a field storing a telephone number? A. Integer B. Real C. String D. Boolean Answer: C
- For which of these fields is it appropriate to give a length? A. A Boolean field recording whether a fee has been paid B. A string field holding a surname C. An integer field holding a quantity D. A real field holding a price Answer: B
- In the notation used by this specification, how is the primary key of a table indicated? A. It is written in capital letters B. It is underlined C. It is placed in square brackets D. It is written last in the list Answer: B
- One member may make many bookings, and each booking is made by one member. Where should the foreign key be placed? A. In the Member table B. In the Booking table C. In both tables D. In neither table Answer: B
- What is the maximum number of tables the specification says an examined design scenario will require? A. Two B. Three C. Four D. There is no limit Answer: B
Rue ajuju ndi a n'ime ngwa ahu
Rue ajuju ndi a n'ime ngwa ahu
Akwụkwọ A Na-atụ Aro
Meecha Ajụjụ Ule Ọmarịcha
Ị chọrọ ime ajụjụ ule ọmarịcha gbasara Database Design? 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.
