大学毕业设计关于数据库外文翻译2篇

1、重庆理工大学2013届本科生毕业设计（论文）外文文献翻译原文：Structure of the Relational database « Database System Concepts » Part1: Relational DatabasesThe relational model is the basis for any relational database management system (RDBMS).A relational model has three core components: a collection of obj ects or rela

2、tions, operators that act on the objects or relations, and data integrity methods. In other words, it has a place to store the data, a way to create and retrieve the data, and a way to make sure that the data is logically consistent.A relational database uses relations, or two -dimensional tables, t

3、o store the information needed to support a business. Let's go over the basic components of a traditional relational database system and look at howa relational databaseisdesigned.Once youhave a solidunderstanding of what rows, columns, tables, and relationships are, you'llbe well on your wa

4、ytoleveragingthe powerof a relationaldatabase.Tables, Row, and ColumnsA table in a relational database, alternatively known as a relation, is a two-dimensional structure used to hold related information. A database consists of one or more related tables.Note: Don't confuse a relation with relati

5、onships. A relation is essentially a table, and a relationship is a way to correlate, join, or associate two tables.A row in a table is a collection or instance of one thing, such as one employee or one line item on an invoice. A column contains all the information of a single type, and the piece of

6、 data at the intersection of a row and a column, a field, is the smallest piece of information that can be retrieved with the database's query language. For example, a table with information about employees might have a column calledLAST_NAME that contains all of the employees' last names. D

7、ata is retrieved from a table by filtering on both the row and the column.Primary Keys, Datatypes, and Foreign KeysThe examples throughout this article will focus on the hypothetical work of Scott Smith, database developer and entrepreneur. He just started a new widget company and wants to implement

8、 a few of the basic business functions using the relational database to manage his Human Resources (HR) department.Relation: A two-dimensional structure used to hold related information, also known as a table.Note: Most of Scott's employees were hired away from one of his previous employers, som

9、e of whom have over 20 years of experience in the field. As a hiring incentive, Scott has agreed to keep the new employees' original hire date in the new database.Row:A group of one or more data elements in a database table that describes a person, place, or thing.Column:The component of a datab

10、ase table that contains all of the data of the same name and type across all rows.You'll learn about database design in the following sections, but let's assume for the moment that the majority of the database design is completed and some tables need to be implemented. Scott creates the EMP

11、table to hold the basic employee information, and it looks something like this:AMEJOB1 11 i.SAItJtnxnSMITHKLERK-DEC-SOROG*一硼ALLE1MJC'WARDALES MAX125C勃MANAGED骸KINJGPRESIDENT-XOV-R小FCRDanalyst德-DEC-R】Notice that some fields in the Commission (COMM) and Manager (MGR) columns do not contain a value;

12、 they are blank. A relational database can enforce the rule that fields in a column may or may not be empty. In this case, it makes sense for an employee who is not in the Sales department to have a blank Commission field. It also makes sense for the president of the company to have a blank Manager

13、field, since that employee doesn't report to anyone.Field:The smallest piece of information that can be retrieved by the database query language. A field is found at the intersection of a row and a column in a database table.On the other hand, none of the fields in the Employee Number (EMPNO) co

14、lumn are blank. The company always wants to assign an employee number to an employee, and that number must be different for each employee. One of the features of a relational database is that it can ensure that a value is entered into this column and that it is unique. TheEMPNO column, in this case,

15、 is the primary key of the table.Primary Key:A column (or columns) in a table that makes the row in the table distinguishable from every other row in the same table.Notice the different datatypes that are stored in the EMP table: numeric values, character or alphabetic values, and date values.As you

16、 might suspect, the DEPTNO column contains the department number for the employee. But how do you know what department name is associated with what number? Scott created the DEPT table to hold the descriptions for the department codes in the EMP table.DJT1AOl.OC10ACCOLMIXGNEV Y口RK201DALLAS30SALESCHI

