作者ayomot038 (嘿，戴哥! 虾毁?)
看板NTUE-CS103
标题[课业] 资料库2009期中考古题 翻译
时间Sun Apr 15 19:57:06 2012
Mid-Exam (total 100 points), 2009\
Course: Database Management System Range: Ch. 1, 2, 3, 4, 5, 7
1.Please draw an EER diagram according to the following requirements. In
addition, transfer the EER diagram to the relational database schema diagram.
(40%)
(请依照下列条件画出EER图表。并且将EER图表转换成资料库关系架构图表)
A company named Great YU is organized into departments. Each department has
a unique name, a unique number, and a particular employee who manages the
department. We keep track of the start date when the employee began managing
the department. An employee may manage several departments. A department may
have several locations.
(一家名为Great YU是组织部门。各部门有独一的名字、编号，以及一位管理部门的特
别员工。当员工开始管理该部门时，我们纪录起始日期。一位员工可能管理好几个部
门。一个部门的所在地可能有好几个。)
A department controls several projects, each of which has a unique name, a
unique number, a single location, and a particular employee who manages the
project. Each employee manages at most one project.
(一个部门control多个project，每一个皆有独一的名字、独一的编号、单一地点，
及一位管理该project的特别员工。每位员工最多管理一个project。)
Each employee’s data include name, social security number, address, salary,
sex, telephone, and birth date. An employee is assigned to one department,
but may work on several projects. Some employees can be classified into one
of the three job types: secretary, technician, and engineer. We also keep
track of the number of hours per week that an employee works on each project.
Each employee could have a direct supervisor. Each employee may have
dependents, whose data include name, sex, birth date, and relationship to the
employee.
(每位员工的资料包含名字、SSN、住址、薪资、性别、电话和出生日期。一位员工会
被分配到一个部门，但可能参与多个project。部分员工可以分类至三种工作之一：
secretary(秘书)、technician(技术员)和engineer(工程师)。我们也记录员工每周在
各project上的工作时数。每位员工都有位direct supervisor。每位员工或许会有
dependents，此资料包含名字、性别、出生日期，以及与该员工之间的关系。)
2.Describe when we do not use DBMS? (10%)
(请描述我们何时不能用DBMS)
3.What’s difference between the database and file-processing approaches?
(10%)
(资料库和文件处理方法有什麽不同?)
4.Explain the following term. (20%)
(请解释下列术语)
a.Implementation data model
b.The three-schema architecture
(三层式纲要架构)
c.Three-tier client-server architecture
(三层事主从架构)
d.Structural constraints
<!--CH7-->
e.Shared subclass
<!--CH7-->
5.When we perform INSERT operation on a database, describe what constraints
may be violated, and what actions can be taken. (20%)
(当我们对一个资料库执行INSERT操作，请描述可能会违反甚麽限制，可采取怎样的行动)
有错请指正
--
Tuko正在跪求答案
有没有人好心给他一份
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 120.127.36.55
※ 编辑: ayomot038 来自: 120.127.36.55 (04/15 20:30)