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)