文件名称:factory sql
- 所属分类:
- SQL Server数据库
- 资源属性:
- [SQL] [源码]
- 上传时间:
- 2017-11-14
- 文件大小:
- 64kb
- 下载次数:
- 0次
- 提 供 者:
- 逸***
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
某企业集团有若干工厂,每个工厂生产多种产品,且每一种产品可以在多个工厂生产,每个工厂按照固定的计划数量生产产品,计划数量不低于300;每个工厂聘用多名职工,且每名职工只能在一个工厂工作,工厂聘用职工有聘期和工资。工厂的属性有工厂编号、厂名、地址,产品的属性有产品编号、产品名、规格,职工的属性有职工号、姓名、技术等级(初级、中级、高级)。(A group has several factories, each plant produces a variety of products, and each product can be produced in a factory, the factory in accordance with each fixed quantity in the production plan, plan the number of not less than 300; each facility employs several employees, and each employee can only work in a factory, the factory workers employment duration of employment and wages. The attributes of the factory include the plant number, factory name and address. The attributes of the product include product number, product name and specification. The attributes of the staff include worker number, name and technical level (primary, intermediate, advanced).)
相关搜索: 工厂员工产品数据库
(系统自动生成,下载前可以参看下载内容)
下载文件列表
SQLQuery1.sql
实验1.docx
实验1.docx