To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

Question

Computers & Technology

Kolton Parks

22 January, 07:42

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

+5

Answers (1)

Know the Answer?

Lobster · Answer 1

True.

Explanation:

"1" to "M" or 1 to many is a type of relationship between tables in a relational database. It means that against 1 record in a table, there can be 0 to many rows in the other table. Not that the many or child table doesn't need to have any record against the 1 or parent row, so the many side is optional.

Example can be a Customer and Order relationship. Where Customer is the parent table and Order is the child table. "A customer can have 0 to many orders".