Question d’entretien chez BNY

What is wrong with this SQL table? Primary Key: House Attributes: HouseID HouseAddress OwnerFirstName OwnerLastName OwnerSSN HouseSize

Réponses aux questions d'entretien

Utilisateur anonyme

30 nov. 2013

All the attributes starting with Owner could be put into another tables. List some other analytical solutions as to the risks involved with having mixed data.

1

Utilisateur anonyme

25 sept. 2015

Yes owner details should be in owners' table(firstname,lastname,ssn) Also primary key of the house table should be houseid(num)