Таксопарк

Больница

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

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

create database qwe;

use qwe;

create table bolnie (

id_bol integer not null,

fam_b char(20) not null,

name_b char(10) not null,

otc_b char(15) not null,

address_b char(50) not null,

work_b char(25) not null, primary key(id_bol));

create table vrach (

id_vr integer not null,

fam_vr char(20) not null,

otc_vr char(15) not null,

address_vr char(50) not null,

cabinet_vr char(2) not null,

time_vr char(10) not null,

primary key(id_vr));

create table reg (

id_r integer not null,

kol_b integer not null,

kol_vr integer not null,

date_p date not null,

diag char(20) not null,

primary key(id_r),

foreign key (kol_b) references bolnie(id_bol),

foreign key (kol_vr) references vrach(id_vr));

Таксопарк

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

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

create database taksopark;

use taksopark;

create table voditel (

id_vod integer not null,

fam_vod char(20) not null,

name_vod char(10) not null,

otch_vod char(15) not null,

adres_vod char(50) not null,

primary key(id_vod));

create table mashin (

id_mash integer not null,

nomer_mash char(20) not null,

bnomer_mash char(20) not null,

pok_mash char(10) not null,

primary key(id_mash));

create table bookuch(

id_book integer not null,

time_vjezd date not null,

time_pr date not null,

kod_vod integer not null,

kod_mash integer not null,

foreign key (kod_vod) references voditel(id_vod),

foreign key (kod_mash) references mashin(id_mash));

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