CREATE TABLE `contact` (
	`id` int PRIMARY KEY,
	`first name` varchar(255),
	`last name` varchar(255)
);
CREATE TABLE `address` (
	`id` int PRIMARY KEY,
	`street address` varchar(255),
	`house number` varchar(255),
	`zipcode` varchar(255),
	`city` varchar(255)
);
CREATE TABLE `contact_address` (
	`contact_id` int,
	`address_id` int,
	FOREIGN KEY(`contact_id`) REFERENCES `contact` (`id`),
	FOREIGN KEY(`address_id`) REFERENCES `address` (`id`)
);
CREATE TABLE `contact_phonenumber` (
	`contact_id` int,
	`phonenumber_id` int,
	FOREIGN KEY(`contact_id`) REFERENCES `contact` (`id`),
	FOREIGN KEY(`phonenumber_id`) REFERENCES `phonenumber` (`id`)
);
CREATE TABLE `phonenumber` (
	`id` int PRIMARY KEY,
	`phonenumber` varchar(255),
	`mobile` varchar(255),
	`fax` varchar(255)
);