2 Database models
There are several models of databases depending on the format in which the data is managed. The typical models are summarized below.
●Relational database Data is managed in tables. Multiple tables are linked by item values to build a database.
Student ID 2001010 2001021 2001021 2001021
Course name Mathematics 1 English Mathematics 1 French
Course name Mathematics 1 English French
Classroom A103 B211 B211
●Network database Data is managed in a meshed format. Many-to-many parent-child relationships
A103
B211
Mathematics 1 English French
2001010 2001021
Reference
Characteristics of relational databases
• Related data is managed in tables. →Easy for users to understand.
• Tables are linked by saved“ values.” →Easy to extract the user’ s desired data.
Reference
Use of relational databases Relational databases are used as the basic model for E-R diagrams.
Chapter 9 Technology element
●Hierarchical database Data is managed in a hierarchical structure. One-to-many parent-child relationships comprise the data.
A103 B211
Mathematics 1 English
French
2001010 2001021 2001021 2001021
248