2007/2008 Competency-Based Task/Competency List

Tasks/competencies designated by bullets in the left-hand column are considered essential statewide and are required of all students. In some courses, all tasks/competencies have been identified as essential. Tasks/competencies without bullets are considered optional; they and/or additional tasks/competencies may be taught at the discretion of the school division. Tasks/competencies marked with an asterisk (*) are considered sensitive, and teachers should obtain approval by the school division before teaching them.

6660
36 weeks		 Database Design and Management (Oracle)
TASKS/COMPETENCIES
  Implementing Virginia's CTE Course Requirements
• 001 Demonstrate Virginia's Workplace Readiness Skills in course activities.
• 002 Apply Virginia's All Aspects of Industry elements in course activities.
• 003 Identify Internet safety issues and procedures for complying with acceptable use standards.
  Participating in the Student Organization
• 004 Identify the purposes and goals of the student organization.
• 005 Explain the benefits and responsibilities of membership in the student organization as a student and in professional/civic organizations as an adult.
• 006 Demonstrate leadership skills through participation in student organization activities, such as meetings, programs, and projects.
  Introducing Database Technologies
• 007 Survey the history of databases.
• 008 List the major types of databases.
• 009 Identify the characteristics of a relational database.
• 010 Examine the system development life cycle.
• 011 Distinguish between a physical and a conceptual database model.
• 012 Research the future direction of database technologies.
  Identifying Business Requirements
• 013 Describe the process of modeling business requirements.
• 014 Apply business concepts to the database model.
• 015 Define entities among elements of significance.
• 016 Define attributes of each entity.
• 017 Identify interrelatedness between elements of significance.
• 018 Select unique identifiers.
• 019 Define business rules.
  Drawing Entity Relationship Diagrams
• 020 Identify elements of the graphic representation of a database model.
• 021 Distinguish drawing conventions.
• 022 Illustrate business rules in an entity relationship model.
• 023 Identify relationships.
• 024 Name relationships.
• 025 Compile matrix diagram.
• 026 Connect entities via relationships.
• 027 Explain relationship optionality.
• 028 Explain relationship degree/cardinality.
• 029 Verbalize a diagram's relationship notation.
  Applying Advanced Concepts to Database Models
• 030 Model subtypes.
• 031 Define the normalization process.
• 032 Describe the normalization process.
• 033 Resolve many-to-many relationships.
• 034 Model hierarchical data.
• 035 Model recursive relationships.
• 036 Model exclusive relationships.
• 037 Model historical data.
• 038 Define types of unique identifiers.
• 039 Model complex relationships.
  Transforming the ERD (Entity Related Database) to a Functional Database
• 040 Summarize the database design process.
• 041 Define drawing conventions for readability.
• 042 Relate conceptual design to the physical database model.
• 043 Define relational database terminology.
• 044 Map simple entities, attributes, and primary keys.
• 045 Identify data constraints.
• 046 Map relationships to foreign keys.
• 047 Map advanced modeling concepts to tables.
  Writing Basic SQL (Structured Query Language) Statements
• 048 Describe SQL.
• 049 Distinguish between categories of SQL statements.
• 050 Demonstrate the syntax for basic select statements (projection).
• 051 Demonstrate selecting columns and arithmetic expressions (selection).
• 052 Explain operator precedence.
• 053 Manipulate data presentation.
• 054 Display table structure using DESCRIBE command.
  Restricting and Sorting Data Using SQL
• 055 Demonstrate restricting data using the WHERE clause.
• 056 Demonstrate restricting data using the BETWEEN and IN clauses.
• 057 Demonstrate restricting data using the LIKE and IS NULL clauses.
• 058 Execute statements using logical operators (AND, OR, and NOT).
• 059 Demonstrate sorting return data with the ORDER BY clause.
  Performing Single-Row Functions
