Bu'aan kutaa 12ffaa ba'eera; bu'aa kee eessatti akka ilaaltu

Yaadannoo boqonnaa fi gaaffii shaakalaa

Boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 11: Bulchiinsa Deetaabeezii

Wanti fuula kana irra jiru hundi boqonnaa 3 kitaaba Teeknooloojii Odeeffannoo kutaa 11 tiif: wanta boqonnaan haguugu, yaadannoo gabaabaa, gaaffii shaakalaa deebii isaanii waliin, fi viidiyoo barnootaa bakka jirutti.

Google Play irraa buufadhaa
4
Kaardii
10
Gaaffii shaakalaa boqonnaa 3
51–75
Fuula kitaabaa boqonnaa 3

Boqonnaan 3 maal haguuga

  1. 1.Data Management Approaches
  2. 2.Data Model
  3. 3.Creating Relational Database in Microsoft Access

Yaadannoo gabaabaa boqonnaa 3

Kaardiiwwan fuula Teeknooloojii Odeeffannoo kutaa 11 irratti boqonnaa kana jala galmaa'an. Tokko tokkoon bani.

AmalaFile-Based ApproachDatabase Approach
Data StorageFiles adda addaa fi qophaa ta'anRepository giddugaleessaa tokko
Data RedundancyDepartments gidduutti duplication ol'aanaa qabaachuuKan to'atamee fi kan ittifame
Data ConsistencyGadi aanaa, balaa contradictions qabaachuuOl'aanaa, updates giddugaleessaa
Security fi SharingKan adda ba'ee fi program irratti hundaa'eDBMS fayyadamuun user access rights wajjin kan qoodamu

Yoom akka itti fayyadamtu

Yeroo daangaa bulchiinsa faayila durii fi bu'aa DBMS ammayyaa walbira qabdutti fayyadami.

Of eeggadhu

Jijjiiramni file-based sagantaa fooyyessuu barbaada, DBMS garuu data independence kenna.

Grade 11 Information Communication Technology, fuula 51-75 irraa qophaa'e; osoo hin ba'in dura yeroo lama mirkanaa'e

Yoom akka itti fayyadamtu

Yeroo adda baastuu addaa murteessitu yookiin table-oota walqabatan walitti hidhtutti fayyadami.

Of eeggadhu

Foreign key table child keessa jiru data type fi gatii primary key table parent isa walqabatuu wajjin tokko ta'uu qaba.

Grade 11 Information Communication Technology, fuula 51-75 irraa qophaa'e; osoo hin ba'in dura yeroo lama mirkanaa'e

Yoom akka itti fayyadamtu

Yeroo MS Access Query Design keessatti ulaagaalee fayyadamuun daataa calaltutti fayyadami.

Of eeggadhu

Gatiin ulaagaa boca table keessatti kuufameen sirriitti wal simuu qaba. Table keessatti gabaabsee M osoo fayyadamu Male jedhanii barreessuun bu'aa tokkollee hin fidu.

Grade 11 Information Communication Technology, fuula 51-75 irraa qophaa'e; osoo hin ba'in dura yeroo lama mirkanaa'e

Yaad-rimeeRelational DatabaseBakka bu'iinsa ERD
EntityTableRectangle (Rektangilii)
AttributeField (Column)Ellipse (Eliipsii)
Tuple (Record)RowInstance
RelationshipForeign Key LinkLine (Sarara)

Yoom akka itti fayyadamtu

Yeroo Entity Relationship Diagram gara relational database tables jijjiirtu yookiin kutaalee table adda baastutti fayyadami.

Of eeggadhu

Galmeewwan (tuples/rows) fi amaloowwan (fields/columns) walitti hin makinaa.

Grade 11 Information Communication Technology, fuula 51-75 irraa qophaa'e; osoo hin ba'in dura yeroo lama mirkanaa'e

Gaaffii shaakalaa boqonnaa 3

Gaaffii filannoo 10 boqonnaa kana irratti barreeffaman, tokkoon tokkoon isaanii deebii fi sababa qabu. Deebii banuu dura yaali. Gaaffiin kun Ingiliffaa tiin.

Gaaffii 1

Which of these best defines a database?

  1. A.A single file that stores only text
  2. B.A collection of logically related data
  3. C.A program that users run to make reports
  4. D.A drawing that shows entities as rectangles
Deebii fi sababa agarsiisi

Deebii: B A collection of logically related data

Sababa

The chapter says a database is a collection of logically related data. It stores all of an organization's data in one repository. The other options describe files, programs or diagrams, not a database.

Gaaffii 2

A clerk at a supermarket in Bahir Dar wants to add a new sale record, change the price of an item, and delete an old record. Which software is used to do these tasks?

  1. A.DBMS
  2. B.ERD
  3. C.Data model
  4. D.Relation
Deebii fi sababa agarsiisi

Deebii: A DBMS

Sababa

A DBMS (database management system) is software that manages databases. It is used to add new data, modify data, delete data and retrieve data. An ERD and a data model are design tools, and a relation is a table.

Gaaffii 3

