这个SQL语句怎么写？？？

Question

A表中  公司原工属性总表（属性序号，属性名称） 
       各个客室原工属性定义表：（部门，属性序号，属性名称）
      记录： 财务科 1 年龄
             财务科 2 性别
             财务科 3 工作年限            组织科 1 年龄
            组织科 2 性别
            组织科 4 家庭成分怎样写sql语句得出下面的结果？？？？
原工属性表：（原工，属性，属性值）
如原工属于财务科，则原工属性表中每个原工就有财务科的三个属性，eg：
           原工1 年龄 
           原工1 性别
           原工1 工作年限
           原工2 年龄 
           原工2 性别
           原工2 工作年限
           原工3 年龄 
           原工3 性别
           原工3 工作年限
如果各个客室原工属性记录发生变化
eg：财务科原工属性  财务科 1 年龄
                   财务科 3 工作 年限
    则属于财务科的原工的属性就相应减少一个变成：eg：
           原工1 年龄 
           原工1 工作年限
           原工2 年龄 
           原工2 工作年限
           原工3 年龄 
           原工3 工作年限
  

Answer 1

第一个表，就是总属性表  A(属性编号，属性名称)
第二个表，原工信息表 B(所属科室，原工编号，原工名称)
第三个表，原工属性表 C(原工编号，属性序号，属性取值)
第四个表，科室属性表 D(科室，属性号)指定了D表中财务科的原工属性
然后，C表对于每个原工就有这些属性
这可能要写触发器，是不是，就是当D表发生变化，C表记录就发生变化
比如向D表添加记录
               D  科室     属性号  
                 财务科   1 
                 财务科   2 
                 财务科   5 
                 财务科   6
同时B表的记录 B  所属科室  原工编号  原工名称
                 财务科     1         xx
                 财务科     2         yy
                 财务科     3         zz
当D表插入了 D  科室     属性号  
                 财务科   1 
                 财务科   2 
                 财务科   5 
                 财务科   6
那么D表  就得这样
原工编号  属性序号  属性取值
1         1
1         2
1         5
1         6
2         1
2         2
2         5
2         6
3         1
3         2
3         5
3         6这样清楚吗

Answer 2

我觉得可能得编写触发器，就是D(科室，属性号) 针对科室的记录增、删、改，都对第三个表，原工属性表 C(原工编号，属性序号，属性取值)的每个原工的属性进行相应的变化，
 D   科室    属性号 B  所属科室  原工编号  原工名称  则C   原工编号  属性序号  属性取值
    财务科   1         财务科     1         xx            1         1                 
    财务科   2         财务科     2         yy            1         2                 
    财务科   5         财务科     3         zz            1         5                 
    财务科   6                                          1         6                 
                                                       2         1                 
                                                       2         2                 
                                                       2         5                 
                                                       2         6                 
                                                       3         1                 
                                                       3         2                 
                                                       3         5                 
                                                       3         6                 D 科室     属性号  B 所属科室  原工编号  原工名称  C  原工编号  属性序号  属性取值  
  财务科   1            财务科     1      xx         1         1                  
  财务科   2            财务科     2      yy         1         2                  
  财务科   6            财务科     3      zz         1         6                  
                                                  2         1                  
                                                  2         2                  
                                                  2         6                  
                                                  3         1                  
                                                  3         2                  
                                                  3         6  

Answer 3

D   科室    属性号 B  所属科室  原工编号  原工名称 C   原工编号  属性序号  属性取值
    财务科   1         财务科     1         xx             1         1                 
    财务科   2         财务科     2         yy             1         2                 
    财务科   5         财务科     3         zz             1         5                 
    财务科   6                                             1         6                 
                                                           2         1                 
                                                           2         2                 
                                                           2         5                 
                                                           2         6                 
                                                           3         1                 
                                                           3         2                 
                                                           3         5                 
                                                           3         6                 D 科室     属性号  B 所属科室  原工编号  原工名称  C  原工编号  属性序号  属性取值  
  财务科   1            财务科     1         xx            1         1                  
  财务科   2            财务科     2         yy            1         2                  
  财务科   6            财务科     3         zz            1         6                  
                                                           2         1                  
                                                           2         2                  
                                                           2         6                  
                                                           3         1                  
                                                           3         2                  
                                                           3         6  

Answer 4

如果员工的基本信息在另一个表中emp,部门属性表per
select e.emp_name,p.属性序号,p.属性名称 from emp e,per p

Answer 5

select e.emp_name,p.属性序号,p.属性名称 from emp e,per p order by e.emp_name