17、CAGO40OPEP.AT1DX5130 5 TONThe DEPTNO column in the EMP table contains the same values as the DEPTNO column in the DEPT table. In this case, the DEPTNO column in the EMP table is considered a foreign key to the same column in the DEPT table.A foreign key enforces the concept of referential integrity

18、in a relational database. The concept of referential integrity not only prevents an invalid department number from being inserted into the EMP table, but it also prevents a row in the DEPT table from being deleted if there are employees still assigned to that department.Foreign Key:A column (or colu

19、mns) in a table that drawsits valuesfrom a primary or unique key column in another table. A foreign key assists in ensuring the data integrity of a table. Referential IntegrityAmethod employed by a relational database system that enforces one-to-many relationships between tables.Data ModelingBefore

20、Scott created the actual tables in the database, he went through a design process known as data modeling. In this process, the developer conceptualizes and documents all the tables for the database.One of the common methods for mod eling a database is called ERA, which stands for entities, relations

21、hips, and attributes. The database designer uses an application that can maintain entities, their attributes, and their relationships. In general, an entity corresponds to a table in the database, and the attributes of the entity correspond to columns of the table.Data Modeling:A process of defining

22、 the entities, attributes, and relationships between the entities in preparation for creating the physical database.The data-modeling process involves defining the entities, defining the relationships between those entities, and then defining the attributes for each of the entities. Once a cycle is

23、complete, it is repeated as many times as necessary to ensure that the designer is capturing what is important enough to go into the database. Let's take a closer look at each step in the data-modeling process.Defining the EntitiesFirst, the designer identifies all of the entities within the sco

24、pe of the database application.The entities are the pers ons, places, or things that are important to the organization and need to be tracked in the database. Entities will most likely translate neatly to database tables. For example, for the first version of Scott's widget company database, he

25、identifies four entities: employees, departments, salary grades, and bonuses. These will become the EMP, DEPT, SALGRADE, and BONUS tables.Defining the Relationships Between EntitiesOnce the entities are defined, the designer can proceed with defining how each of the entities is related. Often, the d

26、esigner will pair each entity with every other entity and ask, "Is there a relationship between these two entities?" Some relationships are obvious; some are not.In the widget company database, there is most likely a relationshipbetween EMP and DEPT, but depending on the business rules, it

27、 is unlikely that the DEPT and SALGRADE entities are related. If the business rules were to restrict certain salary grades to certain departments, there would most likely be a new entity that defines the relationship between salary grades and departments. This entity would be known as an associative

28、 or intersection table and would contain the valid combinations of salary grades and departments.Associative Table:A database table that stores th e valid combinations of rows from two other tables and usually enforces a business rule. An associative table resolves a many -to-many relationship.In ge

29、neral, there are three types of relationships in a relational database:One-to-many The most common type of relationship is one-to-many.This means that for each occurrence in a given entity, the parent entity, there may be one or more occurrences in a second entity, the child entity, to which it is r

30、elated. For example, in the widget company database, the DEPT entity is a parent entity, and for each department, there could be one or more employees associated with that department. The relationship between DEPT and EMP is one -to-many.One-to-one In a one-to-one relationship, a row in a table is r

31、elated to only one or none of the rows in a second table. This relationship type is often used for subtyping. For example, an EMPLOYEEtable mayhold the information common to all employees, while the FULLTIME, PARTTIME, and CONTRACTOR tables hold informationunique tofull-time employees, part-time emp

32、loyees, and contractors, respectively.These entities would be considered subtypes of an EMPLOYEE and maintain a one-to-one relationship with the EMPLOYEE table. These relationships are not as common as one -to-many relationships, because if one entity has an occurrence for a corresponding row in ano

33、ther entity, in most cases, the attributes from both entities should be in a single entity.Many-to-many In a many-to-many relationship, one row of a table may be related to man y rows of another table, and vice versa. Usually, when this relationship is implemented in the database, a third entity is

