Domanda di colloquio di BNY

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

Risposte di colloquio

Anonimo

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

Anonimo

25 set 2015

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