ПРИЛОЖЕНИЕ А
Листинг прораммы
Генерация SQL-скрипта.
CREATE TABLE Client
(
ID_client INTEGER NOT NULL,
ID_rent_contract CHAR(18) NOT NULL,
ID_sale_contract INTEGER NOT NULL
);
ALTER TABLE Client
ADD PRIMARY KEY (ID_client);
CREATE TABLE Individual
(
Individual_FIO CHAR(18) NULL,
Individual_Telephone CHAR(18) NULL,
ID_individual INTEGER NOT NULL,
ID_client INTEGER NOT NULL
);
ALTER TABLE Individual
ADD PRIMARY KEY (ID_individual);
CREATE TABLE Juridical
(
Juridical_Name VARCHAR(20) NULL,
Juridical_Telephone INTEGER NULL,
ID_juridical INTEGER NOT NULL,
ID_client INTEGER NOT NULL
);