# CTE Resource Center - Verso - Database Design and Management (Oracle) SOL Correlation by Task

CTE Resource Center - Verso

Virginia’s CTE Resource Center

SOL Correlation by Task

A correlation between each state-approved CTE course and Virginia Standards of Learning (SOL) for English, History and Social Science, Mathematics, and Science has been completed by teams of CTE and academic specialists. The correlation identifies, on a statewide basis, standards reinforced by specific tasks/competencies within each course.

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
1 Demonstrate creativity and innovation. English 6.1, 6.3, 6.4, 6.6, 6.7, 6.9, 7.1, 7.3, 7.4, 7.6, 7.7, 7.9, 8.1, 8.3, 8.4, 8.6, 8.7, 8.9, 9.1, 9.5, 9.6, 9.8, 10.1, 10.5, 10.6, 10.8, 11.1, 11.5, 11.6, 11.8, 12.1, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.4, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WG.4, WHI.1, WHII.1
Mathematics 6.1, 6.2, 6.3, 6.4, 6.5, 6.6, 6.7, 6.10, 6.11, 6.12, 7.2, 7.3, 7.8, 7.9, 8.2, 8.4, 8.6, 8.7, 8.11, 8.12, 8.17, 8.18, A.9, AFDA.3, AFDA.4, AFDA.5, AFDA.6, AFDA.7, AFDA.8, AII.9, COM.1, COM.3, COM.4, COM.5, COM.8, DM.1*, DM.2*, DM.3*, DM.7, DM.10, PS.3*, PS.4*, PS.7*, PS.9*, PS.10*
Science 6.1, BIO.1, CH.1, ES.1, LS.1, PS.1
2 Demonstrate critical thinking and problem solving. English 6.1, 6.3, 6.4, 6.5, 6.6, 6.7, 6.9, 7.1, 7.3, 7.4, 7.5, 7.6, 7.7, 7.9, 8.1, 8.3, 8.4, 8.5, 8.6, 8.7, 8.9, 9.1, 9.5, 9.6, 9.8, 10.1, 10.5, 10.6, 10.8, 11.1, 11.5, 11.6, 11.8, 12.1, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.4, CE.11, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WG.4, WHI.1, WHII.1
Mathematics 6.1, 6.2, 6.3, 6.4, 6.5, 6.6, 6.10, 6.11, 7.2, 7.3, 7.8, 7.12, 7.13, 8.2, 8.4, 8.8, 8.9, 8.10, 8.11, A.8, A.9, AFDA.3, AFDA.5, AFDA.8, AII.9, AII.10, AII.11, COM.1, COM.3, COM.4, COM.5, COM.8, DM.1*, DM.2*, DM.3*, DM.4, DM.7, DM.9*, G.1, G.13, G.14, PS.9*, PS.10*
Science 6.1, BIO.1, CH.1, ES.1, LS.1, PS.1
3 Demonstrate initiative and self-direction. English 6.1, 6.4, 6.6, 6.7, 6.9, 7.1, 7.4, 7.6, 7.7, 7.9, 8.1, 8.4, 8.6, 8.7, 8.9, 9.1, 9.5, 9.6, 9.8, 10.1, 10.5, 10.6, 10.8, 11.1, 11.5, 11.6, 11.8, 12.1, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.4, CE.11, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
4 Demonstrate integrity. English 6.1, 7.1, 8.1, 9.1, 9.5, 10.1, 10.5, 11.1, 11.5, 12.1, 12.5
History and Social Science CE.1, CE.3, CE.4, GOVT.1, GOVT.16, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
5 Demonstrate work ethic. English 6.1, 7.1, 8.1, 9.1, 10.1, 11.1, 12.1
History and Social Science CE.1, CE.4, CE.14, GOVT.1, GOVT.16, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Science CH.1
6 Demonstrate conflict-resolution skills. English 6.1, 6.2, 6.4, 6.6, 6.7, 6.9, 7.1, 7.2, 7.4, 7.6, 7.7, 7.9, 8.1, 8.2, 8.4, 8.6, 8.7, 8.9, 9.1, 10.1, 11.1, 12.1
History and Social Science CE.1, CE.4, GOVT.1, USI.1, VUS.1
7 Demonstrate listening and speaking skills. English 6.1, 6.2, 6.4, 6.6, 7.1, 7.2, 7.4, 7.6, 8.1, 8.2, 8.4, 8.6, 9.1, 10.1, 11.1, 12.1
History and Social Science CE.1, CE.4, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
8 Demonstrate respect for diversity. English 6.1, 7.1, 8.1, 9.1, 10.1, 11.1, 12.1
History and Social Science CE.1, CE.3, CE.4, GOVT.1, GOVT.16, USI.1, USII.1, USII.9, VUS.1, VUS.13, WG.1, WHI.1, WHII.1
9 Demonstrate customer service skills. English 6.1, 6.4, 6.7, 7.1, 7.4, 7.7, 8.1, 8.4, 8.7, 9.1, 9.5, 9.6, 10.1, 10.5, 10.6, 11.1, 11.5, 11.6, 12.1, 12.5, 12.6
History and Social Science CE.1, CE.4, GOVT.1, GOVT.16, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
10 Collaborate with team members. English 6.1, 7.1, 8.1, 9.1, 10.1, 11.1, 12.1
History and Social Science CE.1, CE.3, CE.4, GOVT.1, GOVT.16, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
11 Demonstrate big-picture thinking. English 6.1, 6.4, 7.1, 7.4, 8.1, 8.4, 9.1, 9.5, 10.1, 10.5, 11.1, 11.5, 12.1, 12.5
History and Social Science CE.1, CE.4, CE.12, GOVT.1, GOVT.15, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
12 Demonstrate career- and life-management skills. English 6.1, 6.7, 7.1, 7.7, 8.1, 8.7, 9.1, 9.6, 10.1, 10.6, 11.1, 11.6, 12.1, 12.6
History and Social Science CE.1, CE.4, CE.12, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics 8.4
13 Demonstrate continuous learning and adaptability. English 6.1, 6.4, 6.7, 6.9, 7.1, 7.4, 7.7, 7.9, 8.1, 8.4, 8.7, 8.9, 9.1, 9.5, 9.6, 9.8, 10.1, 10.5, 10.6, 10.8, 11.1, 11.5, 11.6, 11.8, 12.1, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.3, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Science BIO.1, CH.1, LS.1, PH.1, PH.4, PS.1
14 Manage time and resources. English 6.1, 6.2, 6.4, 6.7, 6.9, 7.1, 7.2, 7.4, 7.7, 7.9, 8.1, 8.2, 8.4, 8.7, 8.9, 9.1, 9.5, 9.6, 9.8, 10.1, 10.5, 10.6, 10.8, 11.2, 11.5, 11.6, 11.8, 12.2, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.4, CE.11, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics 6.10, 6.11, 6.12, 7.2, 7.3, 7.8, 7.9, 7.10, 7.11, 7.12, 7.13, 8.4, 8.11, 8.12, 8.13, 8.14, 8.17, 8.18, A.4, A.5, A.8, A.9, AFDA.3, AFDA.4, AFDA.5, AFDA.6, AFDA.7, AFDA.8, COM.1, COM.3, COM.5, COM.8
15 Demonstrate information-literacy skills. English 6.1, 6.2, 6.4, 6.6, 6.7, 6.9, 7.1, 7.2, 7.3, 7.4, 7.6, 7.7, 7.9, 8.1, 8.2, 8.3, 8.4, 8.6, 8.7, 8.9, 9.2, 9.5, 9.6, 9.8, 10.2, 10.5, 10.6, 10.8, 11.2, 11.5, 11.6, 11.8, 12.2, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics 6.10, 6.11, 7.8, 7.9, 8.11, 8.12, A.8, A.9, AFDA.3, AFDA.4, AFDA.6, AFDA.7, AFDA.8, DM.8, PS.1*, PS.2*, PS.3*, PS.4*, PS.7*, PS.8*, PS.9*, PS.10*
Science 6.1, BIO.1, CH.1, ES.1, LS.1, PH.1, PS.1
16 Demonstrate an understanding of information security. English 6.1, 6.2, 6.3, 6.4, 6.6, 6.7, 6.8, 6.9, 7.1, 7.2, 7.3, 7.4, 7.6, 7.7, 7.8, 7.9, 8.1, 8.2, 8.3, 8.4, 8.6, 8.7, 8.8, 8.9, 9.1, 9.2, 9.5, 9.6, 9.8, 10.1, 10.2, 10.5, 10.6, 10.8, 11.1, 11.2, 11.5, 11.6, 11.8, 12.1, 12.2, 12.5, 12.6, 12.8
History and Social Science CE.1, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics COM.10
17 Maintain working knowledge of current information-technology (IT) systems. English 6.1, 6.3, 6.4, 6.6, 6.9, 7.1, 7.3, 7.4, 7.6, 7.9, 8.1, 8.3, 8.4, 8.6, 8.9
History and Social Science CE.1, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics 7.8, COM.1, COM.2, COM.7, COM.9, COM.10, COM.11, COM.16, COM.18, PS.17
Science BIO.1, CH.1, ES.1, PH.1
18 Demonstrate proficiency with technologies, tools, and machines common to a specific occupation. History and Social Science CE.1, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics 6.10, 6.11, 7.9, 8.4, A.7, A.8, A.9, AFDA.1, AFDA.3, AFDA.5, AII.4, AII.7, AII.9, COM.1, COM.7, COM.10, COM.11, COM.12, COM.16
Science CH.1, ES.1, LS.1, PH.1, PS.1
19 Apply mathematical skills to job-specific tasks. English 6.4, 6.6, 6.7, 7.4, 7.6, 7.7, 8.4, 8.6, 8.7, 9.5, 9.6, 10.5, 10.6, 11.5, 11.6, 12.5, 12.6
History and Social Science CE.1, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Mathematics 6.1, 6.2, 6.5, 6.6, 6.12, 6.13, 6.14, 7.1, 7.2, 7.3, 7.4, 7.5, 7.6, 7.8, 7.9, 7.11, 7.12, 7.13, 8.4, 8.5, 8.6, 8.8, 8.9, 8.10, 8.11, 8.12, 8.13, 8.14, 8.15, 8.16, 8.17, 8.18, A.1, A.3, A.4, A.5, A.7, A.8, A.9, AFDA.1, AFDA.3, AFDA.5, AFDA.8, AII.3, AII.7, AII.9, AII.10, COM.1, COM.7
Science 6.1, BIO.1, CH.1, ES.1, LS.1, PH.1, PS.1
20 Demonstrate professionalism. English 6.1, 7.1, 8.1, 9.1, 10.1, 11.1, 12.1
History and Social Science CE.1, CE.4, CE.14, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
21 Demonstrate reading and writing skills. English 6.1, 6.6, 6.7, 7.1, 7.6, 7.7, 8.1, 8.6, 8.7, 9.1, 9.5, 9.6, 9.7, 10.1, 10.5, 10.6, 10.7, 11.1, 11.5, 11.6, 11.7, 12.1, 12.5, 12.6, 12.7
History and Social Science CE.1, CE.4, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Science 6.1, PH.1, PS.1
22 Demonstrate workplace safety. English 6.4, 7.4, 8.4, 9.5, 10.5, 11.5, 12.5
History and Social Science CE.1, CE.4, GOVT.1, USI.1, USII.1, VUS.1, WG.1, WHI.1, WHII.1
Science CH.1
23 Examine aspects of planning within an industry/organization. History and Social Science GOVT.16
28 Examine labor issues related to an industry/organization. History and Social Science GOVT.16
29 Examine community issues related to an industry/organization. History and Social Science GOVT.16
30 Examine health, safety, and environmental issues related to an industry/organization. History and Social Science GOVT.16
39 Research the history of databases. English 10.8, 11.8
History and Social Science VUS.12, VUS.13, VUS.14, WG.17, WHII.12, WHII.14
41 Distinguish between a conceptual and a physical database model. Mathematics COM.10
42 Compare the structure of relational and non-relational database structures. English 10.5, 11.5
43 Identify the characteristics of a relational database. English 10.5, 11.5
44 Examine the database development life cycle. English 10.5, 11.5
Mathematics COM.1, COM.4, COM.6, COM.10, COM.13, COM.16
45 Research the future direction of database technologies. English 10.8, 11.8
46 Describe the process of modeling business requirements. English 10.1, 10.5, 11.1, 11.5
52 Define business rules. English 10.1, 10.5, 11.1, 11.5
54 Distinquish among relationship types. Mathematics A.7, A.8, AFDA.1
63 Perform the normalization process. English 10.5, 11.5
71 Summarize the database-design process. English 10.5, 11.5
Mathematics A.1, COM.1, COM.4, COM.16
72 Convert a conceptual design to a physical database model. Mathematics A.1, COM.10
73 Map simple entities, attributes, and primary keys. Mathematics A.7, COM.14
77 Distinguish among categories of SQL statements. English 10.3, 10.5, 11.3, 11.5
Mathematics COM.14
78 Demonstrate the syntax for select statements (projection). Mathematics COM.14
79 Demonstrate methods for selecting columns and arithmetic expressions (selection). Mathematics A.7, COM.14
80 Incorporate column alias and literals in a SELECT statement. Mathematics COM.14
81 Describe operator precedence. English 10.5, 11.5
Mathematics COM.6
82 Describe methods for displaying a table. Mathematics COM.9, COM.11
83 Restrict data, using the WHERE clause. Mathematics COM.7, COM.13
84 Define comparison operators (e.g., =, >, <, >=, <=, <>, !=) Mathematics A.5, COM.7, COM.13
85 Restrict data, using the BETWEEN ... AND and IN clauses. Mathematics COM.7, COM.13
86 Restrict data, using wildcards and patterns within the LIKE condition. Mathematics COM.7, COM.13
87 Demonstrate the use of the ESCAPE character with wildcard characters. Mathematics COM.7, COM.13
88 Restrict (or specify) data containing nulls, using the IS (NOT) NULL clause. Mathematics COM.7, COM.13
89 Demonstrate the use of two or more conditional statements using logical operators (i.e., AND, OR, NOT). Mathematics COM.8, COM.13
90 Sort data by using ResultSet with the ORDER BY clause. Mathematics COM.7, COM.9
91 Explain the concept of functions. Mathematics A.7, AFDA.1
96 Demonstrate the use of character, number, and date functions in SELECT statements. Mathematics COM.7, COM.8
97 Describe the use of conversion functions. English 10.5, 11.5
99 Demonstrate the use of conditional expressions. Mathematics COM.8
100 Describe the concept of joining data from two or more tables. English 10.5, 11.5
101 Demonstrate the use of ANSI joins. Mathematics COM.3, COM.7, COM.8
102 Demonstrate the use of Oracle proprietary joins. Mathematics COM.3, COM.7, COM.8
103 Define group/aggregate functions. English 10.2, 10.5, 11.2, 11.5
108 Describe the types of problems that subqueries can solve. English 10.5, 11.5
110 Construct a single-row subquery. Mathematics COM.9
111 Construct a multi-row subquery. Mathematics COM.9
112 Construct a correlated subquery. Mathematics COM.9
113 Write a multiple-column subquery. Mathematics COM.9
114 Explain the behavior of subqueries when null values are retrieved. English 10.5, 11.5
Mathematics COM.3
115 Describe data manipulation language (DML). English 10.5, 11.5
117 Insert rows into a table. Mathematics COM.14
118 Update data within a table. Mathematics COM.14
119 Delete rows in a table. Mathematics COM.14
123 Create a table. Mathematics COM.14
124 Create a table, using a subquery. Mathematics COM.14
125 Describe the data dictionary. English 10.5, 11.5
127 Describe date/time data types. English 10.5, 11.5
128 Write code to alter table definitions. Mathematics COM.1, COM.3
129 Write SQL code to manipulate column definitions, using DROP, RENAME, and TRUNCATE commands. Mathematics COM.1, COM.3
131 Describe FLASHBACK. English 10.5, 11.5
132 Describe the necessity for database constraints. English 10.5, 11.5
Mathematics COM.3
134 List the types of constraints and their applications. English 10.5, 11.5
Mathematics COM.3
135 Write a table- and column-level constraint. Mathematics COM.3
137 Describe a view. English 10.5, 11.5
139 Write SQL code to retrieve data through a view. Mathematics COM.1, COM.3
140 Write SQL code to alter the definition of a view. Mathematics COM.1, COM.3
141 Manipulate tables, using the INSERT, UPDATE, and DELETE commands through a view. Mathematics COM.7
142 Write SQL code to remove a view. Mathematics COM.1, COM.3
145 Describe database objects and their uses. English 10.5, 11.5
165 Describe the importance of transaction control to businesses. English 10.5, 11.5
167 Describe the process and requirements for obtaining industry certifications related to the Database Design and Management (Oracle) course. English 10.5, 10.8, 11.5, 11.8