What is true about the data in a lookup table?a.)They transform an M:N relationship into two 1:M relationships.b.)They resolve weak entities.c.)The table holds data in the form of key-value pairs.d.)They model pure relationships rather than entities.

a.) They transform an M:N relationship into two 1:M relationships: True. A lookup table is used to establish a relationship between two tables that have a many-to-many (M:N) relationship. It does this by breaking down the M:N relationship into two one-to-many (1:M) relationships.

b.) They resolve weak entities: False. Lookup tables do not resolve weak entities. Weak entities are resolved by creating a strong relationship with a strong entity, not by creating a lookup table.

c.) The table holds data in the form of key-value pairs: True. A lookup table typically holds data in the form of key-value pairs. The key is a unique identifier that corresponds to a specific value or set of values.

d.) They model pure relationships rather than entities: True. Lookup tables are used to model relationships between entities, not the entities themselves. They are used to establish connections between different entities in a database.