Boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 11
Entities, attributes and how they relate
daqiiqaa 4 · Gaaffii qormaata darbe 2 hojjetaman
Kutaalee barnootaa
Barnoota achii jalqabee taphachiisuuf kutaa tokko tuqi.
Barnoota viidiyoo Temari daqiiqaa 4 boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 11: Entities, attributes and how they relate. Barnoonni kun Afaan Ingiliziitiin.
Dabalata boqonnaa 3
Fuulli boqonnaa kanaa wanta Temari boqonnaa kana irratti qabu kan hafe qaba, fakkeenyaaf yaadannoo gabaabaa fi gaaffii shaakalaa deebii isaanii waliin.
Fuula boqonnaa 3 baniWanta barnoonni jedhu hunda
Jechoota barnootaa kutaa kutaan. Barnoota achii jalqabee taphachiisuuf yeroo tuqi.
0:00Introduction
Before anyone builds a database, they plan it. What things will it store? What will it record about each one? And how are those things linked? Your book calls this plan the data model. Learn its three parts, and you can read any database.
0:17The blueprint of a database
A data model is the blueprint of a database. It shows three things. First, entities: the people, places or events you want to store data about. A bank keeps data about customers and bank accounts. In the database, each entity becomes a table.
Second, attributes: the properties of an entity, which tell one entity apart from another. A customer has a customer id, a name, a sex and an address.
Third, relationships: an association between entities. A customer has an account. That verb, has, names the relationship.
1:03The Student table
Here is part of the student table from your book. The entity is student, so the table is called Student. Each column is an attribute: student ID, sex, grade and name.
Each row is a record: one real student. And look at the student ID. No two students can have the same one. A field with a unique value for each record is called the primary key.
1:31Practice question 1Qormaata darbe
Here is a practice question. In a bank database, customer is an entity. Which of these is an attribute of the customer entity? Pause the video, and try it.
An attribute is a property of the entity. Customer id describes a customer, and tells one customer from another. The answer is B. Has is the verb that names a relationship. A bank account is an entity of its own. And a relationship is a link between entities, not a property of one.
2:10Three kinds of relationship
Relationships come in three forms, and they count instances. An instance is one single case of an entity: Addis Ababa is an instance of the entity city.
One-to-one: each instance goes with only one instance on the other side. A country has one capital city, and a capital city belongs to only one country.
One-to-many: one instance goes with many. One department, like Computer Science, has many students. Many-to-many: many on both sides. An employee may work on many projects, and a project may have many employees.
2:52Practice question 2Qormaata darbe
Try this one. A country is associated with one capital city, and a capital city is associated with only one country. What type of relationship is this? Pause, and try it.
Count each side. One country, one capital. One capital, one country. One on both sides is one-to-one. The answer is A. One-to-many would need a country with many capitals. Many-to-many needs many on both sides. And a primary key is a field with a unique value, not a kind of relationship.
3:34Summary
So remember. An entity is who or what you store data about, and it becomes a table. An attribute is a property of an entity, a column in that table. A relationship links entities: one-to-one, one-to-many, or many-to-many. Keep practising questions like these on Temari.et.
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 jalqabiTemari.et appii Android qaba; Google Play irratti bilisaan argama.

