Журналы. 5. Инфологическая модель

5. Инфологическая модель

8.Реализация проекта командами SQL

create database gyrnalj;

use gyrnalj;

create table gyrnal(

id_gyrn integer not null,

nomer_gyrn integer not null,

nazv_gyrn char(20) not null,

god_vjp_gyrn integer not null,

primary key (id_gyrn));

create table registr(

id_reg integer not null,

kod_gyrn integer not null,

tema char(20),

kratk_opis char(50),

primary key (id_reg),

foreign key (kod_gyrn) references gyrnal(id_gyrn));

Прокат

1) Инфологическая модель

2) Реализация проекта командами SQL

create database prokat;

use prokat;

create table klient(

id_kl integer not null,

fam_kl char(20) not null,

name_kl char(10) not null,

otch_kl char(10) not null,

adres_kl char(30) not null,

primary key (id_kl));

create table film(

id_film integer not null,

nazv_filma char(20) not null,

ganr_filma char(10) not null,

primary key (id_film));

create table registr(

id_reg integer not null,

kod_kl integer not null,

kod_filma integer not null,

data_vjdachi date not null,

summa_opl real (3,2),

primary key (id_reg),

foreign key (kod_kl) references klient(id_kl),

foreign key (kod_filma) references film(id_film));

Поиск по сайту: