Mid-Exam (Total score points: 104) Course: Database Management System Range: Ch. 1, 2, 3, 4 1.Describe when we do not use DBMS? (10%) (請描述我們何時不能用DBMS) 2.Explain the following term. (35%) (請解釋下列術語) a.Program-data independence (程式與資料的獨立性) b.Atomicity (in transactions) <!--意義不明--> c.The three-schema architecture (三層式綱要架構) d.Three-tier client-server architecture (三層事主從架構) e.Key constraints <!--這不翻譯--> f.Entity integrity constraints (實體完整性限制) g.Referential integrity constrains (參照完整性限制) 3.When we perform INSERT operation on a database, if integrity constraints are violated, what actions can be taken. (10%) (當我們對一個資料庫執行INSERT操作，如果違反完整性限制，要採取怎樣的行動) 4.What’s difference between the database and file-processing approaches? (10%) (資料庫和文件處理方法有什麼不同?) http://i.imgur.com/IxBFh.jpg 5.Answer the following queries using SQL according to the above figure. (35%) (根據上圖，使用SQL回答下列問題) a.Retrieve the salary and address of the employee whose name is 'John B. Smith'. (檢索員工John B. Smith的薪水和住址) b.For each employee, retrieve the employee's full name, and the full name of his or her immediate supervisor. (檢索每一位員工的全名和他(她)上司的全名) c.Retrieve the name and address of all employees who work for the 'Information Technology' department. (檢索在Information Technology部門工作的所有員工他們的姓名和住址) d.Retrieve the name of each employee who has a dependent with the same first name as the employee. (檢索每一位員工，他的dependent有和該員工一樣的first name) e.Make a list of all project names for projects that involve an employee whose last name is 'Tom' as a worker or as a manager of the department that controls the project. (列出所有last name為Tom的員工所參與的project，不論該員工是工作人員或是 管理該project的部門經理) f.Retrieve all employees whose address is in Taipei. Here, the value of the ADDRESS attribute must contain the substring ‘Taipei’ in it. (檢索所有住在台北的員工。地址屬性的值必須包含'Taipei'子字串) g.Give all employees in the 'Research' department a 25% raise in salary. (讓所有在'Research'部門的員工提高25%薪水。) 有錯請指正 -- Tuko正在跪求答案 有沒有人好心給他一份? --

※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 120.127.36.55 ※ 編輯: ayomot038 來自: 120.127.36.55 (04/15 18:00)