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 de nov de 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 de sept de 2015

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