数据库设ER图示例.docx
文本预览下载声明
一、部门构成及职责
1.人事系统：负责企业的人事工作
2.财务系统：负责企业的票据账单会计工作
3.电讯系统：企业主营业务系统
资讯推送:资讯的收集,提供给客户
运营维护:通信线路的正常运行维护工作
客户服务:接听客户热线,负责售后工作
4.营销系统:企业附属营销业务,包括网上商城业务,通信套餐业务
二、E-R设计图与逻辑设计
1.人事系统
E-R图
逻辑设计
Create database human_affairs;
Create table employee (
Eid int, name varchar(30),Did int, job varchar(30),
Primary key (Eid)
);
Create table Department(
Did int, d_name varchar(30), intro text, tel varchar(20),
Primary key (Did)
);
Create table manager (
Eid int, Did int,
Primary key(Eid)
);
Create table attendance (
ID int, attend_time datetime, Eid int ,
Primary key (ID)
);
Create table hr_decision (
ID int, Eid int, toEid int, event_type varchar, e_time datetime,
Primary key (ID)
);
2.财务系统
E-R图
逻辑设计
Create database financial;
Create table employee (
Eid int, name varchar(30),Did int, job varchar(30),
Primary key (Eid)
);
Create table invoice (
Invo_id int, Invo_content,
Primary key(Invo_id)
);
Create table invo_record (
ID int, invo_time datetime, Eid int , money float(10,2),
Primary key (ID)
);
Create table sale_record (
ID int, Cid int, money float(10,2), sale_time datetime,
Primary key (ID)
);
Create table financial_record (
ID int, Eid int, content text, r_time datetime,
Primary key (ID)
);
3.电讯系统
E-R图
逻辑设计
Create database telecom;
Create table costumer (
Cid int, name varchar(30),tel varchar(11), name varchar(30),
Primary key (Cid)
);
Create table call_record (
Call_id int, call_time time, Cid int, toCid int,
Primary key(Call_id)
);
Create table Employee (
Eid int, Did de, Eid int , job varchar(30),
Primary key (Eid)
);
Create table service_record (
ID int, Eid int, service_time datetime,
Primary key (ID)
);
Create table repair_record (
ID int, Eid int, content text, repair_time datetime,
Primary key (ID)
);
Create table information (
Info_id int, publisher int, pub_time datetime, title varchar(100), content text,
Primary key(Info_id)
);
4.营销系统
E-R图
逻辑设计
Create database marketing;
Create table costumer (
Cid int, name varchar(30),tel varchar(11), name varchar(30)
显示全部