Contents
Chapter 4 · DatabasePractice

LEARN WITH HARU

Video Lesson တွေက Haru အတန်းသားတွေအတွက်ပါ

Haru ရဲ့ ITPEC FE Full Course မှာ ယခု သင်ခန်းစာတွေကို တစ်ခုချင်း တစ်ကြောင်းချင်း အသေးစိတ်ရှင််ရှင်းပြထားပါတယ်

အခြေခံ မရှိတဲ့ ကျောင်းသားများစွာဟာလည်း ဒီ Course နဲ့ ပဲ အောင်မြင်ကုန်ကြပါပြီ

အတန်းမအပ်သေးပဲ Haru ဆီမှာ အစမ်းသင်ကြည့်ချင်ပါသလား?

သင်တန်းသားတွေရဲ့ စကားသံများ

သင်တန်းသားတွေရဲ့ စကားသံများ
Practice related questions (17)Progress & bookmarks

Current section

1-2 Database Design

p. 248

Practice this section 17 linked exam questions with default filters

Progress

Not marked complete

Progress and bookmarks

p. 248

1 - 2 Database Design

For using a database, it is necessary to analyze the data to be handled and design the database.

1-2-1 Data Model

Data model refers to modeling of various relations of data in the real world for handling them in computers. Data models are classified from the viewpoint of modeling.

Original textbook table, example or syntax box, with its complete original layout. Source text: • Conceptual data model It models relations of data without considering any specific database. It defines what kind of data is handled. • Logical data model (external model) It logically models the relations of data considering a specific database. It defines interrelations of data in the database. • Physical data model (internal model) It physically models the relations of data considering a specific database product. It defines the physical internal structure of a database such as data type.
p. 248 · Enlarge

Among these models, the following three data models are used as the logical data models considering a specific database.

Original textbook table, example or syntax box, with its complete original layout. Source text: • Hierarchical model It is a data model that represents the relations of data as a hierarchical structure where parent and child are in a one-to-many relationship. It is implemented as HDB (Hierarchical DataBase). • Network model It is a data model that represents the relations of data as a hierarchical structure where parent and child are in a many-to-many relationship. It is implemented as NDB (Network DataBase). • Relational model It is a data model that represents the relations of data in a two-dimensional table. It is implemented as RDB (Relational DataBase).
p. 248 · Enlarge

The database, such as HDB (Hierarchical DataBase) or NDB (Network DataBase), is referred

p. 249

to as structured database. This is a type of database where the user recognizes logical layout of data. In this textbook, the subsequent explanation is provided focusing on the RDB (Relational DataBase) that implements the relational model.

Section progress

Original chapter exercises

Original chapter exercises →

New FE Textbook Vol.1 · IT Fundamentals · First Edition, April 2015