Q$3$: An apartment must be owned by exactly one person and a person can own maximum one apartment. There are many persons having no apartment. A person has NID, name, gender, profession, birth registration number, date of birth, street, city and income. An apartment has app$\_$id$,$ size, building$\_$name, total number of floors, location and price.

Draw the ERD and transform the ERD into relational schema. Write SQL to create the tables according to the relation schema