tailieunhanh - Database System: Chapter 4 - The Relational Algebra and Calculus

Database System: Chapter 4 - The Relational Algebra and Calculus presents about Relational Algebra (Unary Relational Operations, Relational Algebra Operations From Set Theory, Binary Relational Operations, Additional Relational Operations, Examples of Queries in Relational Algebra); Relational Calculus. | Chapter 4 The Relational Algebra and Calculus Copyright © 2004 Ramez Elmasri and Shamkant Navathe 5/14/2020 4:10:14 AM Outline Relational Algebra Unary Relational Operations Relational Algebra Operations From Set Theory Binary Relational Operations Additional Relational Operations Examples of Queries in Relational Algebra Relational Calculus Tuple Relational Calculus Domain Relational Calculus Slide 4 - Database State for COMPANY All examples discussed below refer to the COMPANY database shown here. Slide 4 - Relational Algebra The basic set of operations for the relational model is known as the relational algebra. These operations enable a user to specify basic retrieval requests. The result of a retrieval is a new relation, which may have been formed from one or more relations. The algebra operations thus produce new relations, which can be further manipulated using operations of the same algebra. A sequence of relational algebra operations forms a relational algebra . | Chapter 4 The Relational Algebra and Calculus Copyright © 2004 Ramez Elmasri and Shamkant Navathe 5/14/2020 5:23:41 AM Outline Relational Algebra Unary Relational Operations Relational Algebra Operations From Set Theory Binary Relational Operations Additional Relational Operations Examples of Queries in Relational Algebra Relational Calculus Tuple Relational Calculus Domain Relational Calculus Slide 4 - Database State for COMPANY All examples discussed below refer to the COMPANY database shown here. Slide 4 - Relational Algebra The basic set of operations for the relational model is known as the relational algebra. These operations enable a user to specify basic retrieval requests. The result of a retrieval is a new relation, which may have been formed from one or more relations. The algebra operations thus produce new relations, which can be further manipulated using operations of the same algebra. A sequence of relational algebra operations forms a relational algebra expression, whose result will also be a relation that represents the result of a database query (or retrieval request). Slide 4 - Unary Relational Operations SELECT Operation SELECT operation is used to select a subset of the tuples from a relation that satisfy a selection condition. It is a filter that keeps only those tuples that satisfy a qualifying condition – those satisfying the condition are selected while others are discarded. Example: To select the EMPLOYEE tuples whose department number is four or those whose salary is greater than $30,000 the following notation is used: DNO = 4 (EMPLOYEE) SALARY > 30,000 (EMPLOYEE) In general, the select operation is denoted by (R) where the symbol (sigma) is used to denote the select operator, and the selection condition is a Boolean expression specified on the attributes of relation R Slide 4 - Unary Relational Operations SELECT Operation Properties The SELECT operation (R) produces

• Cơ sở dữ liệu
• Database System
• The Relational Algebra and Calculus
• Relational Algebra
• Relational Calculus
• Unary Relational Operations
• Relational Algebra Operations From Set Theory
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database design
• Database system architectures
• Relational database design
• Lecture Database System
• Database system architecture
• File based approach
• Data management systems framework
• Recovery system
• Lecture Database systems
• Database architecture
• Database approach
• Relational databases
• Database design process
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Application design
• Object­ based databases