# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818542

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Demonstrate the use of two or more conditional statements using logical operators (i.e., AND, OR, NOT).

Definition

Demonstration should include logical operators:
  • AND, which seeks both sides to be TRUE
  • OR, which seeks one side to be TRUE
  • NOT, which seeks the reverse result
Note that the AND operator attaches itself to the nearest statement, and parentheses may be needed to force the order of operations.

Related Standards of Learning

Mathematics

COM.8

The student will implement conditional statements that include “if/then” statements, “if/then/else” statements, case statements, and Boolean logic.

COM.13

The student will implement various mechanisms for performing iteration with an algorithm

Other Related Standards

Microsoft Imagine Academy Resources

[3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2

[4.019] Access 2010: Modify Database Tables—Lesson 3

[5.035] Access 2010: Project 3

NBEA Achievement Standards for Information Technology

Sort, prioritize, and retrieve data from databases.