皮皮学，免费搜题
登录
搜题
【简答题】
[说明] E 软件开发公司，决定开发设计本公司的项目工作管理系统，由承担数据库的设计工作。公司项目管理的需求分析如下。 1．组织机构：E公司有多个部门，每个部门有多个职员、多个办公室，每个办公室有一部电话。当部门变更时更换新的部门代码。职员辞职后，若再次被聘用仍使用辞职前的代码。被聘用职员担任某职务，职务用职务代码来标识。职务分为工程师、高级工程师、经理助理、经理等。职员的工资根据等级区分，共分为S、A、B、C、D五个等级。—个职务对应某个等级，一个等级对应多个职务。职员月工资等于职员月工作时间(小时)乘以小时工资。职员的人事变动以及职位变更(升级、降级)在月初进行。 2．项目管理：项目用项目代码标识，使用过的项目代码不能重复使用。一个部门可承担多个项目，但一个项目仅由一个部门承担。一个项目有一名项目主管和多名职员：一名职员可参加多个项目。项目代码由系统自动生成，一旦项目建立，项目名、部门代码以及起始年月日不能再变更。 3．项目的工作管理流程为：项目工作计划输入(初始计划)→工作业绩输入→业绩生成(每月一次)→计划修正(每月一次)。 .项目工作计划输入：项目主管使用如图4-1所示的工作计划输入界面，输入项目代码、职员代码、职员参加某个项目的月工作时间(计划)。图中白色部分为可输入项。 .工作业绩输入：输入职员每天参加各个项目的工作时间。图4-2为工作业绩输入界面，图中白色部分为可输入项。其中，出勤时间由考勤系统管理，指定项目代码的顺序可以不同，并且一天可以输入多个项目代码，但同一个项目代码不能重复输入。 .业绩生成：月底汇总职员的当月工作业绩，生成月工作业绩表。 .计划修正：项目主管根据项目进度修改以后的工作计划。 根据公司的项目需求将数据库关系模式设计如下： 部门(部门代码，部门名，起始年月，终止年月，办公室，办公电话) 职务(职务代码，职务名) 等级(等级代码，等级名，年月，小时工资) 职员(职员代码，职员名，部门代码，职务代码，任职时间) 项目(项目代码，项目名，部门代码，起始年月口，结束年月日，项目主管) 工作计划(项目代码，职员代码，年月，工作时间) 请使用“关系模式标记规则”，给出部门、等级、项目、工作计划关系模式的主键和外键，以及基本函数依赖集F1、F2、F3和F4。
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
.
..
皮皮学刷刷变学霸
举一反三
【单选题】Which of the following best describes the relationship of the first paragraph of the passage to the passage as a whole?
A.
It provides a group of specific examples from which generalizations concerning the nature of drama are drawn later in the passage.
B.
It explains principles concerning one aspect of tragedy, which are followed later by principles for other aspects.
C.
It defines terms of dramatic principles that are more thoroughly explained later in the passage.
D.
It briefly compares and contrasts the principles of drama that are examined in detail later in the passage.
E.
It explains a method of judging a work of drama, a method that is used later in the passage.
查看完整题目与答案
【单选题】Which of the following best describes the function of the concluding sentence of the passage?
A.
It sums up the general points concerning the mechanization of work made in the passage as a whole.
B.
It draws a conclusion concerning the effects of the mechanization of work which goes beyond the evidence presented in the passage as a whole.
C.
It restates the point concerning technology made in the sentence immediately preceding it.
D.
It qualifies the author's agreement with scholars who argue for a major revision in the assessment of the impact of mechanization on society.
查看完整题目与答案
【单选题】乒乓球拍分为直拍与横拍两种,由木制球板、海绵、以及橡胶皮组成。胶皮必须一面是( )色,另一面是( )色。
A.
红，绿
B.
红，蓝
C.
红，黑
D.
没有规定
查看完整题目与答案
【单选题】英国设计师德莱赛属于（ ）设计师。
A.
现代主义运动
B.
装饰艺术运动
C.
新艺术运动
D.
工艺美术运动
查看完整题目与答案
【单选题】Which of the following best describes the relationship of the first paragraph of the passage as a whole?
A.
It compares and contrasts several achievements that are thoroughly examined later in the passage.
B.
It defines terms and relationships that are challenged in an argument later in the passage.
C.
It provides a host of concrete examples from which generalizations are drawn later in the passage.
D.
It leads to an assertion that is supported by examples and manifestations later in the passage.
查看完整题目与答案
【单选题】患者,女性,24岁,贫血1年,血红蛋白80g/L,对缺铁性贫血治疗中最重要的措施是
A.
补充铁剂
B.
病因治疗
C.
脾切除
D.
少量输血
E.
肌内注射维生素B12
查看完整题目与答案
【单选题】Which of the following is the main reason for the multiple problems according to the passage?
A.
Writing scientific papers.
B.
Collaboration and responsibility in writing scientific papers.
C.
Advantages and disadvantages of team science.
D.
Multiple authors.
查看完整题目与答案
【简答题】风靡世界的迷你裙是英国设计师______设计的。
查看完整题目与答案
【单选题】Which of the following best describes the organization of the third paragraph of the passage?
A.
A theory is proposed, considered, and then amended.
B.
Opposing views are presented, elaborated, and then reconciled.
C.
A problem is described, then a solution is discussed and its effectiveness is affirmed.
D.
A view is advanced, then refuted, and an alternative is suggested.
E.
A hypothesis is presented, qualified, and then reaffirmed.
查看完整题目与答案
【单选题】英国设计师 Hussein Chalayan 是一名怪才,对他设计的描述下列哪个较为符合:
A.
（1）有创意，但非常注重实用性市场反应
B.
（2）只专注于解构设计
C.
（3）创意性、实验性、概念化。
查看完整题目与答案
相关题目：
【单选题】Which of the following best describes the relationship of the first paragraph of the passage to the passage as a whole?
A.
It provides a group of specific examples from which generalizations concerning the nature of drama are drawn later in the passage.
B.
It explains principles concerning one aspect of tragedy, which are followed later by principles for other aspects.
C.
It defines terms of dramatic principles that are more thoroughly explained later in the passage.
D.
It briefly compares and contrasts the principles of drama that are examined in detail later in the passage.
E.
It explains a method of judging a work of drama, a method that is used later in the passage.
查看完整题目与答案
【单选题】Which of the following best describes the function of the concluding sentence of the passage?
A.
It sums up the general points concerning the mechanization of work made in the passage as a whole.
B.
It draws a conclusion concerning the effects of the mechanization of work which goes beyond the evidence presented in the passage as a whole.
C.
It restates the point concerning technology made in the sentence immediately preceding it.
D.
It qualifies the author's agreement with scholars who argue for a major revision in the assessment of the impact of mechanization on society.
查看完整题目与答案
【单选题】乒乓球拍分为直拍与横拍两种,由木制球板、海绵、以及橡胶皮组成。胶皮必须一面是( )色,另一面是( )色。
A.
红，绿
B.
红，蓝
C.
红，黑
D.
没有规定
查看完整题目与答案
【单选题】英国设计师德莱赛属于（ ）设计师。
A.
现代主义运动
B.
装饰艺术运动
C.
新艺术运动
D.
工艺美术运动
查看完整题目与答案
【单选题】Which of the following best describes the relationship of the first paragraph of the passage as a whole?
A.
It compares and contrasts several achievements that are thoroughly examined later in the passage.
B.
It defines terms and relationships that are challenged in an argument later in the passage.
C.
It provides a host of concrete examples from which generalizations are drawn later in the passage.
D.
It leads to an assertion that is supported by examples and manifestations later in the passage.
查看完整题目与答案
【单选题】患者,女性,24岁,贫血1年,血红蛋白80g/L,对缺铁性贫血治疗中最重要的措施是
A.
补充铁剂
B.
病因治疗
C.
脾切除
D.
少量输血
E.
肌内注射维生素B12
查看完整题目与答案
【单选题】Which of the following is the main reason for the multiple problems according to the passage?
A.
Writing scientific papers.
B.
Collaboration and responsibility in writing scientific papers.
C.
Advantages and disadvantages of team science.
D.
Multiple authors.
查看完整题目与答案
【简答题】风靡世界的迷你裙是英国设计师______设计的。
查看完整题目与答案
【单选题】Which of the following best describes the organization of the third paragraph of the passage?
A.
A theory is proposed, considered, and then amended.
B.
Opposing views are presented, elaborated, and then reconciled.
C.
A problem is described, then a solution is discussed and its effectiveness is affirmed.
D.
A view is advanced, then refuted, and an alternative is suggested.
E.
A hypothesis is presented, qualified, and then reaffirmed.
查看完整题目与答案
【单选题】英国设计师 Hussein Chalayan 是一名怪才,对他设计的描述下列哪个较为符合:
A.
（1）有创意，但非常注重实用性市场反应
B.
（2）只专注于解构设计
C.
（3）创意性、实验性、概念化。
查看完整题目与答案