34、defined as an intersection table to contain the associations between the two entities in the relationship. For example, in a database used for school class enrollment, the STUDENT table has a many -to-many relationship with the CLASS table one student may take one or more classes, and a given class

35、may have one or more students. The intersection table STUDENT_CLASS would contain the comb inations of STUDENT and CLASS to track which students are in which classes.Once the designer has defined the entity relationships, the next step is to assign the attributes to each entity. This is physically i

36、mplemented using columns, as shown here for th e SALGRADE table as derived from the salary grade entity.After the entities, relationships, and attributes have been defined, the designer may iterate the data modeling many more times. When reviewing relationships, new entities may be discovered. For e

37、xample, when discussing the widget inventory table and its relationship to a customer order, the need for a shipping restrictions table may arise.(；R.DL1.05 Al1|70012002not3140)工OOP42-0015610DW12500Once the design process is complete, the physical database tables may be created. Logical database des

38、ign sessions should not involve physical implementation issues, but once the design has gone through an iteration or two, it's the DBA's job to bring the designers "down to earth." As a result, the design may need to be revisited to balance the ideal database implementation versus

39、the realities of budgets andschedules.译文：关系数据库的结构数据库系统结构第一章： 关系数据库 关系模型是任何关系数据库管理系统（RDBMS的基础。一个关 系模型有二个核心组件：对象或关系的集合，作用于对象或关系上的 操作，以及数据完整性规则。换句话说，关系数据库有一个存储数据 的地方，一种创建和检索数据的方法，以及一种确认数据的逻辑一致 性的方法。一个关系数据库使用关系或二维表来存储支持某个事物所需的 信息。让我们了解一下一个传统的关系数据库系统的基本组件并目学 习如何设计一个关系数据库。一旦你对于行、歹U、表和关联是什么有 了深刻理解，你就能够充分发挥

40、关系数据库的强大功能。表，行和列在关系数据库中，一个表（或者说一个关系）是一个用于保存相 关信息的二维结构。一个数据库由一个或者多个相关联的表组成。注意：不要混淆了关系和关联。一个关系实际上是一个表，而一 个关联指的是一种连接、结合或联合两个表的方式。表中的一行是一种事物的集合或实例，比如一个员工或发票上的 一项。表中的一列包含了一类信息；而且行列交叉点上的数据，字段， 即是能够用数据库查询语言检索到的最小片信息。举个例子来说，一 个员工信息表可能有一个“名字”歹I，列中就包含所有员工的名字。 数据是通过对行、列进行过滤而从表中检索出来的。主码、数据类型和外码本篇文章均以假设的斯科特史密斯的工

41、厂为例，他是数据库的 建立者和企业的主办人。他刚开办了一个饰品公司并目想要使用关系 数据库的几项基本功能来管理人力资源部门。关系：用来保存相关信息的一个二维结构（也就是表）。注意：大多数斯科特的雇员都是雇自过去的从业者，他们中有些 人在这个领域己经有20年的经验了。出于雇用的目的，斯科特同意 在新数据库中维持新进员工最初的雇佣日期。行：在一个数据库表中的一组单数据或多数据元素，用于描述一 个人、地方或事物。歹I：列是数据库表的组件，它包含所有行中同名和同类型的所有 数据。你会在下面章节学到如何设计数据库，现在让我们假设数据库大 部分己经设计完成并且有一些表需要被执行。斯科特创建了 EMP表来

42、保存基本的员工信息，就像这样：Q L%号工科营曜人二FJ此同史« Pi公计791JC17 J2-HUHOU2O2-4SIiEjuJD推用地乃帕22-2-MII2WSOD配必4图3017-11-HI10福特苣任 B- 32-HI30口你可能注意到佣金列和管理人列中有一些单元格中没有值；它们 是空值。一个关系数据库能够规定列中的一个单元格是否为空。如此， 可以明确那些非销售部的员工佣金单元为空。同样也明确了公司董事 长的管理人单元为空，因为这个员工不需要向任何人汇报工作。单元格：是数据库查询语言所能够检索到的最小片信息。一个单 元格就是一个数据库表的行和列交叉形成的。另一方面，没有哪个员

