简单的人事管理系统:怎么比较合理规范的(范式要求高一点)设计数据库的各个表

2025-04-08 05:17:23
推荐回答(1个)
回答1:

员工基本信息表
{
employeeID varchar2(8) primary key,
employeeName varchar2(80) ,
employeeSex varchar2(6) ,
employeeOld number(3) ,
employeePhone number(11),
employeeMail varchar2(80),
postID varchar2(8),
departmentID varchar2(8)
}
员工婚姻情况表
{
employeeID varchar2(8) primary key,
isMarried char(1),
spouseName varchar2(80) ,
spouseOld number(3)
}
员工学历信息表
{
employeeID varchar2(8) primary key,
education varchar2(80) ,
professional varchar2(80) ,
graduationTime date,
school varchar2(80) ,
foreignLanguages varchar2(80)
}
企业工作岗位表
{
postID varchar2(8) primary key,
postName varchar2(80)
}
企业部门信息表
{
departmentID varchar2(8) primary key,
departmentName varchar2(80)
}