Consider the following relations with keys underlined
Street (name, location, city)
House (number, street_name)
Lives (name, house_number)
Define the above relations as tables in SQL making real world assumptions about the type of the fields. Define the primary keys and the foreign keys.