43、工的员工编号单元为空。公司总是希望为 每个员工分配一个员工号，并目这个号码必须是每个员工都不同的。 关系数据库的一个特性能够确定某列的键入值必须为单值。如此，员 工编号列便是这个表的主码。主码：主码即是表中的一列（或多列），使每一行能够区别于同 表中的其他行留意一下EMP表中存储的不同数据类型：数值型，字符型或字母 型，以及日期型。如你所想，部门成员列保存的是员工所在部门的编号。但是你如 何知道哪个部门名称对应哪个部门编号呢？斯科特建立了 DEPT表来 具体描述EMP表中提到的部门编号的情况。*门弘除1 口激计时附行堀达扣方30情化佃,加.40a.%:；泣上统:EMP表中的部门编号列同DEPT

44、表中的部门编号列有着相同的值。 既然如此，EMP表中的部门编号列便被看作是与DEPT表中相同列对 应的外码。外码加强了关系数据库中参考完整性的概念。参考完整性的概念 不只可以阻止无效的部门编号被插入EMP表中，而且在某部门仍有员 工的情况下，可以防止DEPT表中该部门的信息被删除。外码：表中的一列（或多列），它的值来自于其他表的主码列或 单值列。一个外码有助于确定表中数据的完整性。参考完整性：是关系数据库用来加强表问一对多关联的一种方 式。数据建模在斯科特于数据库中创建真实表之前，他要经过一个称作数据建 模的过程。在这个过程中，数据库创建者定义和填写数据库中所有表。 有一种为数据库建模的方式叫

45、作ERA,它可以表示出实体、实体间的 关联和实体的属性。数据库设计者使用一个能够支持实体、实体属性 和实体间关联的应用程序。通常，一个实体对应数据库中的一个表， 而实体的属性对应于表中的列。数据建模：一个定义实体、实体属性和实体间关联的过程，从而 为建立物理数据库做准备。数据建模过程包括定义实体、定义实体问关联以及定义每个实体 的属性的过程。一旦一个周期完成，就需要不断重复直到设计者抓住 了重点，足以开始建立数据库。让我们进一步了解为数据库建模过程 的步骤。定义实体首先，设计者确定数据库应用程序范围内的所有实体。实体是人、 地方或事物，它们对于整个团体是重要的且需要被记录在数据库中。 实体将被

46、巧妙的转化为数据表。比如，在第一版斯科特饰品公司数据 库中，他定义了四个实体：员工、部门、工资水平和奖金。它们将称 为EMP（员工）表，DEPT（部门）表，SALGRADE（工资水平）表和BONUS （奖金）表。定义实体间的关联一旦定义了实体，设计者就能够继续定义每个实体间是如何关联 的。通常，设计者通常将每个实体同其他实体配对，并目考虑：“两 者之间是否存在关联呢？”实体问的某些关联是明显的，某些不是。在饰品公司数据库中，员工实体和部门实体间极可能存在关联， 而依据事物间的关系原则，部门实体跟工资水平实体间似乎就没有关 联了。如果事物间的关系原则是用来约束某个部门的工资水平的，就 可能需要一

47、个新的实体来说明工资水平和部门之间的关联。这个实体 被称作关系表或交表，其中包含工资水平和部门之间的有效联合。关系表：是一个数据库表，其中保存着另外两个表的行（记录） 问的有效结合，并且通常强调了事物间的关系原则。关联表处理的是 一个多对多关联。通常，关系数据库间有二种关联方式：一对多关联：最常见的关联是一对多关联。意思是对于每个给出 的现有实体（即父实体）都有一个或多个现有的另一个实体（即子实 体）与之相关联。举个例子来说，在饰品公司数据库中，部门实体是 一个父实体，而每个部门中，都有一个或多个员工属于该部门。这样， 部门实体和员工实体间的关联就是一对多关联。一对一关联：在一个一对一关联中，

