create database if not exists Tema10;
use Tema10;

create table if not exists companie
(nume_companie varchar(50)unique primary key,
id int
);

create table if not exists adresa
(cod_postal int primary key,
oras varchar(50),
strada varchar(50)
);

create table if not exists locuinta
(id int primary key,
foreign key(id)references adresa(cod_postal));

create table if not exists cladire_birouri
(id int primary key,
nr_locuri_parcare int,
foreign key(id)references adresa(cod_postal)
);

create table if not exists apartamente
(id int primary key,
nr_camere int,
foreign key (id)references locuinta(id));

create table if not exists persoana
(id int unique primary key,
nume varchar(50),
foreign key(id)references apartamente(id)
);

create table if not exists telefon
(nr_tel int primary key,
id int,
foreign key (id) references persoana(id)
);

create table if not exists birou
(id int unique primary key,
conexiune_internet int,
foreign key (id)references cladire_birouri(id)
);

create table if not exists firma
(nume varchar(50) unique primary key,
nr_fiscal int,
id int,
foreign key (nr_fiscal)references birou(id)
);

create table if not exists inchiriator
(id int primary key,
data_inchiriere int,
foreign key (id)references firma(id),
foreign key (id)references persoana(id)
);

create table if not exists chirie_birou
(suma int primary key,
foreign key(suma)references birou(id)
);

create table if not exists chirie_apartament
(suma int primary key,
foreign key(suma)references apartament(id)
);