Question

in the original sample solution, a customer could only have one address. review the finalized sample solution for the database design. how many addresses can be linked to a customer? a.) 2 b.) unlimited c.) 1 d.) 4

Answer 1

Upon reviewing the finalized database schema, if it is designed to support a one-to-many relationship between customers and addresses, then a customer can have an unlimited number of addresses linked to them.

Step-by-step explanation:

In reviewing the finalized sample solution for the database design, the number of addresses that can be linked to a customer depends on the database schema.

If the schema allows for multiple addresses to be associated with each customer, then the answer would be b.) unlimited.

This is typically achieved through a one-to-many relationship, where one customer can have many addresses.

For example, a Customer table might have a primary key called CustomerID, and an Address table might have a foreign key also called CustomerID.

Each address would have its own unique AddressID as a primary key, but multiple Address entries could reference the same CustomerID, allowing for multiple addresses per customer.