48、表中的一行只关联另一个表中的一行甚至0行。这种关联类型通常用于子类型数据中。例如，一 个员工表可能保存了所有员工的信息，而全职表、兼职表和承包人表 则分别保存全职员工、兼职员工和承包人的信息。这些实体被认为是 员工表的子表，并目同员工表维持一对一关联。这种关系不像一对多 关联那么常见，因为如果一个实体与另一个实体总有对应行，在大多 数情况下，两个实体中的属性只在一个实体内出现就可以了。多对多关联：在多对多关联中，表的一行可能对应另一个表的许 多行，反之亦然。通常，当这些关联在数据库中被执行时，往往再定 义第三个实体用来保存前两个实体间的所有关联。例如，在一个学籍 注册数据库中，学生表与班级表之

49、间有一个多对多关联一一一个学生 可能听一门或多门课程，并目一个班级也可能有一个或多个学生。而 学生班级关系表中就包含了学生和班级之间的关系，以表明哪个学 生在哪个班。指定实体属性一旦设计者定义了实体间关联，下一步就是去指定每个实体的属 性。这是实现列的使用，如右图所示由工资水平实体所建立的工资水 平表。1辿任圾岛池酷乱历,战-7001n制工1如口0020()1jCUIJ二3ml里mono吐懒重复步骤：我们仍然在原地在定义了实体、关联以及属性之后，设计者往往要多重复几次数 据建模过程。当我们在回顾关联时，就会发现需要建立新的实体。比 如，当讨论饰品库存表和与它相关的客户订单时，就会发现需要制定

50、一个送货约束表。一旦设计过程完成，下面将要建立实际的数据库表。逻辑数据库的设计过程不会牵涉实际执行中的问题。然而，一旦设计进入到实际 的运作，数据库管理员就会很快让设计者从理想回到现实中来。结果， 设计就可能需要再次构想以求得理想的数据库存运行与预算和进度 之间的平衡。Database Management SystemSource : Database and Network JournalAuthor : David AndersonYou know that a data is a collectionof logically related dataelements that may

51、be structured in various wa ys to meet the multiple processing and retrieval needs of organizations and individuals. There' snothing new about data base-early ones were chiseled in stone, penned on scrolls, and written on index cards. But now database are commonly recorded on magnetically media,

52、 and computer programs are required to perform the necessary storage and retrieval operations.The system software package that handles the difficult tasks associated with created, accessing, and maintaining database records is in a DBMS package establish an interface between the database itself and

53、the users of the database. (These users may be applications programmers, managers and others with information needs, and various OS programmers.)A DBMS can organize, process, and present selected data elements from the database. This capability enables decision makers to search. Probe, and query dat

54、a contents in order to extract answers to nonrecurring and unplanned questions that aren ' tavailable in regular reports. These questions might initially b e vague and/or poorly defined, but people can “ browse " through the database until they have the needed information. In short, the DBM

55、S will“manage' the stored data itemsand assemble the needed items from the common database in response to the queries of those who aren ' t programmers. In a file -oriented system, users needingspecialinformationmay communicate their needsto aprogrammers,who,when time permits, willinformatio

56、n.Theavailability of a DBMS, however, offers users a much faster alternative communications patch (see figure).Special, direct, and other file processing approaches ate used to organize and structure data in single files. But a DBMS is able to integratedata elements fromseveral files to answer speci

57、fic userinquiries fir information. This means that the DBMS is able to structure and tie together the logically related data from several large files.Logical structures. Identifying these logical relationships is a job of the data administrator. A data definition language is used for this purpose. T

58、he DBMS may then Employ one of the following logical structuring techniques during storage access, and retrieval operation: list structures, hierarchical (tree) structures, and network structures, relational structures.1. List structures. In this logical approach, records are linked together by the use of pointers. A pointer is a data item in one record that identifies the storage location