# CTE Resource Center - Verso - Database Design and Management (Oracle) NBEA Achievement Standards for Information Technology Correlation by Task

CTE Resource Center - Verso

Virginia’s CTE Resource Center

NBEA Achievement Standards for Information Technology Correlation by Task

In this course, the following tasks/competencies reinforce the standards listed beside them. Teachers may identify additional reinforcements in locally developed instructional materials.

Task/Competency Number Task/Competency Statement Standards
39 Research the history of databases. NBEA Achievement Standards for Information Technology: Analyze how developments in information technology affect the supply/demand characteristics of the job market. ♦ Evaluate how information technology transforms business processes and relationships. ♦ Examine how information technology changes the breadth and level of worker responsibilities. ♦ Explain the nature and interrelationships of bytes, fields, records, and databases. ♦ Identify and evaluate how information technology developments changes the way humans do their work. ♦ Illustrate how information technology changes organization structures.
40 List the major types of databases. NBEA Achievement Standards for Information Technology: Identify the appropriate type of database for a particular situation (e.g., flat, relational).
41 Distinguish between a conceptual and a physical database model. NBEA Achievement Standards for Information Technology: Develop design specifications for record types, output, and data stores. ♦ Identify and select logical and physical structures appropriate for specific applications.
43 Identify the characteristics of a relational database. NBEA Achievement Standards for Information Technology: Identify the appropriate type of database for a particular situation (e.g., flat, relational).
44 Examine the database development life cycle. NBEA Achievement Standards for Information Technology: Identify and explain the steps in the systems development life cycle.
45 Research the future direction of database technologies. NBEA Achievement Standards for Information Technology: Analyze how developments in information technology affect the supply/demand characteristics of the job market. ♦ Evaluate how information technology transforms business processes and relationships. ♦ Examine how information technology changes the breadth and level of worker responsibilities. ♦ Identify and evaluate how information technology developments changes the way humans do their work. ♦ Illustrate how information technology changes organization structures.
46 Describe the process of modeling business requirements. NBEA Achievement Standards for Information Technology: Define system requirements using structured systems analysis tools.
47 Apply business concepts to the database model. NBEA Achievement Standards for Information Technology: Identify and apply appropriate application development tools. ♦ Incorporate appropriate human interface design principles.
48 Define entities among elements of significance. NBEA Achievement Standards for Information Technology: Plan and develop record specifications.
49 Define attributes of each entity. NBEA Achievement Standards for Information Technology: Plan and develop record specifications.
50 Select unique identifiers (UIDs). NBEA Achievement Standards for Information Technology: Plan and develop record specifications.
52 Define business rules. NBEA Achievement Standards for Information Technology: Define system requirements using structured systems analysis tools.
59 Identify elements of the graphic representation of a database model. NBEA Achievement Standards for Information Technology: Define system requirements using structured systems analysis tools.
62 Define the normalization process. NBEA Achievement Standards for Information Technology: Normalize a database schema.
63 Perform the normalization process. NBEA Achievement Standards for Information Technology: Normalize a database schema.
65 Model hierarchical data. NBEA Achievement Standards for Information Technology: Identify and select logical and physical structures appropriate for specific applications. ♦ Modify record structures. ♦ Plan and develop a database schema. ♦ Plan and develop record specifications. ♦ Use application development tools associated with a database system to create solutions for organization problems. ♦ Use database application development tools to create information systems to solve organization problems.
66 Model recursive relationships. NBEA Achievement Standards for Information Technology: Identify and select logical and physical structures appropriate for specific applications. ♦ Modify record structures. ♦ Plan and develop a database schema. ♦ Plan and develop record specifications. ♦ Use application development tools associated with a database system to create solutions for organization problems. ♦ Use database application development tools to create information systems to solve organization problems.
67 Model exclusive relationships. NBEA Achievement Standards for Information Technology: Identify and select logical and physical structures appropriate for specific applications. ♦ Modify record structures. ♦ Plan and develop a database schema. ♦ Plan and develop record specifications. ♦ Use application development tools associated with a database system to create solutions for organization problems. ♦ Use database application development tools to create information systems to solve organization problems.
72 Convert a conceptual design to a physical database model. NBEA Achievement Standards for Information Technology: Develop design specifications for record types, output, and data stores. ♦ Identify and select logical and physical structures appropriate for specific applications.
73 Map simple entities, attributes, and primary keys. NBEA Achievement Standards for Information Technology: Identify and select logical and physical structures appropriate for specific applications.
74 Identify data constraints. NBEA Achievement Standards for Information Technology: Identify and select logical and physical structures appropriate for specific applications.
75 Map relationships to foreign keys. NBEA Achievement Standards for Information Technology: Identify and select logical and physical structures appropriate for specific applications.
78 Demonstrate the syntax for select statements (projection). NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
79 Demonstrate methods for selecting columns and arithmetic expressions (selection). NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
83 Restrict data, using the WHERE clause. NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
85 Restrict data, using the BETWEEN ... AND and IN clauses. NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
86 Restrict data, using wildcards and patterns within the LIKE condition. NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
87 Demonstrate the use of the ESCAPE character with wildcard characters. NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
88 Restrict (or specify) data containing nulls, using the IS (NOT) NULL clause. NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
89 Demonstrate the use of two or more conditional statements using logical operators (i.e., AND, OR, NOT). NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
90 Sort data by using ResultSet with the ORDER BY clause. NBEA Achievement Standards for Information Technology: Sort, prioritize, and retrieve data from databases.
94 Define single-row functions. NBEA Achievement Standards for Information Technology: Extract useful information using search queries.
96 Demonstrate the use of character, number, and date functions in SELECT statements. NBEA Achievement Standards for Information Technology: Extract useful information using search queries.
100 Describe the concept of joining data from two or more tables. NBEA Achievement Standards for Information Technology: Extract useful information using search queries.
101 Demonstrate the use of ANSI joins. NBEA Achievement Standards for Information Technology: Extract useful information using search queries.
102 Demonstrate the use of Oracle proprietary joins. NBEA Achievement Standards for Information Technology: Extract useful information using search queries.
117 Insert rows into a table. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
118 Update data within a table. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
119 Delete rows in a table. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
120 Construct a MERGE statement. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
121 Construct a multi-table insert statement. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
123 Create a table. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
124 Create a table, using a subquery. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
126 Define common data types. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
127 Describe date/time data types. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
128 Write code to alter table definitions. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
129 Write SQL code to manipulate column definitions, using DROP, RENAME, and TRUNCATE commands. NBEA Achievement Standards for Information Technology: Enter data and edit fields and records.
152 Create an index. NBEA Achievement Standards for Information Technology: Describe search strategies and use them to solve common information problems.
167 Describe the process and requirements for obtaining industry certifications related to the Database Design and Management (Oracle) course. NBEA Achievement Standards for Information Technology: Obtain database management industry certification(s) needed for a chosen career path.
168 Identify testing skills and strategies for a certification examination. NBEA Achievement Standards for Information Technology: Obtain database management industry certification(s) needed for a chosen career path.
169 Demonstrate ability to successfully complete selected practice examinations. NBEA Achievement Standards for Information Technology: Obtain database management industry certification(s) needed for a chosen career path.