In a file-based system, the HR department updates an employee's address, but the Finance department keeps the old address. Which problem does this show?

  1. A.Data independence
  2. B.Data inconsistency
  3. C.Data sharing
  4. D.Improved data security
Deebii fi sababa agarsiisi

Deebii: B Data inconsistency

Sababa

The chapter explains that file-based systems cause data inconsistency. Different departments hold different information about the same employee because their files are not linked. Data independence, data sharing and improved security are advantages of the database approach, not problems of the file-based approach.

Gaaffii 4

A school database does not need to store data about traffic accidents. What is the main reason?

  1. A.Traffic accident data is always stored in a different country
  2. B.Traffic accident data cannot be stored in a database
  3. C.Traffic accident data has no relevance to the school's day-to-day activities
  4. D.Traffic accident data is too large for a school computer
Deebii fi sababa agarsiisi

Deebii: C Traffic accident data has no relevance to the school's day-to-day activities

Sababa

A data model is the blueprint of a database. It specifies what data to store. The chapter says a school stores data about students and teachers. Traffic accident data does not have relevance to the school's day-to-day activities, so it is not included.

Gaaffii 5

In a bank database, customer is an entity. Which of these is an attribute of the customer entity?

  1. A.has
  2. B.customer id
  3. C.bank account entity
  4. D.relationship
Deebii fi sababa agarsiisi

Deebii: B customer id

Sababa

Attributes are properties of an entity that help to tell one entity from another. The chapter lists customer id, name, sex and address as attributes of the customer entity. The word 'has' is a relationship, and a bank account is a separate entity.

Gaaffii 6

A country is associated with one capital city, and a capital city is associated with only one country. What type of relationship is this?

  1. A.One-to-one
  2. B.One-to-many
  3. C.Many-to-many
  4. D.Primary key
Deebii fi sababa agarsiisi

Deebii: A One-to-one

Sababa

In a one-to-one relationship, one instance of an entity has only one instance in the other entity. The chapter uses the example of a country and a capital city. A primary key is a field with unique values, not a type of relationship.

Gaaffii 7

In an Entity Relationship Diagram (ERD), which shape is used to represent an attribute?

  1. A.Rectangle
  2. B.Ellipse
  3. C.Line
  4. D.Triangle
Deebii fi sababa agarsiisi

Deebii: B Ellipse

Sababa

In an ERD, entities are shown as rectangles, relationships are shown as lines, and attributes are shown as ellipses. The name of each attribute goes inside its ellipse.

Gaaffii 8

In a relational database table, what is a row called?

  1. A.An attribute
  2. B.A field
  3. C.A record or tuple
  4. D.A relation
Deebii fi sababa agarsiisi

Deebii: C A record or tuple

Sababa

The chapter says each row of a relation is also called a record or tuple. It holds a unique instance of data. Columns are called attributes or fields, and the whole table is called a relation.

Gaaffii 9

The Book_Loan table has the fields Book_Loan_No, Book ID, Student ID and Loan date. Which field is a foreign key that links the Book_Loan table to the Student table?

  1. A.Book_Loan_No
  2. B.Book ID
  3. C.Student ID
  4. D.Loan date
Deebii fi sababa agarsiisi

Deebii: C Student ID

Sababa

A foreign key is an attribute in one table that matches the primary key of another related table. Student ID in Book_Loan matches the primary key Student ID in the Student table. Book ID is also a foreign key, but it links to the Book table, not the Student table.

Gaaffii 10

A teacher in Hawassa stores each student's sex as M or F in the Student table. In a query, the teacher types Female in the Criteria row for Sex, but gets no results. What is the best explanation?

  1. A.Access only accepts numbers in the Sex field
  2. B.The criteria must match the stored data exactly, so the teacher should type <code>F</code>
  3. C.The query must be saved as a table before it shows results
  4. D.The Sex field must be set to Date/Time
Deebii fi sababa agarsiisi

Deebii: B The criteria must match the stored data exactly, so the teacher should type <code>F</code>

Sababa

The criteria you enter must be exactly the same as the data stored in the table. If sex is stored as a single character, you must type that character. Because the table stores F, typing Female finds no matching records.

Appiin boqonnaa kana irratti gaaffii 12 qaba; utuu hojjettuu ni sirreessa. Kan asii jiran 10 jalqabaa ti.

Fuula kitaabaa boqonnaa 3

Boqonnaan 3 Maxxansa Ministeera Barnootaa keessatti fuula 51 hanga fuula 75 ti.

Maxxansa Ministeera Barnootaa, Ingiliffaa, Fuula 170

PDF buufadhaa

Yaadannoo gabaabaa Teeknooloojii Odeeffannoo kutaa 11 hunda

Boqonnaa kana appii keessatti shaakali

Temari boqonnaa kana gara shaakala yeroon daangeffametti jijjiira; utuu hojjettuu ni sirreessa; wanti si hin galinis barsiisaa AI tiin ni ibsama.

Bilisaan jalqabi

Temari.et appii Android qaba; Google Play irratti bilisaan argama.

Google Play irraa buufadhaaWaa'ee appii Temari
SeeniHerrega kee bani