• 060 Define single-row functions.
• 061 Describe the types of single-row functions.
• 062 Use character, number, and date functions in SELECT statements.
• 063 Describe the use of conversion functions.
• 064 Demonstrate the use of null character handling.
• 065 Demonstrate the use of conditional expressions.
  Applying Advanced Data Selection
• 066 Describe the concept of joining data from two or more tables.
• 067 Demonstrate the use of Oracle joins (e.g., equijoin, nonequijoin, self join, and outer join).
• 068 Demonstrate the use of ANSI joins (e.g., cross joins, natural joins, right join, and left join).
  Aggregating Data Using Group Functions
• 069 Define group functions.
• 070 Demonstrate the use of group functions.
• 071 Construct code applying GROUP BY clause.
• 072 Construct code applying HAVING clause.
  Performing Subqueries
• 073 Describe the types of problems that subqueries can solve.
• 074 Define subqueries.
• 075 Construct single-row subquery.
• 076 Write a multiple-column subquery.
• 077 Explain the behavior of subqueries when null values are retrieved.
  Applying DML (Data Manipulation Language)
• 078 Describe each DML statement.
• 079 Describe data integrity constraints.
• 080 Insert rows into a table.
• 081 Update data within a table.
• 082 Delete rows in a table.
• 083 Construct a MERGE statement.
  Creating, Managing, and Viewing Tables
• 084 Define Oracle's Data Definition Language (DDL).
• 085 Describe privileges for CREATE TABLE.
• 086 Create tables.
• 087 Describe the Oracle Data Dictionary.
• 088 Define Oracle data types.
• 089 Write code to alter table definitions.
• 090 Write code to manipulate column definitions, using DROP, RENAME, and TRUNCATE commands.
  Defining Database Constraints
• 091 Describe the necessity for database constraints.
• 092 Compare and contrast column-level and table-level constraints.
• 093 List the types of constraints and their applications.
• 094 Write constraints.
  Creating and Managing Views
• 095 Describe a view.
• 096 Create a view.
• 097 Write code to retrieve data through a view.
• 098 Write code to alter the definition of a view.
• 099 Manipulate tables, using the INSERT, UPDATE, and DELETE commands through a view.
• 100 Create code to drop a view.
  Creating Additional Database Objects
• 101 Describe database objects and their uses.
• 102 Define the sequence object.
• 103 Create a sequence.
• 104 Use a sequence.
• 105 Modify a sequence.
• 106 Describe the index object.
• 107 Describe issues that affect the decision to create an index.
• 108 Create an index.
• 109 Create private and public synonyms.
  Maintaining Database Security and System Security
• 110 Define object privileges.
• 111 Construct an object privilege.
• 112 Describe roles.
• 113 Define system privileges.
• 114 Describe system privileges that can be granted to a user.
• 115 Define a database link.
  Making Database Transactions
• 116 Define transaction and transaction controls (e.g., commit, rollback, savepoint).
• 117 Describe the importance of transaction control to businesses.
  Preparing for Industry Certification
• 118 Describe the process and requirements for obtaining industry certifications related to this course.
• 119 Identify testing skills/strategies for a certification examination.
• 120 Demonstrate ability to successfully complete selected practice examinations (e.g., practice questions similar to those on certification exams).
  Developing Employability Skills
• 121 Work effectively in teams.
• 122 Formulate project-specific questions to determine business requirements.
• 123 Determine project requirements through client interview.
• 124 Demonstrate project-management skills.
• 125 Identify careers in the information technology field.
• 126 Investigate certification and educational opportunities.
• 127 Compose or update a printed résumé.
• 128 Prepare an electronic résumé.
• 129 Investigate job opportunities, using the Internet and other sources.
• 130 Create a letter of application.
• 131 Complete an electronic application form.
• 132 Create an interview follow-up letter.
• 133 Identify the steps to follow in resigning from a position.
• 134 Develop a portfolio containing representative samples of student's work (e.g., program design, source code, technical documentation, and output).
• 135 Deliver an oral presentation of portfolio.
• 136 Identify potential employment barriers for nontraditional groups and ways to overcome the barriers.