DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
One-to-many (1:M)
|
|
|
Many-to-many (M:N or M:M)
|
|
|
One-to-one (1:1)
|
|
|
Many-to-one (M:1)
|
|
|
All of the above
|
Detailed explanation-1: -A one-to-one relationship is a link between the information in two tables, where each record in each table only appears once.
Detailed explanation-2: -1-1 relationships are also necessary if you have too much information. There is a record size limitation on each record in the table. Sometimes tables are split in two (with the most commonly queried information in the main table) just so that the record size will not be too large.
Detailed explanation-3: -In a relational database, a one-to-one relationship exists when one row in a table may be linked with only one row in another table and vice versa. It is important to note that a one-to-one relationship is not a property of the data, but rather of the relationship itself.
Detailed explanation-4: -Monogamy is a relationship with only one partner at a time, rather than multiple partners. A monogamous relationship can be sexual or emotional, but it’s usually both. Many modern relationships are monogamous.