Pregunta de entrevista de BNY

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

Respuestas de entrevistas

Anónimo

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

Anónimo

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)