关系数据库外文文献翻译中英参考.docVIP

关系数据库外文文献翻译 () 文献出处： —《Database System Concepts》Part1 英文原文 Relational database structure —《Database System Concepts》Part1: Relational Databases ????The relational model is the basis of any relational database management system (RDBMS). A relational model has two core components: a collection of objects or relationships, operations on objects or relationships, and data integrity rules. In other words, relational databases have a place to store data, a way to create and retrieve data, and a way to confirm the logical consistency of data. 牋牋e A relational database uses relationships or two-dimensional tables to store the information needed to support something. Let us look at the basic components of a traditional relational database system and learn how to design a relational database. Once you have a deep understanding of what rows, columns, tables, and associations are, you can take full advantage of the power of relational databases. 牋牋reTables, rows and columns 牋牋blIn a relational database, a table (or a relationship) is a two-dimensional structure that holds relevant information. A database consists of one or more associated tables. 牋牋 aNote: Do not confuse relationships and associations. A relationship is actually a table, and an association refers to a way to connect, join, or join two tables. 牋牋teA row in a table is a collection or instance of a thing, such as an employee or an item on an invoice. A column in the table contains a class of information; and the data at the crossing point, the field, is the smallest piece of information that can be retrieved using the database query language. For example, an employee information table may have a name column that contains the names of all employees. Data is retrieved from the table by filtering rows and columns. 牋牋roMaster code, data type and outer code 牋牋stThis article uses the assumed Scott Smith factory as an example. He is the founder of the database and the organizer of the company. He just started a jewelry