数据库考前复习题.docVIP

Make a list of security concerns for a bank. For each item on your list, state whether this concern relates to physical security, human security, operating system security, or database security. 制定一个银行的安全问题列表。每个项目在您的名单，国家是否关注涉及物理安全，人身安全，操作系统安全、数据库安全。 2. Let the following relation schemas be given 让下面的关系模式是 3. R =(A,B,C)S =(D,E,F)Let relations r(R)and s(S) be given. Give an expression in SQL that is equivalent to each of the following queries. 让关系R（R）和S（S）be given。给年的表达在SQL 这是相当于下列查询。 a. ΠA(r) b. σB=17 (r) c. r × s d. ΠA,F (σC=D(r × s)) What are five main functions of a database administrator? 数据库管理员的五大主要功能是什么？ 4. Consider the following information about a university database:考虑以下信息一个的大学数据库： Professors have an SSN, a name, an age, a rank, and a research specialty. 教授有一个SSN，姓名，年龄，等级，和一个研究专业。 Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. 项目有项目编号，名称（例如，NSF）赞助，开始日期，结束日期年，与预算 Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). 研究生有一个SSN，姓名，年龄，和一个学位课程（例如，硕士或博士） Each project is managed by one professor (known as the project’s principal investigator). 每个项目都是由一个教授管理（称为项目的首席研究员）。 Each project is worked on by one or more professors (known as the project’s co-investigators). Professors can manage and/or work on multiple projects. 每个项目的工作由一个或多个教授（称为项目的合作者）。 Each project is worked on by one or more graduate students (known as the project’s research assistants) 每个项目的工作由一个或多个研究生（称为项目的研究助理） When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially di?erent) supervisor for each one. 当研究生工作的一个项目，一个教授必须监督该项目的工作。研究生可以工作在多个项目，在这种情况下，他们将有一个（可能不同地?）为每一个主管。 Departments have a department number, a department name, and a main o?ce. Departments have a professor (known as the chairman) who runs the department. 部门有一个教授（称为主席）谁运行部。 Professors