请教这几张表如何画E-R图，在线等

[JayPan2008]

create table ZYXXB
(
ZYBH varchar(8) primary key,
ZYMC varchar(50) not null,
ZYJC varchar(20) null,
ZYBZ varchar(100) null,
)

create table XSXXB
(
XSXH varchar(15) primary key,
XSXM varchar(20) not null,
XSXB char(2) check(XSXB in('男','女')) not null,
ZYFX varchar(4) null,
BJBH varchar(10) constraint FK_BJBH foreign key references BJXXB(BJBH),
XSBZ varchar(100) null
)
create table BJXXB
(
BJBH varchar(10) primary key,
BJMC varchar(50) not null,
BJJC varchar(20) null,
RXNF int not null,
ZYBH varchar(8) constraint FK_ZYBH foreign key references ZYXXB(ZYBH),
NSRS int null,
NVRS int null,
ZYBZ varchar(100) null
)

先谢谢各位，在线等

[JayPan2008]

等不到合适答案，大家都来回帖啊，我散分了

[feixianxxx]

画E-R图。。了解实体的联系就可以

[让你望见影子的墙]

ZYXXB 1:n BJXXB
BJXXB 1:n XSXXB
貌似这样

[liuhaifeng1976]

DING