Two of the five tables in the Solmaris Condominium database are defined as follows:Suppose...

Two of the five tables in the Solmaris Condominium database are defined as follows:

Suppose that a user accesses the database via the following view:

CREATE VIEW OwnerCondo AS

SELECT Owner.OwnerNum, LastName, FirstName, CondoID

FROM Owner, CondoUnit

WHERE Owner.OwnerNum=CondoUnit.OwnerNum

Suppose further that the database requirements have changed so that a condo can have multiple people as owners, just as people can own more than one condo. What's the new database design for the Owner and CondoUnit tables, as well as any other table(s) needed to satisfy the new requirements? Does the new database design affect the OwnerCondo view? If so, write the new defining query for the view.