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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Demonstrate the use of ANSI joins.

Definition

Demonstration should include using
  • cross join
  • natural join
  • join ... using
  • join ... on
  • right outer join
  • left outer join
  • full outer join
  • self-join
  • non-equijoin.

Related Standards of Learning

Mathematics

COM.3

The student will write program specifications that define the constraints of a given problem.

COM.7

The student will select and call library functions to process data, as appropriate.

COM.8

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

Other Related Standards

NBEA Achievement Standards for Information Technology

Extract useful information using search queries.