የ12ኛ ክፍል ውጤት ወጥቷል፤ ውጤትዎን የሚያዩበት መንገድ

የምዕራፍ ማስታወሻዎችና የመልመጃ ጥያቄዎች

የ11ኛ ክፍል የመረጃ ቴክኖሎጂ ምዕራፍ 3፦ የዳታቤዝ ማኔጅመንት

በዚህ ገጽ ያለው ሁሉ ለ11ኛ ክፍል የየመረጃ ቴክኖሎጂ መፅሐፍ ምዕራፍ 3 ነው፦ ምዕራፉ የሚሸፍነው፣ አጭር ማስታወሻዎቹ፣ የመልመጃ ጥያቄዎች ከመልሶቻቸው ጋር፣ እና ቪዲዮ ባለበት የትምህርቱ ቪዲዮ።

ከ Google Play ያውርዱ
4
ካርዶች
10
የምዕራፍ 3 የመልመጃ ጥያቄዎች
51–75
የምዕራፍ 3 የመፅሐፍ ገጾች

ምዕራፍ 3 የሚሸፍነው

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

የምዕራፍ 3 አጭር ማስታወሻዎች

በ11ኛ ክፍል የየመረጃ ቴክኖሎጂ ገጽ ላይ በዚህ ምዕራፍ ሥር የተመዘገቡት ካርዶች። አንድ በአንድ ይክፈቱ።

ባህርይFile-Based ApproachDatabase Approach
Data Storageየተለያዩ የተነጠሉ filesአንድ ማዕከላዊ repository
Data Redundancyበdepartments መካከል ከፍተኛ duplication መኖርቁጥጥር የሚደረግበት እና የሚወገድ
Data Consistencyዝቅተኛ፣ የcontradictions ስጋት ያለበትከፍተኛ፣ ማዕከላዊ updates ያሉት
Security እና Sharingየተነጠለ እና በprogram ላይ ጥገኛ የሆነበDBMS በኩል ከuser access rights ጋር የሚጋራ

መቼ እንደሚጠቀሙበት

የባህላዊ file-based አቀራረብ ውስንነቶችን ከዘመናዊ DBMS ጥቅሞች ጋር ለማነጻጸር ይጠቀሙበት።

ይጠንቀቁ

በfile-based አሰራር ላይ የሚደረግ ለውጥ የapplication program ማሻሻልን ይጠይቃል፤ DBMS ግን data independence ይሰጣል።

ከGrade 11 Information Communication Technology፣ ገጽ 51-75 የተዘጋጀ፤ ከመውጣቱ በፊት ሁለት ጊዜ ተረጋግጧል

መቼ እንደሚጠቀሙበት

በሠንጠረዥ ውስጥ ልዩ መለያዎችን ለመወሰን ወይም ተዛማጅ ሠንጠረዦችን እርስ በእርስ ለማገናኘት ይጠቀሙበት።

ይጠንቀቁ

በchild table ውስጥ የሚገኝ foreign key ከተዛማጅ parent table primary key ጋር በdata type እና በዋጋው መመሳሰል አለበት።

ከGrade 11 Information Communication Technology፣ ገጽ 51-75 የተዘጋጀ፤ ከመውጣቱ በፊት ሁለት ጊዜ ተረጋግጧል

መቼ እንደሚጠቀሙበት

በMS Access Query Design ውስጥ መስፈርቶችን በመጠቀም መረጃዎችን ለይተው ሲያወጡ ይጠቀሙበት።

ይጠንቀቁ

የሚገባው መስፈርት በሠንጠረዡ ውስጥ ካለው ቅርጸት ጋር ትክክለኛ መሆን አለበት። ሠንጠረዡ M በሚል ምህፃረ ቃል ሲጠቀም Male ብሎ መጻፍ ምንም ውጤት አያመጣም።

ከGrade 11 Information Communication Technology፣ ገጽ 51-75 የተዘጋጀ፤ ከመውጣቱ በፊት ሁለት ጊዜ ተረጋግጧል

ጽንሰ ሐሳብRelational DatabaseየERD ውክልና
EntityTableRectangle (አራት ማዕዘን)
AttributeField (Column)Ellipse (ኤሊፕስ)
Tuple (Record)RowInstance
RelationshipForeign Key LinkLine (መስመር)

መቼ እንደሚጠቀሙበት

የEntity Relationship Diagram ወደ relational database tables ሲቀይሩ ወይም የሠንጠረዥ ክፍሎችን ለመለየት ይጠቀሙበት።

ይጠንቀቁ

መዝገቦችን (tuples/rows) ከባህሪያት (fields/columns) ጋር አያምታቱ።

ከGrade 11 Information Communication Technology፣ ገጽ 51-75 የተዘጋጀ፤ ከመውጣቱ በፊት ሁለት ጊዜ ተረጋግጧል

የምዕራፍ 3 የመልመጃ ጥያቄዎች

በዚህ ምዕራፍ ላይ የተጻፉ 10 የምርጫ ጥያቄዎች፣ እያንዳንዳቸው መልሱና ምክንያቱ አላቸው። መልሱን ከመክፈትዎ በፊት ይሞክሩ። ጥያቄዎቹ በእንግሊዝኛ ናቸው።

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ B A collection of logically related data

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ A DBMS

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ B Data inconsistency

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ C Traffic accident data has no relevance to the school's day-to-day activities

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ B customer id

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ A One-to-one

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ B Ellipse

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ C A record or tuple

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ C Student ID

ምክንያቱ

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.

ጥያቄ 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
መልሱንና ምክንያቱን ያሳዩ

መልስ፦ B The criteria must match the stored data exactly, so the teacher should type <code>F</code>

ምክንያቱ

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.

መተግበሪያው በዚህ ምዕራፍ ላይ 12 ጥያቄዎች አሉት፤ እየሠሩ ያርምዎታል። እዚህ ያሉት የመጀመሪያዎቹ 10 ናቸው።

የምዕራፍ 3 የመፅሐፍ ገጾች

ምዕራፍ 3 በየትምህርት ሚኒስቴር እትም ከገጽ 51 እስከ ገጽ 75 ይደርሳል።

የትምህርት ሚኒስቴር እትም, እንግሊዝኛ, 170 ገጾች

PDF ያውርዱ

ሁሉም የ11ኛ ክፍል የመረጃ ቴክኖሎጂ አጭር ማስታወሻዎች

ይህን ምዕራፍ በመተግበሪያው ይለማመዱ

Temari ይህን ምዕራፍ ወደ ጊዜ የተቆረጠለት መልመጃ ይለውጠዋል፣ እየሠሩ ያርምዎታል፤ ያልገባዎትንም የሚያብራራ የ AI አስተማሪ አለ።

በነጻ ይጀምሩ

Temari.et ለ Android ስልኮች መተግበሪያ አለው፤ በ Google Play ላይ በነጻ ይገኛል።

ከ Google Play ያውርዱስለ Temari መተግበሪያ
ይግቡመለያዎን ይክፈቱ