6AUwFn2s

1create database if not exists lab3;
2use lab3;
3create table if not exists Client
4(clientNo int unique primary key auto_increment);
5
6create table if not exists PrivateOwner
7(ownerNo int unique primary key auto_increment);
8
9create table if not exists BusinesOwner
10(ownerNo int unique primary key auto_increment);
11
12create table if not exists PropertyForRent
13(propertyNo int unique primary key,
14ownerNo int,
15foreign key (ownerNo) references BusinesOwner(ownerNo),
16foreign key (ownerNo) references PrivateOwner(ownerNo)
17);
18
19create table if not exists Newspaper
20(newspaperName varchar(50) unique primary key);
21
22create table if not exists Advert
23(dateAdvert date,
24newspaperName varchar(50),
25foreign key (newspaperName) references Newspaper(newspaperName),
26propertyNo int,
27foreign key (propertyNo) references PropertyForRent(propertyNo),
28primary key(propertyNo, newspaperName, dateAdvert)
29);
30
31create table if not exists Lease
32(leaseNo int unique primary key,
33clientNo int,
34foreign key(clientNo) references Client(clientNo),
35propertyNo int,
36foreign key(propertyNo) references PropertyForRent(propertyNo)
37);
38
39create table if not exists Viewing
40(clientNo int,
41foreign key(clientNo) references Client(clientNo),
42propertyNo int,
43foreign key(propertyNo) references PropertyForRent(propertyNo),
44primary key(clientNo, PropertyNo)
45);