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)